# Passing result from Glide to GS **URL:** \ **Category:** Ask for Help\ **Created:** [December 18, 2020, 9:50am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032 "2020-12-18T09:50:08Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 18, 2020, 9:50am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/1 "2020-12-18T09:50:08Z")
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 sheets. Thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 9:54am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/2 "2020-12-18T09:54:47Z")
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 your quiz. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2020, 10:08am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/3 "2020-12-18T10:08:31Z")
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. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 18, 2020, 10:31am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/4 "2020-12-18T10:31:23Z")
thanks @Darren_Murphy, I was thinking to do compounded action like attached photo…the step would be 1. user do the Quiz and press Submit button 2. then and If condition to check for Pass/fail 3. Add row to a certificate sheet BUT it seems I cannot add the If condition between Quiz (show form) and Add Row Other suggestion? Thanks ![addif](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5ffa66af291992082748e24cb24147831ad02f1c.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 10:36am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/5 "2020-12-18T10:36:26Z")
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… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2020, 11:34am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/6 "2020-12-18T11:34:49Z")
So if they don’t pass then the record isn’t added? ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 18, 2020, 11:47am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/7 "2020-12-18T11:47:08Z")
trying now…thanks ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 18, 2020, 11:48am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/8 "2020-12-18T11:48:55Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 18, 2020, 1:09pm UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/9 "2020-12-18T13:09:30Z")
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. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 19, 2020, 4:27am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/10 "2020-12-19T04:27:09Z")
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? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 19, 2020, 4:35am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/11 "2020-12-19T04:35:41Z")
Set Column, that allows you to edit the column that the user is currently in which should be their column. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 19, 2020, 4:20pm UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/12 "2020-12-19T16:20:35Z")
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? ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 19, 2020, 10:39pm UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/13 "2020-12-19T22:39:23Z")
I tested for both…meaning when I could not do it in parent, I tried to also in the new row created by the form. But when I change the column to a normal number, then I can see the column is available for selection for increment. I will continue to check. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 19, 2020, 11:42pm UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/14 "2020-12-19T23:42:21Z")
This maybe related…I have not gone back to test increment as I needed to fix another issue. I have a quiz sheet and a quiz response sheet. When a User takes the quiz, a form will show and the user input is is sent to quiz response. Under button features I created an action to send the answer back to quiz sheet (as I wanted to do some other processing) using relation to get the columns shown and populated them with what I need from answer sheet. No information was transferred. When I did a relations between quiz and quiz response and use Single Value to pull a value I wanted into Quiz then it works fine You can see the Quiz sheet with U1\*Single being values pulled back using relations and U10, U10Specific not showing anything. And the second picture is the setup for Set columns action. I have also tried to set value for the quiz response sheet and failed as well. ![setcol1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/960c6a3778770d1f7457c101975eda53d1ce2f0b.jpeg) ![setcol](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98a6a4bb67c4ef2cea16211dec4fd588497ae07b.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 20, 2020, 2:10am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/15 "2020-12-20T02:10:16Z")
I need to play more with actions and set column. I just haven’t done it enough yet. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 20, 2020, 3:27am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/16 "2020-12-20T03:27:30Z")
Ive been using set columns to trigger scripts recently. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [December 20, 2020, 5:18am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/17 "2020-12-20T05:18:07Z")
@Drearystate if possible to share screen shot of how you set up the columns in action? I could not figure out why increments or set column is so difficult for me ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 20, 2020, 5:19am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/18 "2020-12-20T05:19:09Z")
Yes, I do that as well. In fact, I demonstrated that technique in the [tutorial](https://community.glideapps.com/t/using-app-script-with-a-json-api/20051/16) I posted the other day. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 12, 2024, 2:03am UTC](https://community.glideapps.com/t/passing-result-from-glide-to-gs/20032/19 "2024-01-12T02:03:39Z")