Help

Navigate to interface page (form) and set a field value

Solved
Jump to Solution
1944 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Hill672
5 - Automation Enthusiast
5 - Automation Enthusiast

I can add a button on my interface page that navigates (go to interface page) to a form. However, I'd like to set a field value (within that form)  based upon current focus.

The application is an ideas board so I'm focused on Idea A (main page) and I navigate to a voting table (form) but I want to pass idea A to that form.

So I'm thinking I need to associate the button with a script but cant find example code for this application eg interface page navigation. Can anyone point me to an example?

1 Solution

Accepted Solutions

Nah, you don't need a script and can just use a formula field for it.  Check out the "using formulas to create prefilled urls" part of the guide

See Solution in Thread

5 Replies 5

You can do it via URL parameters, so something like this works fine:
https://airtable.com/appOyKD7rqgwlXMm4/pagfZ4skZwMZFHQ2M?prefill_Name=Test&prefill_Status=Todo

Resulting in:

Screenshot 2023-07-25 at 10.07.44 PM.png

And the syntax is the same as the normal form prefills

Hill672
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank Adam,

great to know you can suffix a URL to prefill forms. In my case I'd like the 'idea' value (Todo in your example) to be variable based upon an Airtable interface page employing a record review layout. So I'm thinking I'd need to create a script which would get the currently selected record (from the record review layout) and dynamically create the URL employing that record name?
So (with limited coding knowledge) was looking for an Airtable script example for that scenario.

Nah, you don't need a script and can just use a formula field for it.  Check out the "using formulas to create prefilled urls" part of the guide

Apologies for delayed response. I have followed your advice and I now have a field that formulates the required URL for a pre-filled form. my next challenge is how to employ that field with an Airtable interface page employing a record review layout. My vision was to add a button to the interface that would take me to the form prefilled based upon the record currently selected in the interface. I cant see any way to do that with the standard button configuration or an associated automation?

Hill672
5 - Automation Enthusiast
5 - Automation Enthusiast

Sorry I missed the button option 'go to URL in record'. Doh!