Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 11, 2022 02:31 PM
Airtable Friends!
I have a linked field that is pulling records from our vendor database, which lives in a separate workspace. This database contains a master list of vendors, which admins update when a new vendor enters the game.
In our main working base that contains the linked field, daily users can then add vendors to a specific record if they are part of that job.
I need to check off that the vendor has been onboarded in a field next to the linked field which contains the vendors name. So I’m wondering if it’s possible to:
-when a user adds a vendor name to our linked field, could it populate a multi-select field with the vendors name as an option? even better, a checkbox field.
Solved! Go to Solution.
Aug 12, 2022 12:39 PM
If you just add the field to the Update Record step but don’t put anything in it, it should clear the value.
Aug 11, 2022 02:39 PM
You could add an Automation set up like this:
Trigger: When the Record Link field is not empty (or when Record Link field is updated)
Action: Update Record and set the checkbox to checked.
If you wanted to use a multiselect field, adjust the Action to insert the value of the Link field by clicking the gear icon next to the field, click dynamic, and select the appropriate field to pull from
Aug 12, 2022 10:18 AM
Amazing, thank you for this! Quick question - the automation is running successfully, but it adds the vendor name to the multi-select field right away. is there a way for it to just add the vendor name in the dropdown list, then a user can manually select that vendor once they complete onboarding?
Aug 12, 2022 10:40 AM
This is going to sound silly because it is: Add another Update Record step after that to clear the value of the field.
Otherwise you could replace the Update Record step with a script that adds the new Link Record’s name as an option to he multiselect field
Aug 12, 2022 10:58 AM
Automation scripts cannot add options to multiselect fields. Button scripts can add options, and the “Update Record” automation action can. But automation scripts cannot.
Aug 12, 2022 11:01 AM
Copy, thanks! Not seeing an option anywhere in the Automation interface that would allow we me clear the information in a field though.
Aug 12, 2022 12:39 PM
If you just add the field to the Update Record step but don’t put anything in it, it should clear the value.
Aug 12, 2022 02:04 PM
That works! Thank you again for all of your help!
Aug 15, 2022 07:12 AM
Last question…promise. :slightly_smiling_face:
If the linked record is blank, the automation runs no problem, but how do i get it to also run when i enter a second linked item in that field? Ultimately, the linked record field and the multi-select field should mirror each other. When a vendor’s onboarding is successful, i can then “check” them off as complete.
Aug 15, 2022 09:02 AM
Change the trigger from “record matches conditions” to “record is updated” and watch for changes to the Link Field