Hi !

I created a form where users may register for events on a date they selected in a calendar field.
There is a menu option to display submissions using the directory feature of RS Form pro, but past dates should not be displayed as it makes no sense.
How can I filter directory listing to todays and future dates?

As I am not a coder I would be very grateful if somebody could provide a complete PHP script to do that.

THANK YOU !

No one?

Here is a solution from RSJoomla

- enable the 'Show only confirmed submissions' option from your Submission Directory menu item.

- navigate to backend > Components > RSForm!Pro > Manage Directories > your form > PHP Scripts > Scripts called on listing layout. Here, you can use a similar as the following script:

$today = date('d.m.Y');
$range = strtotime($today);
$flag = 0;
$db = JFactory::getDBO();
$db->setQuery("SELECT `SubmissionId`,`FieldValue` FROM #__rsform_submission_values WHERE `FormId`=81 AND `FieldName`='myCalendarName'");
$info = $db->loadObjectList();

foreach($info as $inf){
if(strtotime($inf->FieldValue) < $range){
$db->setQuery("UPDATE #__rsform_submissions SET `confirmed`=0 WHERE `confirmed`=1 AND `SubmissionId`='".$inf->SubmissionId."'");
$db->execute();
if($db->getAffectedRows() > 0)
$flag = 1;
}
}
if($flag == 1){
header("Refresh:0");
}

You'll have to replace the followings:

1. The number:

`FormId`=81

With your form ID.

2. The following string:

myCalendarName

With your calendar exact name.