# If this then

**URL:** <https://community.glideapps.com/t/if-this-then/1013>\
**Category:** Ask for Help\
**Created:** [October 8, 2019, 8:13pm UTC](https://community.glideapps.com/t/if-this-then/1013 "2019-10-08T20:13:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [October 8, 2019, 8:13pm UTC](https://community.glideapps.com/t/if-this-then/1013/1 "2019-10-08T20:13:52Z")

</div>

I want to create a scenarios. ie. “If this then show that”

eg. A user has submitted 3 forms for the day, I need to alert him, that he has run out of credit.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 10, 2019, 6:33pm UTC](https://community.glideapps.com/t/if-this-then/1013/2 "2019-10-10T18:33:12Z")

</div>

You could create a counter in the sheet that would fill a column value if the count is \>= 3 and then display that column somewhere in your app. No option for logical conditioning and a pop up message within the app though.

---

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [October 10, 2019, 7:29pm UTC](https://community.glideapps.com/t/if-this-then/1013/3 "2019-10-10T19:29:35Z")

</div>

Have 2 sheets, Users and Answers. The Answers sheet will have a record per user post. The User table you make an extra column “Count” and use a SUMIF with a reference to the Answers table. (make sure to use an Arrayformula).  
Then another column with the Modulo of the SUMIF value. If you do a Modulo 3 then every 0 value is the 3rd value. You can use that value to make an IF statement in another cell as text to show the user.