topic Re: Survey123 web app field calculation in ArcGIS Survey123 Questions

Survey123 web app field calculation

Alba_Page — Wed, 11 Aug 2021 12:20:32 GMT

Hi everyone!

I think I'm missing something and maybe any of you can enlighten me.

I've seen this video of the past UC (https://uc2021.esri.com/live-stream/19775151/ArcGIS-Survey123-An-Introduction-and-Whats-New) and I understood that the filed calculations are already available the Survey123 web designer.

I've also seen this Story Maps with the same information in the What's new section (https://storymaps.arcgis.com/stories/213b214a74a0489dae915ab46677adf1)

But when I try to do it myself the option is not available neither the hide field option.

As I said, probably I'm missing something, but I don't know what 🙂

Thaks a lot in advance!!!

Alba

Re: Survey123 web app field calculation

Jim-Moore — Thu, 12 Aug 2021 04:16:41 GMT

Hi @Alba_Page

Calculations in the Survey123 web designer will be supported in the next Survey123 release (3.13), along with the ability to hide questions. This functionality is currently available in the Survey123 beta website, which is available via our Early Adopter Community.

Stay tuned to our Esri Community blog for announcements about the next release.

Best, Jim

cc: @ZhifangWang @JodyZhengLiu

Re: Survey123 web app field calculation

Alba_Page — Thu, 12 Aug 2021 07:03:02 GMT

Thanks a lot @Jim-Moore

As you said, I 'll stay tuned for the next release 🙂

Best,

Alba

Re: Survey123 web app field calculation

Jim-Moore — Tue, 28 Sep 2021 03:09:40 GMT

Hi @Alba_Page

In case you haven't seen the release announcement, the September 2021 update (version 3.13) is out now. Please see all the details in the What's New blog post.

Best, Jim

Re: Survey123 web app field calculation

Alba_Page — Tue, 28 Sep 2021 06:10:53 GMT

Thanks a lot @Jim-Moore 🙂

Alba

Re: Survey123 web app field calculation

KevinMWright13 — Thu, 24 Mar 2022 18:55:02 GMT

Hi - Very happy to see the Calculations in S123 Web Designer. I see that there is a "Joins" function that seems to concatenate and is helpful. However, I can't seem to find the documentation on it. I am trying to find out if I can add new lines, commas, and spaces when concatenating fields. For example, I have Address, City, State and ZIP fields that I would like to concatenate with nice formatting so that the result is the equivalent of:

123 Main Street

Frederick, MD 20152

That would require me being able to add a <newline>, a space and a comma. Any idea where I can find the documentation?

Thanks!

Re: Survey123 web app field calculation

Ruth_JiatengXu — Fri, 25 Mar 2022 03:20:29 GMT

Hi @KevinMWright13

Thanks for sharing here, and we will include more on string concatenation in the doc.

Here is an example to create a formatted address with the line break, comma, and space.

The comma and space can be added directly into the calculation field with join.

Adding a line break is not directly supported in the website calculation, and this is a valid enhancement we considered to support in the further release. The example below shows a workaround method, the line break field is a multiline text question with only line break (enter key) as the default answer.

Thanks,

Ruth

Re: Survey123 web app field calculation

KevinMWright13 — Fri, 25 Mar 2022 03:26:36 GMT

Ruth,

Thanks so much for the prompt response! I just tested it and it works beautifully!

I will use this workaround until we get a NewLine function implemented. You just made my night.

Thanks,

Re: Survey123 web app field calculation

KevinMWright13 — Mon, 18 Apr 2022 15:35:23 GMT

Hi again,

I have been using the field calculations for a little while now and it is hugely helpful to our workflow. However, I noticed that you cannot use data from a Dropdown in a calculation. I find this a bit odd, because it is really just an esriFieldTypeString. Am I just not understanding it properly, or is this currently a limitation of calculations in the Web Designer?

Thanks!

Re: Survey123 web app field calculation

IsmaelChivite — Mon, 18 Apr 2022 16:27:14 GMT

Hi Kevin. That is right. At this moment, the web designer does not let you use data from a dropdown question in a calculation. This is something that we will resolve in the future. In the meantime, you will need to use Survey123 Connect.

Re: Survey123 web app field calculation

KevinMWright13 — Mon, 18 Apr 2022 20:37:47 GMT

As always - thank you for the quick response. Thanks for confirming my suspicions. We will use Connect for this one.

I also just want to say thanks for all the great additions to the Web Designer that your team has implemented lately. Great tool already, better with every iteration.

Re: Survey123 web app field calculation

ZachESpencer — Wed, 20 Apr 2022 18:13:31 GMT

Hi Ismael,

I'm actually working along with Kevin on this and wanted to chime in a thanks for the quick response and also mention that if there were a way we could concatenate the date into a contrived field as well it would be pretty sweet. Thanks!

Re: Survey123 web app field calculation

ZhifangWang — Thu, 28 Apr 2022 08:17:53 GMT

Hi @KevinMWright13 ,

Can you please share more details for how you want to use the answer of a Dropdown question in a calculation?

Re: Survey123 web app field calculation

ZhifangWang — Thu, 28 Apr 2022 08:24:24 GMT

@ZachESpencer,

Would you mind sharing more details for how you want to utilize the date info? For example, concatenate a date from Date question into a string like "Incident observed on 4/28/2022"? Is that important to control the date format or just use default (like in the example) is enough?

Re: Survey123 web app field calculation

KevinMWright13 — Fri, 29 Apr 2022 16:15:50 GMT

Hi @ZhifangWang,

Absolutely - and thank you for asking. In my case, our organization has several sub orgs. We have those sub orgs in a Dropdown. The user selects which sub org they are a part of. We want to use that sub org, the current date and their name to create a ticket number.

where:

AGENCYABC_ joins<sub-org>joins<date>joins _ joins<username>

such that the ticket number looks something like:

USDHS_CARR04292022_KWRIGHT

I hope that is helpful.

Re: Survey123 web app field calculation

KevinMWright13 — Mon, 02 May 2022 22:34:41 GMT

As far as the date formatting, that sure would be nice, but please don't let it get in the way of releasing a first version, if the formatting is an issue.

thanks as always!