Can you reject Confiform submissions based on the date submitted?

Jane Smith_m7slch

Hi there,

I'm new to Confluence/Confiforms, so still learning a lot on the functionality. I'd like to create a rule for my form to reject submissions based on the target date on the form.

For example, let's say we have an Event submission form with a field titled "date" which is when the event is scheduled. There are 2 types of events: internal and external. I'd like for the entry to be rejected and send an email to the user based on one of the two criteria:

1. If event is internal, reject if submission is less than 4 weeks of the "date"

2. If event is external, reject if submission is less than 8 weeks of the "date"

For example, if the form was submitted on 11/27 and the external event is on 11/29, reset and send the user an email detailing the reason why.

Alex Medved _ConfiForms_

Hi @Jane Smith and welcome to this community

You can set up a Validation Rule https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-Validationrule checking for that

Basically checking against the value with added milliseconds (omitting the check for the event type, but this should be added into the condition as well... assuming here it;s about internal event)

date:<([entry.date.add(2419200000)])

or

date:<([entry.date.timestamp] + 2419200000)

Where 2419200000 is 28 days in milliseconds (4 weeks)

 

Alex