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	2086	August 29, 2020
How often APP refreshes itself Ask for Help	12	824	December 2, 2020
Prevent bookings 6 months or more away (in the editor, not the sheet) Ask for Help	11	625	October 2, 2020
Want to see the app only this time Ask for Help	3	189	February 20, 2022

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

Related topics