User data table fields

[strawberry]

Hi
Thanks for the great form component.

I would like to show the name and email field from the users-table (jos_user) in another table that I create with Fabrikar, so this would match with user data from both forms (or I would not even need to ask the user to fill out this information).
How would I do that? I should be able to write a SQL statement, but dont know where to put it in. Have restricted the registered user to his view data.

Do I need the SQL Plugin?
I am so close to finish my projekt with this, so really would appreciate a hint

 

[jfquestiaux]

If I understand correctly, you have a table that you created where your users have recorded some information. Let's call this table "extra_data".

In "extra_data" you should have an element recording the user ID (let's say it is "user_id").
Then you have to add a join from "extra_data" to the jos_users table like this :
Open your "extra_data" table:
In the "data" tab, click on Add for Joins - choose inner or left join, from "extra_data" to "jos_users" from column "user_id" to "id".

In the joined group created, you unpublished the fields you don't need.

 

[strawberry]

Table JOins

Thank you so much, the data is there
Made one step further.
Now getting to format it and eventually coming back with more questions