How to auto-populate value base from input

Ask for Help
1

Hello Glide Community,

I would like to develop a form for field inventory taking and would like to reduce the burden of the user.

Let say a user key in the last 4-5 digit of product batches in the first column and the next columns should auto-populate the information of Product code, description and etc, (base from master data that upload). Some sort of fuzzy match or lookup condition and get information prefilled.

Thanks :grinning:

2

Fuzzy match most likely wouldn’t be possible, but if you are relating to get the product code, description from master data, wouldn’t it make sense to just store the product batch ID, and then use relation + lookup? Instead of storing them as plain text like what you imply here.