Survey123 Connect concatenate date and pulldata result

Elizabeth_Burniston

This is probably much easier than I am making it. I need to concatenate the year with a number generated from a pulldata calculation. It needs to read like this 24-xyzx. I know this is not the right syntax but essentially like this; %y-${formno}. I believe this needs to be in the constraint field... where I have the question marks. I receive the correct result in ${formno}, I just need to join this to the year. Let me know if you need more information! Thank you!

 

 

 

DuncanC

Yeah, you can't just throw a date format string into a concat like that.  Make a hidden datatime field if you don't already have a date field to grab the year from, set it's default to now().  Then a hidden field that uses format-date as the calculation so it's value will be 24. Then concat that with your pulldata value.

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

It should be possible to do it all in one line, but the XLSX parser in Survey123 connect is kind of broken, when I try that it never works, so I just use lots of hidden lines and do one thing per line.