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; } } }

Add new rows to existing Survey123 table

RobertBorchert

I am trying to configure a new Survey123 to add rows to an existing survey table.

I am using the newest versions of everything.

Background: A person in Project Management creates Issue numbers. She has the ability to add work groups on at the same time using the repeat feature. But she may not know all the work groups at the time of Issue Creation.

I would like to be able to have her select the existing point feature that was originally created for the Issue. And add new records onto the related Table that contains the work groups.

I have tried it by taking out the center= x,y but it simply creates a point at my current location.

is there something I need to add to my link or a setting in survey creation to add rows?

arcgis-survey123:///?itemID=<survey>&field:PROJNUM={PROJNUM}&field:ISSUENUM={ISSUENUM}&field:LOCATION={LOCATION}&field:LOCDESC={LOCDESC}&field:PROJDESC={PROJDESC}

Najděte více příspěvků označených jako

Accepted answers

IsmaelChivite

Ok. If you want to create a new row into the repeat table using a custom URL scheme call, then you need to:

* Configure your survey to target the related layer, as opposed to the main layer

* Use the submission_url setting to target your feature service first

* Use the Form_ID setting to indicate the name of the related table (coincides with the name of the repeat)

* Add the GUID field used in your geodtabase relationship to your worksheet (as a hidden field with the appropriate esriFieldType set) e

* In the survey worksheet drop the begin and end repeat as well as all the questions outside the repeat

* When invoking the custom URL call, include the GlobalID of the parent record (as a parameter with field:) and store it in the GUID field in your related table used for the geodatabase relationship. This will ensure the new row is added as a related record to the issue you selected.

All comments

IsmaelChivite

Hi.

You may want to try this:

In Survey123 Connect, enable the Inbox for your survey, disable the Sent folder and publish.

In the field app, now you will see the Inbox, which you can use to retrieve existing data. You may want to use the instance name property to set the labels in the Inbox to your liking.

The contents of the Inbox can be visualized as a map for navigation or as a list (which you can sort).

Open the survey as appropriate from the list or map and add new rows.

For reference:

* https://community.esri.com/groups/survey123/blog/2017/04/24/understanding-the-instancename-setting

* https://community.esri.com/groups/survey123/blog/2020/04/09/survey123-tricks-of-the-trade-repeats

Note: You can configure your Inbox with a query to reduce the amount of records shown in the list and map. For example, you can use the query to just show records that you expect the end user to process. More info at: Prepare for editing existing survey data—ArcGIS Survey123 | Documentation

RobertBorchert

Thanks for the response. We are trying to avoid the use of the inbox as there will be hundreds of Surveys in the In Box

IsmaelChivite

Ok. If you want to create a new row into the repeat table using a custom URL scheme call, then you need to:

* Configure your survey to target the related layer, as opposed to the main layer

* Use the submission_url setting to target your feature service first

* Use the Form_ID setting to indicate the name of the related table (coincides with the name of the repeat)

* Add the GUID field used in your geodtabase relationship to your worksheet (as a hidden field with the appropriate esriFieldType set) e

* In the survey worksheet drop the begin and end repeat as well as all the questions outside the repeat

RobertBorchert

I had my relates set up using GLOBALID and REL_GLOBALID (GUID)

I added the GUID to the url to populate it with the global id. However, it still created a new point and it took the globalid from the new point and put that in the guid field.

ZacharySutherby

Hello Robert Borchert‌,

Here is an article that discusses the workflow Isamel mentions above: How To: Populate a related table from a Survey123 for ArcGIS feature service for Collector for ArcGIS

Thank you,

Zach

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Přihlásit se
Registrovat

Rychlé odkazy

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