Custom field SQL with Where clause

Hi Tuan,

I wish to pre-set fields in the checkout forms when a registered user checkout for an event.
By the way, the first and last name and email are already pre-set (but i don't know how....)

Is there a way to create a SQL custom field with a WHERE clause to get information related to the logged user (a Where clause which use the userId)

Regard,
Robert

Hello Robert

Where data for the registered user is stored? If you use Joomla core user profile or custom fields, or some of the supported third party extensions, then you can map the fields for the system to pre-fill the data. See eventbookingdoc.joomservices.com/basic-s...hronize-profile-data for more information

Tuan

Thanks Tuan for your quick and useful answer !

You're welcome

Hi I'm trying to do the same thing whereby a registered user has a joomla custom field in their profile called "Location".
Using j!4.3.3 and EB 4.5.0
I'm using a Joomla Registration Field with the following sql: The mapping works in the Billing form but its not mapped in the Group member form. Is there any way to get the mapping to work here too?
Alternatively it would be great to have a plugin that would recognise the id of the logged in user using a shortcode.
Then we could use a EB sql field: does this option exist?

Hello

If I understand your question correctly, you can use [USER_ID] tag in the SQL to get Joomla User ID of the registrant. So the SQL becomes:

Regards,

Tuan

Awesome - didnt know this was possible - this is a game changer!!

That was supported from some time ago, I should have it better documented

Tuan