====== AirTable ======

https://www.airtable.com

Pour des alternatives voir [[/informatique/lowcode_databases|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