I'm new to AirTable but I have 20+ years of experience with SQL, but I'm stuck with the interface design here.
I'm helping a friend setting up a project to keep track of orders and AirTable seems to be the perfect place.
I have created a "product" table, an "order" table and a junction table "order_product" for the many-to-many relationship between them.
Now I need to create a form or an interface to execute the following process:
Any idea on how to do that? Thank you so much in advance and greetings from Italy!
Thank you for your solution, I'm definitely going to try out those form builders.
Creating a custom web app would require extra time and knowledge, I recommended my friend to use AirTable to be up and running ASAP.
Can you confirm that there is no way to insert many-to-many records directly with native AirTable interfaces?