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