nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pass globalid from dataset to embedded Survey123 form

GaryBowles1

I have a dashboard that contains 2 separate datasets. One is from an embedded Survey123 form and the other is a SQL Server view. The SQL Server view contains the globalid and inspection information from the S123 form, plus it contains various header data from our production database. I am trying to make the embedded Survey123 form filter based on the globalid from the SQL Server dataset.

Is this possible?

Thanks,

--gary

Find more posts tagged with

ArcGIS Enterprise

Accepted answers

jcarlson

Okay, so to get this to work, the Embed widget needs to be set to individual features, pointed at the SQL View layer as its data source. That way, the various filters and such can act upon it. But you'll want some way to select single records, so you'll probably want a list or table widget of the features, with selections in that widget filtering the embedded form, too.

The embed would need its URL set to something like

your-S123-url?mode=edit&globalId={globalid}

Note that the capital I on "globalId" is important.

All comments

GaryBowles1

Thanks Josh. Working now.

--gary

jcarlson

The embed would need its URL set to something like

your-S123-url?mode=edit&globalId={globalid}

Note that the capital I on "globalId" is important.

GaryBowles1

Josh,

The embedded survey123 form will be used to review and edit data. The S123 data contains info about the inspection of a well pad and contains a 5 digit code for the pad. There is no other identifying info collected in the field ie. name, location, etc.

The SQL Server data contains the globalid from the S123 dataset and header data stored in our production database such as pad name, location, pad foreman, etc. that will be used as a filter in the dashboard to select the relevant data by the user. Once the user has selected the appropriate data, the Survey123 form will take the globalid from the SQL Server dataset and display the corresponding survey record.

So far, no dice getting the S123 form to display the data. I am getting an error message stating "Editing in not possible because the globalid parameter has not been provided."

Thanks,

--gary

jcarlson

Can you elaborate on the situation a bit? Are you trying to use this to edit existing data or add new records?

When you say you want the form to filter, do you mean something like "select feature from server view, see form for the matching S1232 record"?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.