What action are you using in Zapier to send the data to Airtable? Some systems allow you to pass in a linked record ID or the equivalent text value when filling in a link field. Let me explain…
Let’s say you’re taking orders for produce. In your form, you have one field where the user picks the type of fruit (i.e. apple), and another where they pick its size (i.e. large). In Airtable, you want to look up the price based on this type-size combo. To do this, you have an
[Items] table that looks something like this:
What you’re looking to do is pass the separate type and size details into an
[Orders] table inside of Airtable, combine them into a single string—i.e.
Apple:Large—and use that to make a link to the appropriate record in
[Items] so you can look up the price. Is that pretty much the gist of it?
If so, you might just try combining them directly inside of Zapier, and passing that combo into the link field. Like I said above, some actions will let you enter either a record ID or the equivalent text. In your case, you’ve got the text in two separate parts from a previous step:
Large to use my previous produce example. When adding data from a previous step, an item is rendered in Zapier as a capsule with text inside it, something like
Pardon my makeshift Zapier capsule drawing
What I’m suggesting is to put both parts, plus any separator you’re using in Airtable, into the Zapier field that will feed your link field in Airtable. In the end, it would look something like this in Zapier:
(Step 1|Apple):(Step 1|Large)
When fed into the link field in Airtable, it would become
Apple:Large and match up with the appropriate record from
[Items], allowing you to look up the price.