topic Re: format-date issue in web form in ArcGIS Survey123 Questions

format-date issue in web form

ChrisRoberts2 — Wed, 27 Apr 2022 23:23:27 GMT

Hi All

I have created a form in survey123 connect and as part of that I create a unique ID which is a concat of the user ID and the current date and time:

concat(${observername},"_",format-date(once(now()), '%y%m%d%H%M%S'))

This works fine in the Survey123 app eg 9359_220427140725

However if I use the webform (desktop browser) I get this result: 9359_Invalid Date

Does anyone have any suggestions?

Cheers, Chris

Re: format-date issue in web form

IsmaelChivite — Thu, 28 Apr 2022 04:34:00 GMT

once would generally be used like this:

once(concat(${observername},"_",format-date(now(), '%y%m%d%H%M%S')))

However, it is not guaranteed that ${observername} has a value when the form is loaded. You may want to consider using

concat(${observername},"_",format-date(now(), '%y%m%d%H%M%S')

Re: format-date issue in web form

ChrisRoberts2 — Thu, 28 Apr 2022 04:53:02 GMT

Thanks for the rapid response Ismael!

You are right that with once the observer id wasnt populating. However the second option works...although I had to add another close bracket at the end 🙂

concat(${observername},"_",format-date(now(), '%y%m%d%H%M%S'))