I’m interested in using the API within the scripting block unless there’s an easier way. A feature that allows filterByFormula without scripting would be even better. It would make sense for it to be a separate tool.
As you can tell I’m limited in my coding knowledge, but if I have a clear example to work from, I can learn faster.
filterByFormula is available only when using the REST API, which is typically only used from outside the Airtable user interface. It is only used in Scripting block if you need to access a different base.
The exact method of getting the records you want depends on your base design. Do you have a table of users, or are your users Airtable collaborators? Do you have a linked record field that you can leverage to identify the records you want?
By the way, if you have budget for more personal advice for your specific base design, I am available for hire.
Essentially I want to load API requests into a separate table as new records with the person’s info to authenticate their request. Then I can use that request with the information about how they want to filter their data to return an array of matching record IDs that I can then use to populate the list.
Does that make sense? I can do a screenshare with you.