Help

Autofill Lookup field when importing data

Topic Labels: Automations
Solved
Jump to Solution
1008 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Zach1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

This is my first day with Airtable and I have a question. 

Ill be importing data via a webhook. Just one location per import (or filled out form that is imported to my Airtable). I I've connected each location to a individual ID for future export. I connected the ID's to all possible locations to choose from, and I want the ID for the imported location to show up besides it. However the ID's dont show up automatically.

Probably a bit of a messy explanation, so here are some pictures:

The first picture is where I want the ID's to show up. So beside the "ort" column is the "ort ID". I added this ID manually to make it more clear. On the second picture are all the possible "ort" and their respective ID's. So when importing a "ort" from my website form (automatically) I want Airtable to pull the correct ID from the other table and display it beside the "ort" on the first place. How do I do that?

Screenshot 2023-06-19 at 21.14.15.png

Screenshot 2023-06-19 at 21.14.40.png

  

1 Solution

Accepted Solutions
Zach1
5 - Automation Enthusiast
5 - Automation Enthusiast

Well guys, seems like Im just retarded. Misstook ¨ for " and therefore my "orter" and "län" did'nt match my lookup records that linked to the ID's. Now they update automatically.

See Solution in Thread

6 Replies 6
Joe_Svingala
6 - Interface Innovator
6 - Interface Innovator

So the table in image one will be populated how? 

If the 'Ort' table is being populated via webhook, then ultimately you just need to make sure that whatever or whomever populates the first table is entering an 'Ort' that exists within the 'Ort' table, and same for the 'Lan' table & linking. 

For example, if you entered: "Uddevalla" on line 2, automatically you will get '649001e105004b68e128fe8d' in the ID field since that is the ID associaated with "Uddevalla" on the 'Ort' Table

Sho
11 - Venus
11 - Venus

Hello,

Is the Automation as shown below no good?

Trigger :
When webhook recievd ( Input: Ort name )
Action :
1. Find records ( Search for matching Ort name )
2. Update record ( Link from search results by Ort Name record ID )

Zach1
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes! How do I do that?

Exactly, the webhook will populate the "ort" column on the import table. And then I want it to automatically pull the ID from the "Ort ID" table and paste in in the import table under the "ort ID" column.

Sho
11 - Venus
11 - Venus

How to do this is as I explained.
If you are just getting started with Airtable, you need to understand the official documentation first!

Airtable Automations

Zach1
5 - Automation Enthusiast
5 - Automation Enthusiast

Well guys, seems like Im just retarded. Misstook ¨ for " and therefore my "orter" and "län" did'nt match my lookup records that linked to the ID's. Now they update automatically.