Select to view content in your preferred language

Web Form URL parameters pulling from child table instead of parent GlobalID.

215
1
Jump to solution
10-08-2024 07:58 PM
Bio_InfoAdmin
Occasional Contributor

Hi, 

I have made a dashboard and a survey123 form, and I would like to select an item in a list (parent), and then be able to add a child record via a Survey123 form embedded in the dashboard.

I found this thread which seemed to explain exactly what I was after and resolved a different problem i was experiencing whereby i didnt want users to view or edit existing related records (https://community.esri.com/t5/arcgis-survey123-questions/pass-attribute-field-as-url-parameter/td-p/...), however the URL I have for my form seems to retrieve the GlobalID from the first child record rather than the GlobalID from the parent to create the relationship. Everything else is working properly. 

Here are the parameters I am using for the URL:

l&field:SiteID={GlobalID}&field:SiteName={SiteName}&autoRefresh=true&hide=navbar,header

Site = Parent, ManagementUpdate = Child

I would like to pass the GlobalID (and SiteName) of the parent to the child, which contains the GUID field 'SiteID'. this is the field that creates the relationship. The form appears to be receiving the ID and submitting fine, its just the wrong GlobalID!

Here the data in my child table during testing, you can see it keeps using the first GlobalID for that site for all the subsequent sites. 

Bio_InfoAdmin_0-1728442125597.png

This is the filter I'm using on my dashboard list:

Bio_InfoAdmin_1-1728442388814.png

It will not let me create a child record if the parent doesnt already have a child record against it (I assume because it needs that first GlobalID *face palm*), so the form just says 'No Data' and doesnt present the form for the user.

Am I doing something wrong here with my configuration? 

@IsmaelChivite are you able to help?

 

0 Kudos
1 Solution

Accepted Solutions
JenniferAcunto
Esri Regular Contributor

It sounds to me like you are using your child table as the data source for your embedded form. 

List Widget Data Source: Parent Table

Embed Widget Data Source: Parent Table

Survey URL: Survey pointed to Child Table

The URL parameter of the survey is where you actually move the Global ID into the Site ID.

&field:SiteID={field/globalid}

- Jen

View solution in original post

0 Kudos
1 Reply
JenniferAcunto
Esri Regular Contributor

It sounds to me like you are using your child table as the data source for your embedded form. 

List Widget Data Source: Parent Table

Embed Widget Data Source: Parent Table

Survey URL: Survey pointed to Child Table

The URL parameter of the survey is where you actually move the Global ID into the Site ID.

&field:SiteID={field/globalid}

- Jen
0 Kudos