Hi, for my use case of a Quiz, I have been taking the response from Google sheets and did some calculations in Data Editor… I need to pass the results back to Google sheets so that I can automate issuing of certificates… Suggestions please on how to pass the result from Data Editor to Google shee…

Any actions that are supposed to happen AFTER a form is submitted should really be set up as a separate compound action within the form. You can do this by opening the form, then go into the features tab and set the action on submit.

The only way I can think of to do this is to have an extra (non-calculated) column, and then use an action to do a Set Column to update the result into that column. But that would require user action - ie. a button tap or similar. But, that could be part of the flow that happens as the final step of…

I did a quiz app recently. Had a lot of user-specific columns in the Quiz sheet, then calculate the points straight in there using ITE columns. The submit button uses an add row action to write those to the Answer sheet.

thanks @Darren_Murphy , I was thinking to do compounded action like attached photo…the step would be user do the Quiz and press Submit button then and If condition to check for Pass/fail Add row to a certificate sheet BUT it seems I cannot add the If condition between Quiz (show form) and Add Row …

Maybe you need to do this in two steps? User submits the response to last question, results are calculated Present another button “Get My Results” If “passed”, do this, else do that…

So if they don’t pass then the record isn’t added?

if they don’t pass, no certificates… so want i wanted to do is if pass, send the relevant information to a new sheet which is connected to, for example Certify’m or something similar…so certificates will be automatically generated and sent by this add-on.

thanks @Jeff_Hager , it makes it much easier…I kept forgetting this feature. I am testing increment action when form submit. I notice that you cannot increment a User specific column?

Set Column, that allows you to edit the column that the user is currently in which should be their column.

Are you trying to increment a value in the new row created by the form, or a value in the parent sheet that hosts the form button?

Passing result from Glide to GS

Ask for Help

Darren_Murphy December 20, 2020, 5:19am 18

Yes, I do that as well. In fact, I demonstrated that technique in the tutorial I posted the other day.

Topic		Replies	Views
Ability to add item to Google Sheet Report a Bug	13	597	January 9, 2021
Set Columns Action Ask for Help actions	11	2295	March 8, 2021
Llevar columnas de glide a google sheet Ask for Help	2	363	July 2, 2022
Data from a user-specific column into my google sheet? Ask for Help	26	2668	July 2, 2021
Push Data from Glide to Google Sheet Ask for Help	4	374	March 4, 2021

Passing result from Glide to GS

Related topics