Zapier needs it but you don’t, so it’s best to get it out of the way. Now you see that you have a normal text value in your Lookup field. (In our example the first one is the linked field in the current table, the second one-the field in the People table that contains a value you are interested in- ‘Name’ in our case)Īfter you do that you will see something like this: In the first dropdown select the ‘Creator(s)’ field. It is the ID for the linked record from our ‘People’ table (which we discussed in our previous article: How to merge multiple tables into one in Airtable).ĭoesn’t make any sense for human beings you say?ĭon’t worry, we have a solution! Adding Lookup fieldĦ – Go to your Airtable and add a new column, Field type – Lookup: This is an ID that corresponds to a particular “Creator” in your Airtable base. If you look at the value of the ‘Creator (s)’ parameter (marked with a red rectangle in the screenshot above), you will see a random string of letters and numbers. You can do this in your Airtable account settings (this only needs to be done once):Ĥ – Select the Base and the Table you will be pulling data from:ĥ – After a few seconds of waiting you’ll get 3 sample records pulled from the table you selected: NOTE: To connect your Airtable account to Zapier you will need to generate an API key. We then send a weekly “report” to our Slack group so that everybody in the team is informed about the progress we made for the week.Ģ – Select ‘New record’ as an Airtable trigger event: We collect all of these improvements using Zapier. We have a table to track all improvements we make to our processes, documentation, etc. Let’s illustrate the setup process, using as an example a small automation from our business. *We can host your zap for you for $3/mo IF you hire us to set it up for you. A paid Zapier account* (free account doesn’t allow multistep zaps, which you’ll need for this).However, Zapier easily solves this problem. You can’t do this natively with Airtable. The new fields should appear as options that you can map values to.We use Airtable in our business almost everywhere!īut it lacks automation for some routine things.įor example, sometimes you need to pass a value to Zapier from a linked record in your base to perform an automation with your Zap. For the ‘Record’ field, map to the ID field from the ‘Find Record’ action. Select the option to ‘Create Airtable Record if it doesn’t exist yet’. The new fields should appear as options, and you can map values to them. Rather than using a ‘Create or Update Record’ action, use a ‘Find Record’ action.Workaround: Use ‘Find Record’ and ‘Update Record’ in tandem to recreate the functionality of ‘Create or Update Record. Reconnecting my Airtable account had no effect.However the one place where the new fields do not show up is as fillable options in the body of the ‘Create or Update Record’ action. After a couple of minutes the changes did properly sync with most areas inside of Zapier: if I search for a record in this base, it returns the new fields in the ‘Create or Update Record’ action the new fields show up as Lookup Field options. Problem: When new fields are created, or existing fields are renamed in Airtable, they do not sync over as fillable options in the ‘Create or Update Record’ action.Īdditional information: I added the new fields to the Airtable base about an hour ago. In my case the problem seems to be isolated to the ‘Create or Update Record’ action. Reviving this old thread, as there is still an ongoing issue here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |