Skip to main content
Solved

Search for Multiple/Many Unique Asset IDs in text Field.

Jlewis
Forum|alt.badge.img+1

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!

Best answer by MarkShnierYou

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.

View original
This topic has been closed for replies.

Samtheman
Forum|alt.badge.img+5

One way I found how to do this would be to make a table report with Any filter for multiple Asset IDs - in the filter value use the Ask the User option. Then the table will load with the Asset IDs you inputted and you can grid edit. 

    MarkShnierYou
    Forum|alt.badge.img+24

    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.

    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement