hi!
I just created an app for reservation
.
In that app I want to add a time option for attendance using enum (08.00, 08.30, 09.00,09.30). But I want to avoid an overlap in the enum. Does anyone know how to do this? Please help me
go to column setup and set the valid if condition to:
OR(
INDEX(SPLIT([_THIS], ":"), 2) = 30,
INDEX(SPLIT([_THIS], ":"), 2) = 00
)
PS: i am assuming that the column type is TIME
I think you are in need of expression which is going to be used in Valid If in table properties.
you can used intersect () function which gets similar or equal values in the list. then you can subtract it from the main list of times (8, 8.30, 9 etc).
select (tablename[column name] , [criteria] <> intersect ( list 1 , list 2))
case 2 if u have limited enum options then try this
list ( 8, 8.30, 9 etc..) - intersect ([column name] , list ( 8, 8.30, 9 etc…) )
intersect () function explain is in below link.
it says “INTERSECT takes two arguments of type List.”. so I cant. Can you help me?
yes sure I can help you. before that please read case 2 in reply which I have given.