I’m working on a management system where a Consultant adds a client and then from the client’s profile either in the list or the table view clicks a button to open another form but the form already gets the name, email, phone, etc from the client profile.
@artur in airtable I have the following tables called Consultant, Client, Case, Invoice.
I can get a user to sign as a Consultant. The Consultant then adds a Client using details as name, phone no, address, email, business type.
Now I want the Consultant to go to the list view, click on a client and there is a button that leads to another page with the from called “Case Details”. I want the form to prefill the client’s name, email and phone no. The rest of the form will be completed by the consultant and the submitted form will be stored as a record in the “Case” table in airtable linked to the client in the “Client” table.
@ahmedtariq@acjnas is right all you need to do is to create a page with form and then use that page’s URL put into airtable and then append URL parameters via Formula in Airtable…