Autofill form data based on previous form entry

[EAHendrix]

I have a app that I am using to check in various inventory types. The first field is for serial number, something like this "KVB0041Z54112" The "KVB0041" portion of the serial number is unique to each model of product. When the serial number is put in by the user is there anyway to have it select the appropriate model in the form from a ref list?

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2357336-left

https://help.appsheet.com/en/articles/2357309-lookup

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

[EAHendrix]

Can the LOOKUP() find data in a form?

[Marc_Dillon]

I don't quite know what you mean by that question.

[EAHendrix]

The serial number I want to use to pull up the information is in a text entry on the same page of the form.

[Marc_Dillon]

Yes

[EAHendrix]

I guess I am mission something, how do you reference it before its added to the table?

[Marc_Dillon]

The same way you reference a column value any other way, enclose the column name in square brackets, i.e.: [column]

Sounds like maybe you need to start with the basics:

Expressions: The Essentials - AppSheet Help

[EAHendrix]

Sorry about that, I think my confusion came from not realizing you could reference the data before it was added to the table.