Apr 10, 2023 11:39 PM
I have a table with fields "Name" (primary), "Description", and "Notes". I'm writing a small script in the scripting extension that requires users to use a record picker to select a record. Right now, if you use the search bar in the record picker, it only searches within the "Name" field. I'd like to be able to search in Name,Description, and Notes so that I can pull up a record based on the description or notes if I don't know its name. Is it possible to reconfigure the record picker?
Relatedly, I found in the API that it's possible to add an "options" argument to the input.RecordAsync call, but I can't figure out where in the API the options are explained. Anyone know where I can find this?
Apr 10, 2023 11:45 PM
Also - is there a way to enable multiline text (wrap around) on the record picker?
Apr 11, 2023 11:56 AM
No, the search in a record picker can only search the primary field, not other fields.
No, the record picker cannot show the primary field as multiline text.
Here is the link to the documentation for input.recordAsync: https://airtable.com/developers/scripting/api/input#record-async
You could ask the user for search terms using input.textAsync, and then search all the related fields yourself, and then present that narrowed down list of records for your user to pick from. Not idea, but possible.