Hi Ivan. In Excel, VLOOKUP works because you have already defined the relationship between “100011010” and “blue” (and many others) in a set of columns. Airtable can do the same thing.
- You need the table that contains the translations (let’s call it Table 1).
- Table 1 needs the primary field to hold the “keys” (100011010) and the other field(s) to hold the values
- In the table that receives the hubspot weirdness, have that hubspot “key” land in a linked field pointing to Table 1.
- Add a “lookup” field to hubspot data table that pulls in the value field from Table 1.
Does that get close to what you want?