I’m trying to kludge together a simple inventory system for our photo studio.

Ideally the user would read the barcode via their phone and the Airtable app. Then Airtable would display the corresponding product style number/name/color by reading the lookup table.

I can’t figure out the formula part of it.

Any ideas or examples?