Table des matières

AirTable

https://www.airtable.com

Pour des alternatives voir lowcode databases

Apps

Search.app

https://airtable.com/marketplace/blknmXKkZjB7scdSq/search

https://support.airtable.com/hc/en-us/articles/115013249467-Search-app#h_01FZ8VVHP94STBD4MY6JY33NX9

Tips

Forms

Forms - Lookup search on multiple fields

Unfortunately, Airtable form fields can’t be used to search across multiple table fields. Each field in a form ties to a specific field in the table where it lives. To do what you want, you’ll need to enlist the help of a more robust form system, or code a custom form that searches behind the scenes using the Airtable API. I don’t have direct experience with the latter, and only marginal experience with other form systems, but nothing tied to your use case. Here’s hoping some others will chime in with info that could help you.

Data structure

An Order Form for Multiple Products

Invoices & Line Items (Example Base) - Airtable 549 https://airtable.com/shrARpjHsxF9gAZf4/tblD9dhzRj1azFYiu/viwYyRZbubYD30Lh9?blocks=bipM8uJi4OjyCogN5