Set Variables Not Updating Dynamically for Each JotForm Submission in Make

I’m trying to automate the generation of real estate contracts using Make. The workflow retrieves JotForm submissions, pulls a Google Docs template, replaces placeholders with form responses using the Set Variables module, and generates a new contract document. The issue is that Set Variables does not update dynamically for each new form submission. Instead, it retains the values from the first execution and applies them to all future contracts.

For example, if the first JotForm submission included “Yes” for the question “Are pets allowed?”, the variable is correctly replaced with “Pets are allowed.” If the response was “No,” it is replaced with **“Pets are not allowed.”**However, if I submit a new form with a different answer, the contract still shows the old response from the first execution, instead of updating with the latest submission.

How can I ensure that Set Variables updates dynamically with each JotForm submission so that every generated contract reflects the latest form responses? Any insights would be greatly appreciated!


Hey Luca,

1st - you are mapping a variable that can have different values in the Name section, this will change the Name of the variable between executions. Unless its a supper specific case that requires it, never do that. Type the name of the variable so it remains static, and only map stuff in the Variable Value field.

2nd - you don’t need to do the conversion in a separate tools module, you can have the formulas directly in the Google Docs module.

4 Likes

Yes, it worked! Thanks a lot for the excellent advice. Made the whole workflow a lot easier and Makes perfect sense to me now.

2 Likes