# Is it possible to allow users to negate a Form submission based on information that is available only AFTER the form has been submitted?

**URL:** <https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957>\
**Category:** Ask for Help\
**Created:** [July 22, 2020, 11:16pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957 "2020-07-22T23:16:11Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 22, 2020, 11:16pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/1 "2020-07-22T23:16:12Z")

</div>

I have a billing App in which Users are enabled to enter a particular customer’s information into a Form and, once entered, to Review and confirm their submission. The Form is launched from a parent sheet.

Unfortunately, once the Form is launched, there is some information that I cannot show Users within the Form (information ‘X’) as it is dependent on some Choices that the User makes within the Form. As such I have given Users a chance to review the information submitted (call this Form 1 Entry) via a ‘Review & Confirm’ page that appears right after the form is submitted. This information includes the now available ‘X’. I would like the user to have the option of De-Activate the Form 1 entry (ideally in the form of a switch) based on their review of the information (including ‘X’). And I would like to record this in the Form sheet.

Where I am having trouble is in making it easy for the User to Deactivate the Form submission and to record this information in the Form sheet. The problem is that if I include an Activate/DeActivate switch in the Review page (post Form submission) that result is recorded in the parent sheet and not in the sheets/row where the Form has been submitted.

I would appreciate any suggestions from anyone who might have some ideas on how to address this.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 22, 2020, 11:17pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/2 "2020-07-22T23:17:50Z")

</div>

Your review process could be to provide a delete button to admins. This would remove the row from the sheet if something wasn’t done correctly.

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 22, 2020, 11:31pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/3 "2020-07-22T23:31:23Z")

</div>

> [@kyleheney](#):
>
> admins

Thanks, @kyleheney. By ‘delete button’ do you mean directing the Users to use the Edit function first and then clicking on the “Delete” option (which I will likely have to make the only available option within editing)?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 22, 2020, 11:33pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/4 "2020-07-22T23:33:52Z")

</div>

Yes, exactly. You can even give users access to edit their submissions, but only give admins access to delete. Or just give admins access to both and prevent any changes or deletes by non-admins.

---

<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:** [July 22, 2020, 11:52pm UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/5 "2020-07-22T23:52:16Z")

</div>

I would probably use user-specific columns outside of a form, do the “negate” logic right on that screen before showing the form button. In the form, just show all the info that have been added in the previous screen in a table component and ask users to review, then press submit button.

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 12:27am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/6 "2020-07-23T00:27:19Z")

</div>

Hi @kyleheney. Would any delete/edits made by the Admin only affect the specific row relevant to the Form that was submitted? I am noticing that the changes made using Edit only affect the Parent Sheet and not the Sheet that contains the Form submissions.

> Blockquote

---

<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:** [July 23, 2020, 12:29am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/7 "2020-07-23T00:29:08Z")

</div>

You must point the data to the sheet where you store the submission.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 23, 2020, 12:33am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/8 "2020-07-23T00:33:34Z")

</div>

As @ThinhDinh said, make sure your views are looking at the right sheet with the submissions on it. Then edit those items and any Edit/Delete will only impact the specific items.

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 12:36am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/9 "2020-07-23T00:36:28Z")

</div>

> [@ThinhDinh](#):
>
> where

@ThinhDinh, @kyleheney, Thanks.

But during Edit, it does not give me the option to switch sheets. It only points to the default “parent” sheet. How do I switch to point to the right sheet?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 23, 2020, 12:53am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/10 "2020-07-23T00:53:35Z")

</div>

What are you trying to edit? The form screen or the submissions? How are you displaying the submissions? Some screenshots may help.

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 1:14am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/11 "2020-07-23T01:14:09Z")

</div>

> [@kyleheney](#):
>
> screenshots

@ThinhDinh

Here are some screenshots.

 ![4. Edit Sheet. I am limited to the Parent Sheet in terms of what I can edit here. Which is a problem.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d32d23fc3bcdc77411b96d2f93d53de191e40ca1.png) ![3. After Form submission. Back to Parent sheet. Note that I could not include the Due Date until I knew the Payment Title. I calculated the Date in my Parent Sheet using a formula.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/968a9dea294950b69f3513649d8aad28f0e9494d.png) ![2. Form that User Fills out. Data goes to Form Sheet.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1601b55cbadf858ff3a04a999f4c2a359045bdb6.png) ![1. Prior to Form Submission. Parent Sheet.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5a14379825c067949edf585edafe4ee2df78ff88.png)

---

<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:** [July 23, 2020, 1:16am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/12 "2020-07-23T01:16:21Z")

</div>

You’re pointing the edit button to the original sheet.

You can go to the tab where you display the assignments, then allow edit on each item of that, if that’s what you want.

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 1:19am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/13 "2020-07-23T01:19:04Z")

</div>

> [@ThinhDinh](#):
>
> You can go to the tab where you display the assignments, then allow edit on each item of that, if that’s what you want.

“You can go to the tab where you display the assignments, then allow edit on each item of that, if that’s what you want.”  
How exactly do I do this? Where? I did not know you can point the Edit function to whatever sheet you wanted. Any references/examples would be appreciated.

---

<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:** [July 23, 2020, 1:20am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/14 "2020-07-23T01:20:06Z")

</div>

How are you displaying the “assignments” to the people who have submitted them?

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 1:23am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/15 "2020-07-23T01:23:34Z")

</div>

On the page that appears after a Form is submitted (I call this the “parent” sheet) I add components that display the information that was submitted in the form. I get most of the components via a Lookup from the “assignments” sheet.

---

<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:** [July 23, 2020, 1:24am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/16 "2020-07-23T01:24:30Z")

</div>

Can you show me some screenshots? I think you can enable the edit function there instead of in this sheet. And the edit function should be in the details view of each “assignment” the user has submitted.

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 1:27am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/17 "2020-07-23T01:27:08Z")

</div>

> [@ThinhDinh](#):
>
> me

I included screenshots in Post #11 above - including where I see the Edit function. Let me know if you are asking for some other specific ones.

> [@Is it possible to allow users to negate a Form submission based on information that is available only AFTER the form has been submitted?](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/11):
>
> @ThinhDinh Here are some screenshots.

---

<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:** [July 23, 2020, 1:29am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/18 "2020-07-23T01:29:34Z")

</div>

You’re only showing the sheet where you allow the users to assign a new payment. Do you have a tab where you actually show the “Assignments” that have been submitted?

---

<div class="post-metadata">

**Author:** ![Fassil\_Befekadu](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@Fassil\_Befekadu](https://community.glideapps.com/u/Fassil_Befekadu)\
**Post date:** [July 23, 2020, 1:32am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/19 "2020-07-23T01:32:51Z")

</div>

> [@ThinhDinh](#):
>
> sheet

I have not created one yet.

---

<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:** [July 23, 2020, 1:33am UTC](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957/20 "2020-07-23T01:33:42Z")

</div>

You must create one to be able to edit each item individually.

[Next page](https://community.glideapps.com/t/is-it-possible-to-allow-users-to-negate-a-form-submission-based-on-information-that-is-available-only-after-the-form-has-been-submitted/12957.md?page=2)
