This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
Hello, first post here !
As many others, I’m trying to have an efficient way to get a form splitted into mutiples interface pages that at the end create one single record in a table.
My setup is kind of working :
- I have created a table with a column for every question.
- I have created 4 interface pages to split my form.
- On each interface page i have all the questions, but only the one that need to be answered are displayed, the others are hidden.
- On the 3 first interface pages I removed the link to the table in the data tab of the form. So that it doesn’t create a new record in the table when I hit “continue”.
- Instead I added (in the “actions” tab) a “navigate to page” action that sends the data to the next page.
- On the fourth page I kept the “Data” connection to the table in order to create the single record.
So on each page, when I click on the form “continue” button, it send the data of each field to the next page by addind infos in the URL of the next page that it navigates to.
Except it doesn’t work for “dropdown” field type which have their options set from another table. Actually it works for one page to an other, but not from a page that has been filled automatically from the infos in the URL.
Example :
- First interface page, I select a client from the dropdown list (that list comes from an other table) and click on continue at the bottom.
- Second interface page, the client is filled automatically, it got the right client and the URL seems to have some kind of id. I click on continue at the bottom.
- Third interface page, the client disappeared. And the URL doesn’t have the client ID anymore.
- If i go back to the previous page (second interface page), remove the client name, add it manually again and hit continue. Then on the third page it’s working fine.
- And then it doesn’t on the fourth. Except if on the third interface page I remove the client’s name and add it back manually before hitting “continue”.
For text field, numbers or dropdown with a static list of options it work well all the way through.
Do you get the same behavior ?
For info I’m new to zapier and testing things with a free plan but I’m still in the pro trial.
Thank you for your future answers.