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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |