Upload something from time to time

shiverly · 11-20-2020 03:42 AM

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

shiverly

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

Marc_Dillon

shiverly

i still cant solve it:(

LeventK

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:

MultiTech

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.

shiverly

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

Marc_Dillon

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 
  )

shiverly

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?

LeventK

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

shiverly

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:(

LeventK

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.

shiverly

i put that but
this happen

Arithmetic expression ‘(TIMENOW() <= “16:00:00”)’ does not have valid input types

shiverly

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