+9Hello Airtable Community,
Question: My main field (first left field) is the "Date", next field is "Day of the Week" (single select). Is it possible to automate "Day of the Week" field so it would automatically choose the day based on the calendar date input in the "Date" field?
Thank you in advance for your help
Best answer by pressGO_design
Yes, although you would use a formula, not at automation. More info here.
+9Yes, although you would use a formula, not at automation. More info here.
Thank you, this path is a partial solution, now it shows the day of the week but in a weird format "1 - Monday", not sure how to get rid of "1 -" in the beginning
+21DATETIME_FORMAT({Date Field}, 'dddd')Just use this ^^^
+9Yes, although you would use a formula, not at automation. More info here.
This is exactly what I was looking for, thank you very much, you are a creative mind
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.