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

(Grayson Stiglbauer) #1

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

(Tony Fader) #2

Example 1: https://www.appsheet.com/samples/This-app-shows-how-to-filter-your-data-using-a-form?appGuidString=c6859960-6635-4cdd-b0ac-92a42fbb3a71

Example 2: https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f

(Mahesh Gajanan) #3

@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?

(Tony Fader) #4

@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) #5

@tony, that worked great! Thanks!

(Mahesh Gajanan) #6

@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