This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Iโd like defaults for long text - use case is a checklist of tasks. I know I could make each check a single field but theyโre really not worth their own fields for my use case.
It would be great to have a default โTimeโ set when choosing the date field. We have a table dedicated to logging employee time off, and when they are filling the form out, it would make it easier and faster for the start time to default to 8:00am and end time to default to 5:00pm. The start and end DATE could still pull from what the current day is. It would help when sending this information to Zapier to correctly interpret what a โfull dayโ is.
When a new user is onboarded into our platform, we have a certain number of steps we want the user to go through to complete their onboarding. We track these steps in a Status column thatโs field type is โSingle selectโ. The field has four different options, and we want the first option to be the default when a new user is added to the table. As you all know, this isnโt possible in Airtable for the moment. However, it occurred to me that Airtableโs new(ish) Automations feature might be able to solve the problem, and the good news is that it did. :slightly_smiling_face:
Steps to create a default value for a Single select field type using an Automation:
Click Automations (top-right) >> New Automation
Name the automation
Click โChoose Triggerโ button
Click โWhen a record matches a conditionโฆโ
Under Conditions, select โWhen [Status] [is empty]โ
In the โSelect a tableโ field, select the table where the record is created (e.g. Users), and click โRun testโ (make sure the test runs successfully, you will need a record with an empty Status)
Click โDoneโ
Screenshot for reference on the โTriggersโ segment (Steps 1โ7)
Click โAdd Actionโ
Click โUpdate Recordโ
Under โRecord IDโ click the [+] button
In the dropdown, next to โRecord (from Step 1)โ, click โContinueโ
From the list select โRecord IDโ
Click โChoose Fieldโ
Click โStatusโ (or whatever your field you want to update)
In the Status field, enter the text of the default status (in our particular case, the default status is โOn Deckโ), and click Run test (make sure the test ran successfully)
Click Done
Last, but not least, make sure to toggle the Automation to ON in the top-right corner.
Screenshot for reference on the โActionsโ segment (Steps 8โ17)
::phew:: That was a lot! And a bit confusing, to be honest. Setting the Record ID (step 10) and entering the default value (step 15) were not clear at all when I was going through this. I hope this helps some of you!
I havenโt found any other automated solution besides Set defaults on fields (but itโs more work, and count towards your automation executions count)
me too โฆ this one of the real time-wasters in my current project testing out Airtable; yes i saw the workarounds, and if i had thousands, rather than just a couple hundred records to deal with, it would be worth the effort to build the workaround
IT is very disappointing to see this feature was never actions in 5 years. I just started using airtable, thinking it would replace an old spreadsheet I have. This was my first requirement beyond the simple spreadsheet functionality.
Exactly Emre, unfortunately they are way more interested on new functionality than simple issues in the base product. I loved Airtable, told everyone it was the answer to every problem but Iโm completely disillusioned with it now