Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 17, 2023 05:16 PM
Hi folks, I know you can prefill dates in forms using URL functions. In this case, I don't need it to happen in a form, but on new record creation. I can use a formula for "today" - but it's uneditable for the small number of instances where it needs to be overridden.
It's helpful to have "default values" for number fields, but it seems weird there is no default for date fields. Surely I am missing something obvious?
Solved! Go to Solution.
Jul 17, 2023 06:31 PM
Hey @oreocereus, me again 😂
Given your other question, I'm assuming this is gonna be mobile-centric, in which case you won't be able to leverage record templates. The good news is we can recycle that formula field with TODAY() in it, and do what you need using a simple automation:
The expected outcome from this automation would be that whenever a new record is created, the editable date field (read: field that can be overwritten) defaults to today's date since the formula field will ALWAYS be today's date.
Let me know if that works!
Jul 17, 2023 06:31 PM
Hey @oreocereus, me again 😂
Given your other question, I'm assuming this is gonna be mobile-centric, in which case you won't be able to leverage record templates. The good news is we can recycle that formula field with TODAY() in it, and do what you need using a simple automation:
The expected outcome from this automation would be that whenever a new record is created, the editable date field (read: field that can be overwritten) defaults to today's date since the formula field will ALWAYS be today's date.
Let me know if that works!
Jul 17, 2023 08:07 PM
Bingo, nice one - that works. A shame airtable don't make a few of these things stock, but so it goes. I guess needing many automations is a good way to encourage upgrades on plans hah.