Custom Date Field
Ninox Profile

Hey guys,

I was wondering if theres any way to add your own date depending on the period. We use a period choice field that defines specific days. 

Screen Shot 2018-05-10 at 4.30.19 PMScreen Shot 2018-05-10 at 4.32.40 PM

Is there any way to make it that once you switch to the 3rd period, the date below would change to Jan 27, 2018 and if it was the 4th period, it would change to Feb 28, 2018?

 

Ninox Profile

You could allocate specific dates to a period and use a nested if / else statement.

Date := if Period = 3 then "Jan 27, 2018" else if Period = 4 then "Feb 28, 2018" else ""

You can put the trigger on the Period field. 

Let me know if this goes into the right direction.

 

Ninox Profile

Thank you alex, it works great!

Thanks.

Reply