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; } } }

Confiforms field definition rules - condition date syntax

JN_8e58pg

Hi Alex,

I have an existing filter in my confluence calendar that limits the number entries on any given day

What I'd like to do is allow an additional entry (go from 2 to 3) for a given month or period, say Mar and Apr (but only during this time) - how do I go about specifying that in the condition filter?

Thanks
Jonathan

Accepted answers

Alex Medved _ConfiForms_

What filtering condition do you have at the moment?

Alex

All comments

Alex Medved _ConfiForms_

What filtering condition do you have at the moment?

Alex

JN_8e58pg

Hi Alex,

It's a condition you helped me with previously:

(Date:[entry.Date] AND ChangeControl:true AND !id:[empty] AND _count:>=1) OR (Date:[entry.Date] AND ChangeControl:false AND _count:>2) OR (Date:[entry.Date] AND _count:>2) OR ((Date:[entry.Date] AND _count:>1) AND (ChangeControl:true AND _count:>0))

Alex Medved _ConfiForms_

Cannot remember, sorry - too many conversations :-)

The idea would be to add use of formatDate with specific pattern from https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

Basically checking the "month" in addition

Date.formatDate(M):3

(3 goes for March, 4 for April, according to docs)

Alex

JN_8e58pg

fantastic - thanks for that, i'll give it a go and let you know if I get it working

Andrzej_9aqyeb

Hello @Alex Medved _ConfiForms_

Could you help to add condition which will accept only dates which are from the current and upcoming years? The past years shloud be not allowed

I tried a lot of rules

[formatDate(entry.AllocationStart, "yyyy")] < [formatDate(today, "yyyy")] OR [entry.endDate] < [entry._today]

Alex Medved _ConfiForms_

Condition for the validation rule would be something like this (assuming your field to check is named "date")

date.formatDate(yyyy):<[entry._now.formatDate(yyyy)]

Andrzej_9aqyeb

I need to validate the field that is added while filling the form (from the dropdown).

And then, if someone decides to select an option from a dropdown, I'm adding a new field, but this field cannot be empty. It must be filled whenever someone chooses the option 'No' from my dropdown and is trying to submit the form...

Alex Medved _ConfiForms_

Sorry, I dont understand your comment/requirements

What you want to validate and when?

Welcome!

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

Quick Links

Find more posts tagged with

confluence

field

date

confiforms

calendar