Jan 14, 2022 04:41 AM
I can’t work this out: I would like to create a record in a existing view, populate the record fields (including adding an attachment), but hide this record until a scheduled time, when it would then become visible in the view. Is this possible? How? Appreciate the help.
Jan 14, 2022 04:55 AM
Create a date field for the date on which you want the record to appear. Then filter the view to show records where the date field is on or before today.
Jan 14, 2022 06:55 AM
Thanks for this. And if I want the record to show at a set TIME on the SAME DAY as I’m setting up the record?
Jan 14, 2022 07:12 AM
Appearing at a specific time is much more tricky. Methods that involve the formula function NOW()
do not work well because NOW()
can be anywhere from a few minutes to an hour or more off.
If you always want a specific time of day, you can have an automation that runs at that specific time of day and updates the record. It can get tricky to identify that record in the time based automation. It either needs to be the only record that matches conditions, or you need a script. Even so, the time based automations are not always exact (although they are more reliable than NOW()
.
Jan 14, 2022 07:24 AM
OK, again thanks. Looks like the solution is beyond my pay grade! :grinning_face_with_smiling_eyes:
Feb 15, 2023 02:53 PM
Also really needing to figure out how to do this and am getting ZERO responses from Airtable Enterprise support.