Forum Discussion

Jlewis's avatar
Jlewis
Qrew Member
4 months ago

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" contai...
  • MarkShnier__You's avatar
    4 months ago

    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.