Ref ~ Search by phone number, name, serial number.

[jaichith]

Dear friends,

I have a need .... If anyone knows let me know.

I have 2 tables

1. Orders (customer name ~ ref ) 

2. Customer (Key - Serial number, label - name )

When ever I add an entry in the orders table, I could search an customer by using name (label). But I need search them by phone number and serial number also. Is it possible? 

[WillowMobileSys]

I think you are referring to a Customer dropdown list?  There is not an AppSheet provide way to search dropdown by multiple data columns

To accomplish this I will create a custom label that combines the search columns together and set it as the label column for the table.  for instance I might create the value in the label column so it looks like:

John Baer - (603) 521-2736 - 123456789

Then you can search by any of these values to find an item.

This does mean you might need to adjust how you display the chosen customer on the Order IF you don't like showing the custom label details there.  But I typically leave the label as is.

[jaichith]

Does it search phone number in concatenate string ? I mean searching in between string.  521 or

Search should be given as "John Baer" - 521