Hi Community, I am trying to set up a validation rule for a datetimeinterval field in ConfiForms. The goal is to ensure that users can only select a start date that is at least 10 business days in the future. However, I’m having trouble making this work as expected. I’ve attempted to use a validation rule to enforce this, but the system either allows invalid dates or fails the validation entirely, even when the input is correct. Here’s the situation: * I want to restrict the start date of the event to be at least 10 business days from the current date. * The formula I’ve tried for this doesn’t seem to account for business days properly or might not be supported in my ConfiForms instance. My Questions: * Is there a reliable way to create a validation rule for business days in ConfiForms? * If business day calculations are not natively supported, is there a recommended workaround? * What is the best approach to ensure users comply with this requirement? Thank you in advance for your help! I’m happy to provide more details if needed. 😊

Take a look please at the docs on this function https://wiki.vertuna.com/spaces/CONFIFORMS/pages/2359385/Virtual+functions and the version it is supported on

What version of ConfiForms are you using?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Rule for Date Field (10 Business Days in the Future)

Enrico Mancuso

Hi Community,

I am trying to set up a validation rule for a datetimeinterval field in ConfiForms. The goal is to ensure that users can only select a start date that is at least 10 business days in the future. However, I’m having trouble making this work as expected.

I’ve attempted to use a validation rule to enforce this, but the system either allows invalid dates or fails the validation entirely, even when the input is correct.

Here’s the situation:

I want to restrict the start date of the event to be at least 10 business days from the current date.
The formula I’ve tried for this doesn’t seem to account for business days properly or might not be supported in my ConfiForms instance.

My Questions:

Is there a reliable way to create a validation rule for business days in ConfiForms?
If business day calculations are not natively supported, is there a recommended workaround?
What is the best approach to ensure users comply with this requirement?

Thank you in advance for your help! I’m happy to provide more details if needed. 😊

Accepted answers

All comments

Alex Medved _ConfiForms_

Hi @Enrico Mancuso

You can try to employ the workDaysTo function from ConfiForms https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

and have a validation rule with a condition like this (assuming your datetimeinterval field is called dti)

dti.startDate.workDaysTo([entry._now]):<-10

Alex

Enrico Mancuso

Its not working: here my source


<ac:structured-macro ac:macro-id="292d2d52-695a-4e10-9385-c16f369bbc5f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">start</ac:parameter>
<ac:parameter ac:name="fieldLabel">Beginn</ac:parameter>
<ac:parameter ac:name="values">30</ac:parameter>
<ac:parameter ac:name="extracontext">true</ac:parameter>
<ac:parameter ac:name="type">datetime</ac:parameter>
<ac:parameter ac:name="validation">start.workDaysTo([entry._now]):<-10</ac:parameter>
</ac:structured-macro>


<ac:structured-macro ac:macro-id="ac2db946-ca67-4e19-a756-10a32a7403a6" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">end</ac:parameter>
<ac:parameter ac:name="fieldLabel">Ende</ac:parameter>
<ac:parameter ac:name="values">30</ac:parameter>
<ac:parameter ac:name="extracontext">true</ac:parameter>
<ac:parameter ac:name="type">datetime</ac:parameter>
</ac:structured-macro>

Alex Medved _ConfiForms_

Ok, so there is no datetimeinterval field... and the validation needs to be implemented with a ConfiForms Field Definition Rule

https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-Validationrule

Enrico Mancuso

Jetzt so:

<ac:structured-macro ac:macro-id="541919e2-11ff-49fc-ae73-98966cb3122d" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">start</ac:parameter>
<ac:parameter ac:name="fieldLabel">Beginn</ac:parameter>
<ac:parameter ac:name="values">30</ac:parameter>
<ac:parameter ac:name="extracontext">true</ac:parameter>
<ac:parameter ac:name="type">datetime</ac:parameter>
</ac:structured-macro>


<ac:structured-macro ac:macro-id="ac2db946-ca67-4e19-a756-10a32a7403a6" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">end</ac:parameter>
<ac:parameter ac:name="fieldLabel">Ende</ac:parameter>
<ac:parameter ac:name="values">30</ac:parameter>
<ac:parameter ac:name="extracontext">true</ac:parameter>
<ac:parameter ac:name="type">datetime</ac:parameter>
</ac:structured-macro>


<ac:structured-macro ac:macro-id="11e3a8ed-e792-402d-b135-96f89d315e97" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">start.startDate.workDaysTo([entry._now]):<-10</ac:parameter>
<ac:parameter ac:name="fieldName">Hold!</ac:parameter>
<ac:parameter ac:name="values">.</ac:parameter>
<ac:parameter ac:name="action">Validation rule</ac:parameter>
<ac:parameter ac:name="actionFieldName">start</ac:parameter>
</ac:structured-macro>

Jonathan Saldarriag

Hi Alex,

I found this post because I need the same thing but the form is a bit more complex and has more rules. I used the last expression but the entry gets created without an issue, but it should show the error message.

The condition we have is

deadlineSubmission.workDaysTo([entry._now]):<-10 AND typeCustomer:existingCustomer AND typeAssessment:InfoSecReview

I could not write the source code because of max characters

Jonathan Saldarriag

Should that line be in the condition part or below in the validation rule?

Jonathan Saldarriag

I just created a mini form with this. The form is letting me select any date:

<ac:structured-macro ac:macro-id="4055eed5-1451-435c-91c9-3c3ddf6244a5" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">testdays</ac:parameter>
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:rich-text-body>

 

</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="5d01bff9-56d1-43e5-ab75-fd97956dd7d0" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">testdays</ac:parameter>
<ac:rich-text-body>

<ac:structured-macro ac:macro-id="ec4abb99-53e5-43e5-9830-371fa16c4bce" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">start</ac:parameter>
<ac:parameter ac:name="fieldLabel">Beginn</ac:parameter>
<ac:parameter ac:name="values">30</ac:parameter>
<ac:parameter ac:name="extracontext">true</ac:parameter>
<ac:parameter ac:name="type">date</ac:parameter>
</ac:structured-macro>


<ac:structured-macro ac:macro-id="d3c03728-80ce-4cdc-9263-729981feb4d8" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">start.workDaysTo([entry._now]):<-10</ac:parameter>
<ac:parameter ac:name="fieldName">Hold!</ac:parameter>
<ac:parameter ac:name="action">Validation rule</ac:parameter>
<ac:parameter ac:name="actionFieldName">start</ac:parameter>
</ac:structured-macro>

</ac:rich-text-body>
</ac:structured-macro>

Alex Medved _ConfiForms_

This is a correct condition

start.workDaysTo([entry._now]):<10

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

data-center

addon-com.vertuna.confluence.plugins.confiforms

confiforms

confluence-data-center