topic Re: Edit related table records in Survey123 and web form in ArcGIS Survey123 Questions

Edit related table records in Survey123 and web form

YuyingLi — Wed, 14 Aug 2019 23:43:20 GMT

Hello,

It is my understanding that starting from version 2.4 later, the edit related table records are supported. Following the document (Prepare for editing existing survey data—Survey123 for ArcGIS | ArcGIS ), this is what I dd

1. I put "allowUpdates=true" at the bind::esri:parameters column on a begin repeat question (please see the attachment).

2. Republish to the existing service (editing the existing service)

3. Re-download form in Survey123 - still cannot edit

4. I also tried the web form - no luck either

On Survey123 portal - data tab...if I want to edit the data - I got the error: editing of existing record is not supported on surveys with repeat...

Did I miss anything? What's the correct work flow to edit the existing data with repeat?

thanks,

Yuying

Re: Edit related table records in Survey123 and web form

LanceCole — Thu, 15 Aug 2019 11:28:35 GMT

Yuying Li‌,

Try using the expression query allowUpdates=true in the bind::esri:parameters field.

Re: Edit related table records in Survey123 and web form

YuyingLi — Fri, 16 Aug 2019 07:12:24 GMT

Thank you Lance -

This is what I tried:

1. Update the spreadsheet to have query allowUpdates=true at the "begin Repeat" row

2. Republish the survey to the existing service

So either in survey123 or the web form, I could tell there are 2 entries, but content is still not shown? I am using the grid format, will that matter? Though the web form seems not following the grid layout.

Re: Edit related table records in Survey123 and web form

LanceCole — Fri, 16 Aug 2019 23:44:27 GMT

yyingli

1) Can you upload a copy of the XLSForm or a functional copy that demonstrates the issue you are having? To upload a file to GeoNet; select reply to this thread then click the "Use advanced editor" option at the top of the reply box. This will enable the option to attach a file at the bottom.

2) What version of Survey123 Connect for ArcGIS are you using to publish your survey? I have several surveys running that support editing data contained in repeats from the field app that are published using version 3.5.157. I believe the newest version is 3.5.166 for Windows.

Re: Edit related table records in Survey123 and web form

YuyingLi — Fri, 16 Aug 2019 23:51:30 GMT

Sure. The XLSForm is attached. I am on the latest 3.5.166 version of Survey123 Connect

Re: Edit related table records in Survey123 and web form

LanceCole — Sat, 17 Aug 2019 01:00:31 GMT

Yuying Li‌,

I downloaded your XLSForm, loaded it into Survey123 Connect and published it to AGOL and it is running and I can edit the repeat data at least for disturbances, actions and grasses. I did not check the others. When I loaded it into Survey123 Connect using New Survey > File, I had to:

Remove the submission_url on the settings tab as I am using my own portal
The XLSForm also has three links embedded in the excel file. I just removed these for testing but it may have broke some functionality of your survey. You may have cut and pasted between workbooks/sheets and introduced these accidently. These can be viewed on your XLSForm from the Data ribbon under Queries & Connections > Edit Links.

The links point to the files noted above on the path C:\Users\YLI\ArcGIS\My Survey Designs\<filename>.xlsx

Re: Edit related table records in Survey123 and web form

YuyingLi — Sat, 17 Aug 2019 01:13:37 GMT

Lance Cole‌,

Thank you so much reviewing it...where could I find and remove those links?

Re: Edit related table records in Survey123 and web form

LanceCole — Sat, 17 Aug 2019 01:23:14 GMT

Yuying Li‌,

Open your XLSForm, goto the Data ribbon under Queries & Connections > Edit Links.

The link to AJB Reclamation Survey.xlsx is most likely the correct path for your copy. I renamed the form to import so appears broken on my copy. The others can be repointed using the Change Source option in the Edit Links dialog.

Re: Edit related table records in Survey123 and web form

YuyingLi — Sat, 17 Aug 2019 01:36:27 GMT

This is interesting...I did try copy one of the format...so we don’t really need these links, right? If I remove all of them, will that break?

Re: Edit related table records in Survey123 and web form

LanceCole — Sat, 17 Aug 2019 01:51:42 GMT

Yuying Li‌,

Please try the attached updated file. I copied your XLSForm into a new blank file. Make a copy of your existing xlsx and replace and rename it with this version. You will need to add your submission_url back in as needed.

Re: Edit related table records in Survey123 and web form

LanceCole — Sat, 17 Aug 2019 01:57:17 GMT

Yuying Li‌,

From what I can see the lookup tables for the XLSForm "type" and "appearance" columns are pointing to the other xlsx workbooks. Please see the clean copy of your XSLForm I uploaded in my prior response. Try replacing yours with this version and republish. I hope I did not breaking anything. Nice form by the way.

Re: Edit related table records in Survey123 and web form

YuyingLi — Sat, 17 Aug 2019 04:54:04 GMT

Lance Cole‌,

Thanks! How did you find those "reference"...Ok, so I used your new XLSForm and I could edit the disturbance repeat on Survey123 app...but didn't see the photos...though I could see how many of them.

Have you used the web form before? From web map, I link to the webform in edit mode. Seems still not show the content?

Re: Edit related table records in Survey123 and web form

LanceCole — Sat, 17 Aug 2019 12:19:27 GMT

Yuying Li,

Since I did not have the files on my system they were reported as broken links when I opened the XLSForm.

Pertaining to the photos, did you add the submission_url back into the form I had sent to you? I could not include this for testing as it was pointing to your portal. I am able to open, view and edit the photos in the version I have published.

The web version does not fully support all the features that are available from Survey123 Connect and can be temperamental. The data should also be available from your ArcGIS Online account if you just want to look at the raw data along with linked data i.e. photos. In Survey123 website, you can also open the map view, click on one of the points collected, at the bottom of the pop-up select “show related records”, select your photoRepeat from the list, in the photo column click on one of the “show()” then click on the photo name in the pop-up to display the linked photo.