topic Survey123 - URL Parameters/Populate Attributes in ArcGIS Survey123 Questions

Survey123 - URL Parameters/Populate Attributes

ElizabethHovsepian — Tue, 26 Nov 2019 22:34:49 GMT

If I am doing a pole inspection in Survey123 and opening the survey by selecting the pole feature from another web app as well as populating attributes of the pole within the survey, is it possible to populate attributes of a feature that has a relationship/related table to the feature that is selected? In example shown below, I would like to populate attributes not only from the pole, but from the transformer as well, such as phase, voltage, etc. Or if I was doing transformer inspections, populate attributes from transformer bank and transformer unit as well, etc. Make sense?

Thanks,

Elizabeth

Re: Survey123 - URL Parameters/Populate Attributes

DougBrowning — Wed, 27 Nov 2019 15:08:08 GMT

Did you try to access it using the {relationships/1/fieldname} syntax? (Where 1 is the relationship number from the service)

If you go into the popup config then configure attributes link it will give you a list of all the related fields names so you can figure out the correct name to use.

Re: Survey123 - URL Parameters/Populate Attributes

ElizabethHovsepian — Wed, 27 Nov 2019 22:22:24 GMT

Hi, thanks for your input. I tried what you suggested and it did not work. I tried a url string with 2 features and also one with many features. The only feature populating is the pole. Double checked that the naming convention is correct too. Here is the syntax:

arcgis-survey123://?itemID=c910f2c47e8a4af1a74c85a80807bacb&field:pole_number={FACILITYID}&field:oh_switch_number={relationships/3/FACILITYID}

Re: Survey123 - URL Parameters/Populate Attributes

DougBrowning — Mon, 02 Dec 2019 16:03:22 GMT

Hmm that all looks right. Is the field hidden or anything on form open?

Re: Survey123 - URL Parameters/Populate Attributes

DougBrowning — Wed, 04 Dec 2019 16:17:43 GMT

Had another idea. Is your relationship class 1:1 or 1:M? If it is 1:M then the {relationships/3/FACILITYID} will return a count and not values. Changing to 1:1 may work if you can.

The other option is to use Arcade and lookup the value yourself. See this post on doing a lookup to a repeat Ask about the Related table came from the repeat table in Survey123 for ArcGIS, How to show its data in pop-up?String fi…

Then you would use {expression/expr0} to grab that value for the URL.

Hope that helps

Re: Survey123 - URL Parameters/Populate Attributes

ElizabethHovsepian — Wed, 04 Dec 2019 18:38:46 GMT

Hi,

Yes, some of them are 1:M, and I will not be able to change those. I am not familiar with Arcade, but I may fiddle around with it when I get some time. Thanks for your help!

Re: Survey123 - URL Parameters/Populate Attributes

DougBrowning — Wed, 04 Dec 2019 19:00:09 GMT

A 1:M only returns a count, sum, or avg. Which makes sense since it cannot list all the values it finds in a 1:M in one value.

This also means your Arcade will query and return a list. You will need some type of code in there to pick out the one value you want.