# How to auto-populate value base from input

**URL:** https://community.glideapps.com/t/how-to-auto-populate-value-base-from-input/78242
**Category:** Ask for Help
**Created:** [November 28, 2024, 7:15am UTC](https://community.glideapps.com/t/how-to-auto-populate-value-base-from-input/78242 "2024-11-28T07:15:54Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Knot](https://avatars.discourse-cdn.com/v4/letter/k/ed8c4c/32.png) [@Knot](https://community.glideapps.com/u/Knot)
#### Post date: [November 28, 2024, 7:15am UTC](https://community.glideapps.com/t/how-to-auto-populate-value-base-from-input/78242/1 "2024-11-28T07:15:54Z")

</div>

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 😀

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 28, 2024, 2:38pm UTC](https://community.glideapps.com/t/how-to-auto-populate-value-base-from-input/78242/2 "2024-11-28T14:38:12Z")

</div>

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.