It would be great to have lookup functionality without needing to link table first, essentially a VLOOKUP function. Let’s say I have a table of products:
And I have another table where my salespeople enter customer orders (let’s say they are scanning barcodes using the mobile app)
I want to look up the scanned barcode in the products table without making an explicit link between the two. The way this works at the moment is that you have to link the two tables and search for the product record you want. For speed, I want my team to simply scan a barcode and have Airtable do the lookup in the background. This would need some error handling in case the scanned barcode does not exist in the products table. I could use a formula to, for example, “VLOOKUP” the product name into the orders field to show whether or not the scanned barcode exists.
Just one use case, I can see lots more examples where a VLOOKUP-style function would be really useful.