Survey123 - URL Parameters/Populate Attributes

Question

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

dougbrowning · Answer

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.

ElizabethHovsepian · Answer

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!

dougbrowning · Answer

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