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
Timer functionality Ask for Help	9	1559	June 9, 2020
List businesses open "now" Ask for Help	39	2091	August 29, 2020
How often APP refreshes itself Ask for Help	12	835	December 2, 2020
Prevent bookings 6 months or more away (in the editor, not the sheet) Ask for Help	11	627	October 2, 2020
Show only if updated? Ask for Help	3	542	February 11, 2020

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

Related topics