I realise that a vlookup function presently doesn’t exist in NocoDB, and a workaround is manually linking records via lookup.
I was wondering whether there might be a way of creating a field which is a SQL query, to automate the lookup? (I know nothing about SQL, but figured that might be a way).
As context, one of the uses I’d like to pursue is capturing events related to stock items. For that, it’d be great if one could scan a barcode, and the product title is immediately populated.