topic Re: Storing week number in Survey123 in ArcGIS Survey123 Questions

Storing week number in Survey123

HayleyRobins — Thu, 01 Feb 2018 11:43:00 GMT

I would like to name the surveys in my Inbox based on the week number.

Is it possible to extract the week number from the current date and use it as part of the instance_name?

Thank you,

Hayley

Re: Storing week number in Survey123

JamesTedrick — Thu, 01 Feb 2018 18:36:42 GMT

Hi Hayley,

The Survey123 mobile application supports %W to provide the ISO week number.

Re: Storing week number in Survey123

HayleyRobins — Fri, 02 Feb 2018 15:36:36 GMT

Thanks James. Could you give me the syntax? I'm trying:

format-date(${my_date},'%W')

but getting an '"unrecognized escape in date format string" error.

Thank you

Re: Storing week number in Survey123

JamesTedrick — Fri, 02 Feb 2018 16:22:29 GMT

Hi Hayley,

Yes, I'm seeing the same issue in the creation of the form XML file. You can work around it by using another date format (say, '%M'); after the form processing is completed, you can manually substitute '%W' for '%M' in the XML file and then publish. I'll file an issue to have the form validator accept '%W'.

Re: Storing week number in Survey123

HayleyRobins — Fri, 02 Feb 2018 17:20:15 GMT

Brilliant thank you. The workaround works great!