Search for Multiple/Many Unique Asset IDs in text Field.
Hello,
I use QuickBase for IT Asset Management and need a way to search multiple Asset Records at once, to see their status and update in Grid Edit if required. I have a table called "Assets" containing a text field named "Asset ID". This field contains a unique Asset ID, (EX:D117380) which we use to identify the record.
I have done some research but cannot make it work. So far, I have built a table called "Search" containing a Multi-Text field called "Search Multiple Assets Here:" I would like to paste any asset IDs here, click save, and then display the results in a Table or Summary below. I do have a table relationship, but not sure if it is linked correctly. I also tried doing this in Pipelines but could not get it to run properly.
If anyone could help me find a way to do this, that would be HUGE!
There is a solution I have implementing for clients.
Set up a new table called Search Assets.
Create a field called [Asset ID Search] as a Multi line text field with a big input box in edit mode.
Create one record and then set permissions so that no one, even Admin cannot add or delete records.
Create 1 record. It will, of course be Record ID# 1
Create a link to the assets table via a field in the assets table with a formula of 1.
Lookup the Field for [Asset ID Search] down to Assets.
Create a formula checkbox field called [Qualifies for Search?] with the formula
Contains([Asset ID Search], [Asset ID])
Back on the Search Assets Form, put the report link field on the form and create a report to use for the embedded report filtered by
[Qualifies for Search?] is checked.
Allow the Asset records records to be editable in edit mode.
You should be able to make a formula URL button to redisplay the Search record in edit mode, which would force a save before refreshing the parent search record in edit mode.