# Possible to have a tab where you must complete a form EACH DAY before you can see all the other tabs?

**URL:** https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744
**Category:** Ask for Help
**Created:** [September 13, 2020, 10:03pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744 "2020-09-13T22:03:44Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 13, 2020, 10:03pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/1 "2020-09-13T22:03:44Z")

</div>

Ok, so I want my users to take an action each day - like maybe make a journal entry, or answer a question…and then maybe increment action on a button takes them “into the app”, meaning all the other tabs are now visible. BUT - how do I arrange this to happen every 24 hours?!

---

<div class="post-metadata">

### Author: ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)
#### Post date: [September 13, 2020, 10:43pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/2 "2020-09-13T22:43:25Z")

</div>

Dare I risk the “I” word again … 🙈

---

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 13, 2020, 10:43pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/3 "2020-09-13T22:43:55Z")

</div>

Please do! 😺

---

<div class="post-metadata">

### Author: ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)
#### Post date: [September 13, 2020, 10:47pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/4 "2020-09-13T22:47:34Z")

</div>

Ok … since you asked so nicely … I would use Integromat again to look at your sheet at a time of day you choose (either for all users or on a user-by-user basis) work out who needs to do what and either (A) update a row relating to a user or (B) add a new row relating to a user. Either should suffice for the app to then know what to do about visibility.

---

<div class="post-metadata">

### Author: ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)
#### Post date: [September 13, 2020, 10:47pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/5 "2020-09-13T22:47:43Z")

</div>

How I would do if I want a way using only gsheets:

Every input from the user would Have a timestamp, if the users don’t have a stamp with “today” value, they wouldn’t have access to some content and only to the action you need them to perform.

Hope it helps you, let me know if you need more information about how to do it.

---

<div class="post-metadata">

### Author: ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)
#### Post date: [September 13, 2020, 10:50pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/6 "2020-09-13T22:50:51Z")

</div>

You can’t argue with a cat emoji haha!

@V88, those functions are available for free users (better, this is still an option for integromat? Free plan)? I didn’t build anything using glide, zapier or integromat for months before launching 2 apps this week, that’s why I don’t remember many of the features…

---

<div class="post-metadata">

### Author: ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)
#### Post date: [September 13, 2020, 10:57pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/7 "2020-09-13T22:57:57Z")

</div>

You get a lot for free with Integromat but I use the cheapest paid plan. I think the differences are only capacity based for the most part and perhaps frequency of checking for things like new rows in Google sheets. I find it absolutely rock solid and it transforms what my apps can do. It’s like the server-side logic that we used to have to write services by hand to make work.

Example. Customer wants Glide app to display stock to customers. Trouble is stock system is really old and can only export in XML via FTP. No problem. I set Integromat to login via secure FTP early each morning, download the XML file, parse it, filter out the bits I need and update my Google Sheet. App is then ready for when customers wake up with latest stock levels.

---

<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: [September 13, 2020, 11:14pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/8 "2020-09-13T23:14:45Z")

</div>

I do this in my free template here:

> **[Glide • COVID Check-in for Schools by Kyle Heney](https://www.glideapps.com/templates/sjV5xNgTyxa92WdJEeiK-template)**
>
> Provide an easy way to track students' health status and help ensure your school is COVID-free!

---

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 13, 2020, 11:49pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/9 "2020-09-13T23:49:44Z")

</div>

Ahhh! Finished a quick dinner and came back to so many great ideas! Thank you Gliders! I love this community! 🤩 😍 😌

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 14, 2020, 12:07am UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/10 "2020-09-14T00:07:02Z")

</div>

All good suggestions so far. I imagine that the action you want them to take is completing a form. Along with their entry, Submit the timestamp. Create an if then else column to result in true if timestamp is today. Use a template column to combine the email address and the if then else column (true or empty/false/something else).

in your user profile tab, create a template that combines the email address and the word true.

Create a relation from the user profile tab to the form submission using that template column.

It should only create a relation if the user has submitted something for that day. Otherwise it will be empty. Use the is empty / is not empty as a tab visibility condition.

---

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 14, 2020, 12:25am UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/11 "2020-09-14T00:25:30Z")

</div>

Oh, this is fantastic! I am going to try it out first thing in the morning! 🤩🤩🤩

---

<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: [September 14, 2020, 12:49am UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/12 "2020-09-14T00:49:03Z")

</div>

To add to what Robert has said, my suggestion would be creating a list of days in advance, let’s say 7 days in the Sheets, and an ITE column to determine if any of those days is Today.

In your User Profiles, create a template column with the value “Today”. Make a relation - lookup to bring the real “Today” value (in Date format) back.

Then when the user submits a form, collect their date of submission. Make the template of email and “today” value as Robert suggested and create the relation.

In theory, the list of days in advance would give you the buffer time for Sheets to update new days, even if they’re 6 days late you will always have a “Today”.

---

<div class="post-metadata">

### Author: ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)
#### Post date: [September 14, 2020, 7:29am UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/13 "2020-09-14T07:29:37Z")

</div>

I think the simplest solution is from @ionamol, then refined by @Robert_Petitto and @ThinhDinh. In my scenario I’d still need Integromat however, since I want to “nudge” the user if they haven’t submitted today, by one of three methods (a) email (b) text © notifying their manager. Additionally my users are allowed until 10am to submit!

---

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 14, 2020, 11:17am UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/14 "2020-09-14T11:17:18Z")

</div>

Just waking up and going to try this now! Thank you everyone! Happy Monday! 🤩

---

<div class="post-metadata">

### Author: ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)
#### Post date: [September 14, 2020, 5:30pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/15 "2020-09-14T17:30:03Z")

</div>

@Robert_Petitto and @ThinhDinh always explain better than me haha!

---

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 14, 2020, 5:30pm UTC](https://community.glideapps.com/t/possible-to-have-a-tab-where-you-must-complete-a-form-each-day-before-you-can-see-all-the-other-tabs/15744/16 "2020-09-14T17:30:28Z")

</div>

But you got it started! 😌
