Hi, I am trying to build an app that uses a ...

[Grayson_Stiglba]

Hi,

I am trying to build an app that uses a form as a filter instead of using a form to add data. Does anyone know if this is possible?

Basically, I want to have a form that takes user input for certain variables, and displays rows that have that input.

Thanks, Grayson Stiglbauer

[tony1]

Example 1: https://www.appsheet.com/samples/This-app-shows-how-to-filter-your-data-using-a-form?appGuidString=c...

Example 2: https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266...

[Mahesh_Gajanan]

@tony

I checked out both samples you suggested. The first one is closer to what I need.

I need to build a screen where, when the key value is scanned in/manually entered, the rest of the record would be looked up and brought over to the UI.

Specifically in my case, the QR code on the book will be scanned (or book code manually entered), that book code is used to look up the Lending table and then the UI is populated with rest of the info like lender’s name, date checked out, etc.

It need to start by prompting for one field, then using that lookup the table, populate rest of the UI using the record found.

Tried making the book code field

“searchable” as used in the first example but that did not cause the lookup to happen to bring over the rest of the Lending record.

What am I missing?

[tony1]

@Mahesh_Gajanan Make your scannable column a reference to your table of books. Then, use de-reference expressions as initial values in the rest of the form. help.appsheet.com - Dereference Expressions Dereference Expressions help.appsheet.com

[Mahesh_Gajanan]

@tony, that worked great! Thanks!

[Mahesh_Gajanan]

@tony I have a related question that belonged to a different thread. Interested your creative idea on this plus.google.com - To speed up the check in process as folks lined up presenting QR codes one af… To speed up the check in process as folks lined up presenting QR codes one af… plus.google.com