Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jul 07, 2021 12:36 AM
Hello yall! Got a quick quesiton here! My goal is to connect airtable with hubspot through zapier but when there import of info occurs there is a weird inflow of info due to internal problems between connecting the two that spits out code instead of text. My goal is to translate such code as lets say “100011010” into blue for example where each value of x that gets imported automatically has another column that can spit out y values. so similar to vlook in excel. Please let me know how it can be done
Jul 07, 2021 06:09 AM
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.
Does that get close to what you want?