Forum Discussion
Are you saying that you have a list of 100 serials in say Excel and you want to do a mass search?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
We have thousands, so I will be importing those records from Excel.
For example. I have this sample app. I'm trying to assign 2 assets to clients, one is SN: 267-01, and other is SN: 2664-05
If I try to search one SN at a time, I do get results that match that string. But If I try to search 2 SN's at the same time, I get no results.
So this is my question, how can I search for different SN's, to get results?
------------------------------
Gene Strelkov
------------------------------
- MarkShnier__You2 years ago
Qrew Legend
I suggest making a table to import the full excel sheet into. Import the sheet to create the columns so that way they will match up perfectly for future imports.
Set the key field to be the serial numberThen make a relationship where Excel import entry has many GPS tracker. Let it create a field for Related Excel Import, but then change that field to be a formula equal to the serial. Make a formula checkbox field with a value of true called [Excel import exists?]
Lookup [Excel import exists?] down to GPS tracker and use that as a Dynamic fFlter to filter the GPS Trackers with serial in that table.
When you get a new serial number list, just delete out all the records in that excel table and import them again. If you want to make it more convenient for your users, there are ways to have an admin type record where you could make a button to purge the table and you could make another button to land the user on that import window just sort of dumb things down if you have the luxury of an admin person being able to do this on your behalf. Or maybe you are your own admin person and you just want to dumb it down for yourself.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- GeneStrelkov2 years agoQrew Cadet
I figured out. If I use OR (has to be capitalized) it would search the 2 different values that are in separate records.
------------------------------
Gene Strelkov
------------------------------