Hi,
Using RSForms, I request that users select an Event Date for a timesheet. I would like to then take that selected date and have a list of events populate that match that Event Date, displayed in a drop down list. Is that possible with RSForms?

I am currently using the following following PHP / SQL code to populate the drop down event list, but need to add the parameter that will have only the Events on that date display.

Thank you in advance, Steve

//<code>
$items = "|[c]\n";
$db =& JFactory::getDBO();
$db->setQuery("SELECT DISTINCT title FROM table1 m, table2 r WHERE m.id = r.event_id AND r.begin > '2021-10-01 00:00:00' ORDER BY title");
$result = $db->loadObjectList();

foreach ($result as $r)
$items .= $r->title . "\n";

return $items;
//</code>