Hi, I have made a home delivery app for a small local pizzeria. Now I am wondering if there is anyway that I can only make the app functioning only during the opening hours of the pizzeria. If someone places an order at 2.00 am that order won’t be picked up and dealt with, and it would “contaminate”…

[image] Assuming column A stores the hour of ordering so that you won’t have to get HOUR involved in the nested formula, I got it work with the formula in the image. =ARRAYFORMULA(IF(A2:A<>"",IF(A2:A<9,FALSE,IF(A2:A>=20,FALSE,TRUE)),"")) Update: I random some timestamps, got an arrayformula for t…

Is there anyway to make an app inactive during some hours of the day?

Ask for Help

Krivo May 31, 2020, 8:12pm 11

@gvalero have you tried with closed sheet as described here?

Glideapp Update frequency

Topic		Replies	Views
Time Based Visibility of an Object / a Row In a List Ask for Help	3	357	January 17, 2024
List businesses open "now" Ask for Help	39	2078	August 29, 2020
Is a Mobile Order App Possible? Feature Requests	4	1074	May 31, 2020
Time challenge Ask for Help	3	164	July 12, 2023
Show only if updated? Ask for Help	3	534	February 11, 2020

Is there anyway to make an app inactive during some hours of the day?

Related topics