SQL query in a table as alternative to vlookup?

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.

A relevant feature request is here for reference.

1 Like

Indeed - I had missed that feature request whilst searching, but it shows exactly the use case. Thank you.