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...

Pipelines

MarkShnier__You
5 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.

MarkShnier__You

Qrew Legend

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.

Jlewis

Qrew Member

5 months ago

This worked! Thank you, Mark!

Forum Discussion

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