Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Field conditional to date

193 1
cancel
Showing results for 
Search instead for 
Did you mean: 

This should be easy but i am not succeeding in getting it done.

I have a field named “month” and i want it to change according to a date field. If the date is in October i want that field to have the word “October”. I have it as a single select field but i would like it to be automatic. How can i do this? Be it an automation or function or zapier or whatever.

Thanks in advance.

1 Reply 1

Either convert the single select into a formula field, or create a new formula field, with this formula:

DATETIME_FORMAT({Date Field}, "MMMM")

If you want to keep your original single select field, use an Automation to copy the value of the formula field into the single select whenever the value of the formula field changes. This is going to eat into your monthly allotment of automation runs so this may not be sustainable without using a script to reduce the number of times the automation should run.