Restrict time questions to certain hours

179
2
3 weeks ago
leahmaps
Occasional Contributor II

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!

0 Kudos
2 Replies
DougBrowning
MVP Esteemed Contributor

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_AF58C02... 

May have to play with the syntax a bit.

DuncanC
New Contributor III

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.

0 Kudos