Formula para limitar horario en la edicion y eliminacion de registros

[marinocity]

Hola!

Me gustaria limitar el horario que puedan agregar, editar o eliminar registros los diferentes usuarios que trabajan con la aplicacion.
La idea es que solo puedan ADD, EDIT y DELETE en el horario de 8 hs a 20h de lunes a viernes.

Gracias!

[diogolupcosta]

Hello, you can do it working with  weekday() on table settings

[marinocity]

Hola @diogolupcosta 

Nose como formularlo ya que es de lunes a viernes y con un horario especifico

[marinocity]

Any help?

[diogolupcosta]

Column(s) option that you want to restrict - update behavior - editable if.

Then, put the following expression:

AND(
  WEEKDAY(TODAY()) > 1,
  WEEKDAY(TODAY()) < 7,
  TIME(NOW() >= "08:00:00"),
  TIME(NOW() <= "18:00:00")
)

[marinocity]

thanks @diogolupcosta 

But I want to restrict actions (Delete, edit, add) not columns

[diogolupcosta]

The same expression I wrote but put it on behavior of the actions

[marinocity]

@diogolupcosta 

Error formula

Condition AND((WEEKDAY(TODAY()) > 1), (WEEKDAY(TODAY()) < 7), TIME((NOW() >= "12/30/1899 8:00:00 AM")), TIME((NOW() <= "12/30/1899 6:00:00 PM"))) has an invalid structure: subexpressions must be Yes/No conditions

[diogolupcosta]

AND(
  WEEKDAY(TODAY()) > 1,
  WEEKDAY(TODAY()) < 7,
  TIME(NOW() >= "08:00:00"),
  TIME(NOW() <= "18:00:00")
) = true

[Suvrutt_Gurjar]

@marinocity ,

Before looking into feasibility, would you please clarify if you want

1. To restrict the users' data entry time ( meaning usage of app )  between 8 a.m. and 8 p.m. Monday through Friday. Meaning they cannot use the app beyond these hours.

OR

2. To restrict the users' data entry values  in some date time columns between 8 a.m. and 8 p.m. Monday through Friday. Meaning they cannot enter values beyond outside these limits.

3. What type ( date, datetime, time)  of columns you have where you wish these restrictions, in case you are looking for option 2 above.

[marinocity]

thanks @Suvrutt_Gurjar 

Option 1.
Only they can use app (edite, delete, add) - Monday to friday - 8hs - 20hs.
But They can see app , 24hs every day

[SkrOYC · Accepted solution]

Ve a la tabla -> "Are updates allowed?" -> Activa el expression assistant y agrega esto:

IF(
  AND(
    WORKDAY(TODAY(), 5)=TODAY()+7,
    TIMENOW()>"08:00:00",
    TIMENOW()<"20:00:00"
  ),
  "ALL_CHANGES",
  "READ_ONLY"
)

[marinocity]

Works perfect!

thanks @SkrOYC