Search for Multiple/Many Unique Asset IDs in text Field.
- 6 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.