# Updating original Row on Form Submit

**URL:** <https://community.glideapps.com/t/updating-original-row-on-form-submit/23763>\
**Category:** Ask for Help\
**Tags:** actions\
**Created:** [March 4, 2021, 2:26pm UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763 "2021-03-04T14:26:55Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_turner/32/578_2.png) [@Robert\_Turner](https://community.glideapps.com/u/Robert_Turner)\
**Post date:** [March 4, 2021, 2:26pm UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/1 "2021-03-04T14:26:56Z")

</div>

I have an app that allows students to upload videos of tasks for assessment.

This is done through a Form with File Picker for the video files, as well as fields for Task, and special values forStudent Email, Date submitted

Once the student uploads the video its STATUS = Submitted

The assessor can view any video with a STATUS = Submitted

The assessor then marks the video PASS or RE-Submit, also providing feedback in Notes

My challenge comes when the Status is set to Re-Submit

If I use a Form to action the Re-Submit on Submit Form it creates a New Row with the New details in it, However I need to update the status of the Original Row to “ReSubmitted” so it no longer gets processed.

I am struggling to be able to update this after a submit form as I can’t track the Original Row Number.

If I update the STATUS before submitting the Form then the STATUS will be incorrect if they cancel the form and don’t submit the video.

Is there a way I can use the New Compound Actions to do this  
Or maybe via Zapier ?

Any help/ideas would be very welcome

Thanks Rob

---

<div class="post-metadata">

**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:** [March 4, 2021, 2:32pm UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/2 "2021-03-04T14:32:19Z")

</div>

You should be able to do it with the compound actions.

If you need to keep the original video, create a new column to hold the resubmitted video.

Create a button that links to “this item”, show the file picker pointing to the resubmit video column.

Once that column is not empty, show a “Send” button that has the below actions:

- Go back
- Set Status to Resubmitted
- Show notification/Play sound if needed

The process should be the same if you want to overwrite the original video. Before the link to screen part, use a set column to clear the original video link.

---

<div class="post-metadata">

**Author:** ![Robert\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_turner/32/578_2.png) [@Robert\_Turner](https://community.glideapps.com/u/Robert_Turner)\
**Post date:** [March 4, 2021, 4:13pm UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/3 "2021-03-04T16:13:57Z")

</div>

ThinhDinh  
Thankyou I’ll give it a try and let you know how I get on if that’s OK?

Rob

---

<div class="post-metadata">

**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:** [March 5, 2021, 12:52am UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/4 "2021-03-05T00:52:59Z")

</div>

Yes, I’d love to hear how this goes.

---

<div class="post-metadata">

**Author:** ![Robert\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_turner/32/578_2.png) [@Robert\_Turner](https://community.glideapps.com/u/Robert_Turner)\
**Post date:** [March 5, 2021, 11:29am UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/5 "2021-03-05T11:29:01Z")

</div>

ThinhDinh,  
Just to let you know I have now got this working successfully, based upon your advice.  
My new approach is this;

Created a button that links to “this item(Technique)”, this open the row to resubmit

now show the three file pickers pointing to the resubmit-base, resubmit-science, resubmit-variants columns.

Once those columns are not empty,

Display a “Submit” button that has the below actions:

- Check if Technique is Not Empty
- Go back
- Set Column in this Row STATUS=RESUBMITTED
- Add New Row for the newly submitted Technique, sets UsersEmail, Submit Date, the new videos using the values from Previous record for the new videos.
- Show notification that Technique has been submitted successfully
- Go back to the Technique Assessment Status screen  
The New row triggers a Zap to upload the videos to Viemo (so as to get around teh 10GB Glide storage limits)

@ThinhDinh  
Many Thanks for your advice and help, much appreciated.

Thanks Again

---

<div class="post-metadata">

**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:** [March 5, 2021, 11:59am UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/6 "2021-03-05T11:59:26Z")

</div>

Great to hear! Have a nice day.

---

<div class="post-metadata">

**Author:** ![Robert\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_turner/32/578_2.png) [@Robert\_Turner](https://community.glideapps.com/u/Robert_Turner)\
**Post date:** [March 5, 2021, 2:07pm UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/7 "2021-03-05T14:07:17Z")

</div>

You too  
Thanks again

---

<div class="post-metadata">

**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 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/updating-original-row-on-form-submit/23763/8 "2024-01-17T16:53:06Z")

</div>


