# Visibility based on date and user input

**URL:** <https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131>\
**Category:** Ask for Help\
**Created:** [October 14, 2020, 1:15pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131 "2020-10-14T13:15:31Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Soto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/soto/32/14418_2.png) [@Soto](https://community.glideapps.com/u/Soto)\
**Post date:** [October 14, 2020, 1:15pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/1 "2020-10-14T13:15:31Z")

</div>

Hey folks 👋

I am looking for a simple way to make a button visible once per user daily. Basically I want users to be able to input their own scores once daily, once they’ve logged their daily score I want the button visibility to turn off. Any suggestions?

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [October 14, 2020, 1:22pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/2 "2020-10-14T13:22:15Z")

</div>

Hey @Soto,

You can do this by:

1. On the tab where your button is you can create a template column with the “current user email” and the name of the activity the will submit. Something like this: Email-Activity/RowID.

2. On the submission tab, create another template column matching the email and the activity. Again Email-Activity/RowID

3. On the tab where your button is, create a relation where CurrentUserEmail-Activity matches Email-Activity on the submission tab.

4. Then, set button visibility to only visible when that relation is empty.

I hope this helps.

---

<div class="post-metadata">

**Author:** ![Soto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/soto/32/14418_2.png) [@Soto](https://community.glideapps.com/u/Soto)\
**Post date:** [October 14, 2020, 10:00pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/3 "2020-10-14T22:00:03Z")

</div>

Thank you Santiago,

Sorry I’m sort of new to this. If I’m understanding correctly, you’re saying that I should have two separate tabs in the app?

Right now I’ve got it set up as a form button in a single tab. Each day the user logs in, submits the form, then (ideally) the form button disappears until the next day when the same user can return and submit 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:** [October 14, 2020, 10:03pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/4 "2020-10-14T22:03:39Z")

</div>

Not necessary. You can have just 1 tab that has the form and an inline list of submissions.

However in your data, you should have 2 sheets: user profiles and submissions.

---

<div class="post-metadata">

**Author:** ![Soto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/soto/32/14418_2.png) [@Soto](https://community.glideapps.com/u/Soto)\
**Post date:** [October 14, 2020, 10:34pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/5 "2020-10-14T22:34:17Z")

</div>

I want to make sure I’ve got this right. So I made a very simple app to help understand. My data editor currently looks like this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5c0856f9eeae8364ea09ccba7e0eba42f40ac1c6.png)

and

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3c42a8206e9c81f90bb9276e297d907417e3bfe5.png)

My tabs currently look like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5f6674ea7804c250fe2b5ae57e896c254c4cdfad.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/500349efd589fc0afaaa0149439950f8413e1e82.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:** [October 14, 2020, 10:39pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/6 "2020-10-14T22:39:45Z")

</div>

In your profiles sheet, create a math column and have a value pointing to the Now value. Set the format to date only, short format.

Create a templare column joining the email and the date you just added.

In your submissions sheet, create a template column joining the submitter’s email and the date of the submission.

Make a relation from the template column in profiles sheet to the template column in submission. If relation is empty then show the button.

---

<div class="post-metadata">

**Author:** ![Soto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/soto/32/14418_2.png) [@Soto](https://community.glideapps.com/u/Soto)\
**Post date:** [October 14, 2020, 10:50pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/7 "2020-10-14T22:50:23Z")

</div>

I’m so thankful people like you exist and are willing to take a few minutes to help a rookie. Appreciate it. Like this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c1612596cd5e43786f35e039de868cb1867c953d.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/979323e2f73bb5707b9dc75b12c8bd79f2d10356.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6e408cb4da1fb94c260de6dd25907d5a27f4a3e0.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/01ed2cb5d916450d55bfbaef57bfa8777cf685b9.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:** [October 14, 2020, 11:31pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/8 "2020-10-14T23:31:01Z")

</div>

You’re close.

The Template should be like this.

You can input something like {E} - {D}

Then point {E} to the email column and {D} to the math column.

Do the same for the submission sheet.

---

<div class="post-metadata">

**Author:** ![Soto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/soto/32/14418_2.png) [@Soto](https://community.glideapps.com/u/Soto)\
**Post date:** [October 14, 2020, 11:53pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/9 "2020-10-14T23:53:48Z")

</div>

Now I literally just feel like I’m probably wasting your time and I should do some prerequisite reading / videos. Here’s the way I’m interpreting what you wrote. I’m 99% I’m doing it wrong.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cf28f59ddb1bd4bc47ca62a9d68dddf03bca4500.png)

---

<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:** [October 14, 2020, 11:58pm UTC](https://community.glideapps.com/t/visibility-based-on-date-and-user-input/17131/10 "2020-10-14T23:58:15Z")

</div>

Haha I’ll chime in… in the template area, don’t select a column… literally write in what @ThinhDinh wrote above using the Custom option. The variables you pick there get defined below (which you’ve done correctly!).
