Can I put a Valid_If on DateTime so that user...

(simon bailey) #1

Can I put a Valid_If on DateTime so that users can only choose times with certain minutes?

On this app I need to limit them to 15 minutes, so any times with 00, 15, 30, 45

The reason for this is I’m warning about duplicate jobs for the same person. I’m doing this with a very wide google sheet comparing every 15 minutes of every job. It’s a pain but it works. But if anyone has a better way (if you know what I mean) that would be very welcome. There’s lots of calculations in the sheet, so I reckon it slows down the syncing.

(Aleksi Alkio) #2

AND(TRUE,IN(MINUTE([_THIS]-“00:00:00”),LIST(0,15,30,45))) should work.

(simon bailey) #3

@Aleksi_Alkio Thanks That works

(Aleksi Alkio) #4

You’re welcome

(Philip Garrett) #5

@simon_bailey1 @Aleksi_Alkio

I added this useful expression to the Data and Time Expression article at help.appsheet.com - Date and Time Expressions

Date and Time Expressions help.appsheet.com

(Aleksi Alkio) #6

:slight_smile:

(simon bailey) #7

Thanks. Some other useful ones on there I might go back to.