Upload something from time to time

i have upload menu on my app. if i want to make rule that someone only can upload when the time in upload form is from 07.30 - 16.00, what should i do? thank you

1 Like

i forget, it doesnt include weekend. so monday-friday 07.30 - 16.30

1 Like

Are you meaning you only want them to be able to β€œSync” their app during those windows?

That’s not possible really, we don’t have control over when the sync button is shown - or when things are allowed.

nope. thats not it. i mean when someone filling the form and click save there are formula that preventing to save because the time when they filling the form is not office hours. how to make it happen? i dont know the formula

1 Like

You can set a valid_if expression for some required column in the form.

AND( 
  IN( WEEKDAY( TODAY() ) , LIST(2,3,4,5,6) ) , 
  TIMENOW() <= 16:00:00 , 
  TIMENOW() >= 07:30:00 
  )



5 Likes

thank you, but why there is β€œlist” in your formula? and i input that formula on behavior, add, only if this condition is true, right?

1 Like



2 Likes

i still cant solve it:(

@shiverly
What kinda β€œmenu” is that? Is it a UX view? If so, what type is it? Can you give a screenshot pls?

that menu is totally fine. i just need a formula on behaviour β€œadd” , Only if this condition is true (to prevent someone to add on office hours). i have a column that show what time they upload something (initial value now())

im sorry my english is baadd:(

You need to add the expression that @Marc_Dillon had already proposed to the Only if this condition is true propety under the Behaviour tab of system generated Add action.

The given expression checks:

  • if the Weekday for any particular day falls into Mon-Fri excluding weekends via LIST(2,3,4,5,6) where numbers in the LIST expression denotes to the weekday numbers:
    – MON > 2
    – TUE > 3
    – WED > 4
    – THU > 5
    – FRI > 6
  • if the Current Time is greater than or equal to 4:00pm
  • if the Current Time is smaller than or equal to 7:30am

and if ALL of the conditions are evaluated to TRUE than the ADD action is enabled, otherwise it will be hidden.

3 Likes

i put that but
this happen

Arithmetic expression β€˜(TIMENOW() <= β€œ16:00:00”)’ does not have valid input types

but i put " ", so it become like this β€œ07:30:00”, β€œ16:00:00” and it worked! but there is this statement

…2: (TIMENOW()) is less than or equal to (β€œ12/30/1899 4:00:00 PM”)
…3: (TIMENOW()) is greater than or equal to (β€œ12/30/1899 7:30:00 AM”)

the date is 12/30/1899, is it okay?, i try to add row on 07:35:00 but today is sunday so i cant add any row, and then i change the formula list to list (1,2,3,4,5,6) and it works

No problem with that. In Java and Ajax, seperately there is no time and no date, there is datetime concept only. 12/30/1899 is called Joda Date to complete a time variable to a datetime format.

@Marc_Dillon had excluded the week-end in the LIST because you have specified it like that in the 2nd post:

2 Likes