0

Custom Date Field

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?

2 replies

null
    • Alexander_Koenig
    • 6 yrs ago
    • Reported - view

    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.

    • Agus
    • 6 yrs ago
    • Reported - view

    Thank you alex, it works great!

    Thanks.

Login to reply

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 1606Views