Strange behaviour of Google Sheets' Add a Row Module when Cloned

[Romanche]

What is your goal?

Transfer data from Cognito Forms Watch New Entries module to Google Sheets Add a Row module.

What is the problem & what have you tried?

Original scenario runs fine when set up manually. Cognito Forms module pulls input data via webhook, in the next step passes it on to Google Sheets module. When I clone the scenario and use a different webhook address, the G Sheets module starts behaving strangely - it only accepts input data if there is a formula involved, or a text is written directly into the G Sheets module settings window. If it’s only text transferred from the Cognito Forms module, it won’t recognize it.

Everything seems to be exactly identical and set up in the same way as the original scenario that works fine.

Any input much appreciated!

Screenshots (scenario flow, module settings, errors)

[Romanche]

[Karmic]

I think the Cognito module in the cloned scenario is not receiving the data or modules, and or the Google Sheets Module (Add a Row) is still pointing to the old module/structure. So the way to approach this problem is to perform the solution below to address it.

Cognito Module (New)

• Redetermine the data structure. (Send a test submission)
• Confirm if you see the expected data or fields from the new webhook.

Google Sheets Module (Add a Row)

• Make sure the connection is valid. (Double check it)
• Make sure the Spreadsheet and Sheet are selected. (Tap refresh icon)
• Clear any old mappings. Remap from the Cognito Module (New).

I hope this helps you!

[mszymkowiak]

Hello,

Your mapping works with formula because it returns results programmed when conditions are not met

{{if(1 = 1; "condition meet"; "the condition was not met")}}

To help you debug it, please double-check if the duplicated scenario gets correct data.

You can do it by clicking on Cognito Forms output details:

[Romanche]

Hi Simplymation,

thanks for chiming in. Mystery solved!

[Romanche]

Hi Karmic,

thanks! The “problem” was resolved by sending a test submission, which I previously didn’t do for some reason. After having done that, everything behaves as expected.