Change a Status field to Active in a table if the Inception Date filled is equal to the Inception Date
Hi Team,
I want to automatically update the drop down Status Field in my table to Active once the Inception date field is equal to the date in the inception date field. Can you please let m eknow if this is doable if yes can you please confirm how?
Thanks!
Bhawana Pandey

-
Bhawana Pandey commented
coalesce({Override Status Field}, [If{Inception Date="today", "Active"]) will this work.
-
Caroline Stuhr commented
Hi there!
Thanks for reaching out and I hope you had a nice weekend!
You are able to do this with an app script, however it sounds like you'd be better off changing the status field to a 'Calculated Text' field with a formula instead (ie if xxx dates are equal, then set to "Active"). Feel free to send an email to Support with additional details (table names, field names, etc.) if you need any further assistance with this.
Best,
Caroline