Hola comunidad.
Tengo 1 campo tipo enum con 3 opciones (Desayuno, Almuerzo y Cena) lo que necesito es que, dependiendo de la hora que se estรก haciendo el registro poder desactivar algunas opciones.
Por ejemplo:
Si son las 09:00 no permitir seleccionar desayuno
Si son las 16:00 no permitir seleccionar almuerzo y desayuno
Agradezco el gentil apoyo por parte de todos ustedes.
Solved! Go to Solution.
Please try below. Please add a time type column called say [Booking_Time] with initial value as TIMENOW() and Editable_if setting set to FALSE.
Then in the enum column you could have a valid if expression something like
IFS([Booking_Time]<"09:00:00",LIST("Breakfast"),
[Booking_Time]<"16:00:00",LIST("Lunch"),
[Booking_Time]>="16:00:00", LIST("Dinner"))
You could modify the expression suitably if there is any overlap required between enum options with time. Also this will work in a form entry for new record. For existing records more configuration could be required.
Please try below. Please add a time type column called say [Booking_Time] with initial value as TIMENOW() and Editable_if setting set to FALSE.
Then in the enum column you could have a valid if expression something like
IFS([Booking_Time]<"09:00:00",LIST("Breakfast"),
[Booking_Time]<"16:00:00",LIST("Lunch"),
[Booking_Time]>="16:00:00", LIST("Dinner"))
You could modify the expression suitably if there is any overlap required between enum options with time. Also this will work in a form entry for new record. For existing records more configuration could be required.
Muchas gracias @Suvrutt_Gurjar es lo que necesitaba!
User | Count |
---|---|
26 | |
25 | |
25 | |
18 | |
17 |