fields connected to userid

[peppe10]

Hello everyone, after a long time I go back to ask if anyone has managed to find a solution to this post

http://fabrikar.com/forums/index.php?threads/fields-connected-to-userid.48624/#post-254571

 

[troester]

See original post.

 

[peppe10]

thanks troester, could you help me to load the php code in the default settings of the element?

if so, I still have a paid subscription

Thanks again

 

[Sophist]

My answer would be not to duplicate data that is already held in the database, but instead to join to the Joomla users table and access the data directly.

 

[troester]

The problem is that you can't just "join" the custom fields, they are data themselves (so I never use them).
You'll have e.g.
View attachment 17379
and then
View attachment 17380

 

[Sophist]

Ah - I see what you mean - there is only a name field rather than separate firstname / surname fields.

And yes - creating separate firstname and surname fields using Joomla's custom fields are going to be much more complicated to access then a column in the users table.

If it were me, I would either:

a. Use Fabrik calculated fields to extract the firstname and surname as the first and last words from the Joomla user name field; or

b. create an SQL View on the Joomla users table that does the same.

Ok - handling names like F. Scott Fitzgerald Jr. would require more complex logic, but for Frank J. Sinatra it would work just fine.

 

[peppe10]

Thank you all, but I think it will be difficult for me alone.
How should I start?
Thanks again

 

[peppe10]

who could help me solve the problem, even paying? thank you all

 

[peppe10]

some administrator may be available to help me solve the problem, on payment?