I have a Form where some questions are hidden depending on the logic of the previous question so the incoming data to a webhook can vary. The webhook delivers the data to an Excel Table.
The table headers expect the corrisponding answers to to be consistantly delivered and placed below that correct header.
The problem I have encountered - if question 4 was hidden in the form the answer from question 5 lands in the cell reserved question, 6 land in 5, 7 lands in 6 etc.
Any thoughts?
Hey Thomas,
can you show a screenshot of the scenario and how the mapping is done? Aren’t you mapping specific answers to specific cells? Or are the answers coming in with different names or something?
Hi Stoyan,
I’ve added a couple of screenshot to let you see how its set up, and the results.
I’m hoping its something I’ve done wrong, that would be a quick fix.
Thanks
Ok I see. So when an answer is empty then it’s missing from the array and breaking the order.
Do the items in the array have other variables in them? Can you show what the full array looks like?
Cause maybe you can use the map() function to dynamically find the values with the correct questions instead.
Hi Stoyan,
The Mapping was done initiall to get the headers but I’ve refereshed it with no impact on the problem.
To avoid any interference I created a simple form with 3 Y/N question.
If Q1 = No, then hide Q2.
The input from Q3 is only there to see where it lands on the spreadsheet.
Even with this simple form I was able to recreate the problem.
Q1 =No, the answer from Q3 landed in the cell reserved for Q2.
Where we do we go from here?
Can you share some sample outputs coming from the webhook to see the differences?
Stoyan,
I think the problem is being caused by Forms.app.
In the examples attached, when the second question is hidden by logic, only two outputs are shown and presumably sent to the webhook.
Welcome to the Make community!
Please provide the input/output bundles of the trigger module by running the scenario, or get the bundles from a previous run from the Scenario “History” tab.
Providing the bundles from a scenario run will allow others to replicate what is going on, especially if there are complex data structures (nested arrays and collections) and external services. This helps mapping the correct raw variable names from collections (instead of the label/display name).
Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.
A. Upload a Text File
Save each bundle contents in a plain text editor as a
moduleNumber-output.txtfile. Open the file to check if it has not added additional formatting or encoded the plain text.
You can upload files and images to this forum by clicking on the upload button:
Uploading an attachment here will look like this:
module1-input.txt (1.2 KB), module1-output.txt (3.4 KB)B. Insert a Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.
Formatting IS Important!
Here are some ways to provide text content in a way that it won’t be modified by the forum.
Method 1: Type code fence manually —
Manually type three backticks```in a separate line before and after the content, like this,``` text goes here ```Method 2: Highlight the pasted content, then click the preformatted text/code button —
Method 3: Upload your file elsewhere and share the public link —
This method is only advised for large files exceeding the forum upload limit.
This will allow others to better assist you. Thanks!
— @samliew
