0
Undo
Votes
I manage a few Joomla websites for car clubs and they all use the basic J-Events calendar. Some have requested the ability for members to register for an event in the calendar which i believe can be done using RSVP Pro. These events will be motoring events and users will need to include the particulars of vehicle they will be bringing to the event.
I have added extra fields to Joomla User accounts that define the members vehicles, each user can have several vehicles registered in their Joomla user profile.
Is there a custom field option available in RSVP Pro where by i could use an SQL query to build a select list in the RSVP Pro event to allow registrants to choose a vehicle based on the data in the "_fields_values" table.
I have added extra fields to Joomla User accounts that define the members vehicles, each user can have several vehicles registered in their Joomla user profile.
Is there a custom field option available in RSVP Pro where by i could use an SQL query to build a select list in the RSVP Pro event to allow registrants to choose a vehicle based on the data in the "_fields_values" table.
Hello,
Yep Certainly. You can also build your own custom fields for RSVP Pro since we scan the RSVP Pro fields folder for the fields so if you created a new it would be auto loaded to be selected.
Many thanks
Tony
Yep Certainly. You can also build your own custom fields for RSVP Pro since we scan the RSVP Pro fields folder for the fields so if you created a new it would be auto loaded to be selected.
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hey,
sorry for crashing the thread. But I do have exact the same question for jevents pro custom fields plugin. Tony, is this also valid for the custom field type: 'Database field list'? Can you easily add an where clause to the query? Or create your own? Couldn´t find anything about it in the documentation.
thanks!
Toni
sorry for crashing the thread. But I do have exact the same question for jevents pro custom fields plugin. Tony, is this also valid for the custom field type: 'Database field list'? Can you easily add an where clause to the query? Or create your own? Couldn´t find anything about it in the documentation.
thanks!
Toni
The database field list allows you to get data related to the user using a query like this
SELECT ug.title FROM #__usergroups AS ug
INNER JOIN #__user_usergroup_map AS ugm ON ugm.group_id = ug.id
WHERE ugm.user_id={ATTENDEE_USER_ID}
LIMIT 100
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
No Book - I thought that is what you were asking - i,e, how to add a where clause to the SQL type field
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.
Members Area
Show your support
Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons
Your membership will ensure that JEvents continues to be the best events calendar for Joomla.