I am often searching in my app among thousands of records to provide coworkers with product info. These searches are based on a list (either csv or text). There is unfortunately no way to filter, sinc...
Trying to set this up. First problem for me might be not understanding data entry.
- Make 1 field as a large text field data entry field. So the Search table will have 1 field only, and it will be Text?
- On the search target table put a formula numeric field with a formula of 1. I can make the formula field, but how do I make the value = 1?
- Make a relationship to the details table and lookup the search target text. So the table I wish to search is the Parent and the newly created Search table is the Child? What should the reference field be? I can enter the Lookup field as the one field I created in the Search table.
- Make a report where the [search target text lookup] contains the search target field in the details table. I don't understand this. Does this mean I should make a Table Report with the Lookup Search field and the field I wish to search in as columns?
Use that report as a report link field report on your search target single record. This report should show up on the Search table records or the table I wish to search in?
So you should be able to just edit the search record, save, and see the hits on the embedded report. I would paste the string of values into the one text field here? Would they be separated by "OR"?
