# Help with limiting form entries

**URL:** https://community.glideapps.com/t/help-with-limiting-form-entries/65081
**Category:** Ask for Help
**Created:** [August 16, 2023, 5:44am UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081 "2023-08-16T05:44:16Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![sfjmercado](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sfjmercado/32/62949_2.png) [@sfjmercado](https://community.glideapps.com/u/sfjmercado)
#### Post date: [August 16, 2023, 5:44am UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/1 "2023-08-16T05:44:17Z")

</div>

We have a app where users can submit a run sheet for calls. We want to limit the submission and remove the button or grey it out - perhaps saying it is “Already Completed”

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a79259c846b2f3bdf3a5e8cbe81356db732300e2.jpeg)

---

<div class="post-metadata">

### 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: [August 16, 2023, 5:53am UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/2 "2023-08-16T05:53:08Z")

</div>

Use a visibility condition on the button such that it is only shown when the Status is not Completed (or however else you determine the status).

---

<div class="post-metadata">

### Author: ![sfjmercado](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sfjmercado/32/62949_2.png) [@sfjmercado](https://community.glideapps.com/u/sfjmercado)
#### Post date: [August 16, 2023, 6:07am UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/4 "2023-08-16T06:07:32Z")

</div>

The call just comes in and has no status. It just exists in the table. However we need multiple firefighters to submit run reports to the “Call ID”, but only one report per user. The email column is added to sheet, but I need an effective way to see if the user has already submitted a record for that call, and disable the form submisson.

---

<div class="post-metadata">

### 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: [August 16, 2023, 6:17am UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/5 "2023-08-16T06:17:58Z")

</div>

Create a Query column, and target it at your Calls table. Apply the following filters:

- CallID is This Row-\>CallID, and
- email is signed in user

Use the state of the query column as a visibility condition on the button. If the query column is not empty, the signed in user has already submitted a report for this call, so hide the button.

---

<div class="post-metadata">

### Author: ![sfjmercado](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sfjmercado/32/62949_2.png) [@sfjmercado](https://community.glideapps.com/u/sfjmercado)
#### Post date: [August 23, 2023, 8:52pm UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/6 "2023-08-23T20:52:56Z")

</div>

I tried this but it seems limiting. Perhaps because we do not have an email attached to the calls, which would not work anyhow.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/eec6732896b5ecf37fc18399395b0d4a88eb5c88.jpeg)

---

<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: [August 23, 2023, 11:18pm UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/7 "2023-08-23T23:18:06Z")

</div>

How are you inputting the calls in your app?

---

<div class="post-metadata">

### Author: ![sfjmercado](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sfjmercado/32/62949_2.png) [@sfjmercado](https://community.glideapps.com/u/sfjmercado)
#### Post date: [August 24, 2023, 3:52pm UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/9 "2023-08-24T15:52:01Z")

</div>

IT would be nice if we could create a relation, where we could see the field of my “SubmittedRuns” to show that there email address exists on the row entry of that specific call ID, as a “submission” and remove the button view.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb093627b1603e800597eb66c2e81b460d6354bb.jpeg)

---

<div class="post-metadata">

### Author: ![sfjmercado](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sfjmercado/32/62949_2.png) [@sfjmercado](https://community.glideapps.com/u/sfjmercado)
#### Post date: [August 24, 2023, 4:07pm UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/10 "2023-08-24T16:07:33Z")

</div>

I believed I solved it. I added a relation to the Calls ID table. This also allows me to set the visibility of the button. Thanks!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbce2968e676fa8379156055ea9b1755a961cfdc.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: [August 24, 2023, 11:33pm UTC](https://community.glideapps.com/t/help-with-limiting-form-entries/65081/11 "2023-08-24T23:33:20Z")

</div>

The bottom line is that if you have a field that can be related between two tables, you can use it to create a relation and hide the button.

We don’t know the full structure and meaning of your data, so I hope the call ID setup you have above is correct.

Please let us know if you need anymore help.
