Restrict time questions to certain hours

Question

Hi,

I am wondering if it is possible (in connect) to restrict questions to certain hours. I have two time questions (start and end) so I am hoping to set both from the hours of noon-11:59 pm, where people can't input before noon.

Is this possible? I have seen other constraints done on time questions but nothing like this. Thanks!

DuncanC · Answer

What I'd do is create a hidden field with the bind type set to null so it won't exist outside of the form and I'd have it be the hours portion of the field we're checking, format-date(${field_name},'%h').  Then my constraint would just look at it and everything is easy.    You could mess around trying to make it work on one line,  maybe that's possible, but Survey123 wastes my time when I try so extra lines of hidden fields it is.   It ends up being nice to read and modify when I come back to it later.

dougbrowning · Answer

format-date(${previous_time},'%H:%M') may work.

Something like int(format-date(now(),'%H')) > 12

See here for more  https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION2_AF58C0297155474F993CEA115682CED3

May have to play with the syntax a bit.