Select to view content in your preferred language

Issue with Repeats in Timber Cruise Workflow

733
3
08-07-2023 11:55 AM
HenryPoole
New Contributor

Hey Everybody - I'm a newbie with Survey123. I have an issue maybe someone with more knowledge can help me. I'm trying to develop a timber cruising workflow. My question is how do I replicate the workflow in this video?: https://www.youtube.com/watch?v=pbPNu3-aWlI

Using Survey123 Connect, I successfully published a survey  with a geopoint question which allows me to randomly walk around in the stand and collect the plot center and associated forest inventory data. It uses a repeat to store the tree measurement data. That got me started...

But what I'd like to do is publish a similar survey only this time from a existing feature layer containing a grid of plot center points.  The issues hindering my previous attempts have to do with the existing related table when I published the feature layer from ArcGIS Pro and Survey123 wanting to create another related table from the repeat question in the survey form. The repeat question in yellow below is needed in the survey just like the video.

My feature layer (CruisePoints) has a GlobalID. The related table (CruiseData) has a GUID field. I created a one-many relationship between the two before I published to ArcGIS Online. I know the repeat section in the survey is trying to make another related table called CruiseData which is probably the issue I cant seem to correct.

I've just ran out of ideas on how to get this to work.

So my latest error is this:

HenryPoole_0-1691433487742.png

 Here is a screenshot of my survey excel sheet:

HenryPoole_1-1691433832627.png

Any helps is much appreciated!

Hank

 

 

Follow us on Social Media! Twitter: https://twitter.com/Esri Facebook: https://facebook.com/EsriGIS LinkedIn: https://www.linkedin.com/company/esri Instagram: https://www.instagram.com/esrigram The Science of Where: http://www.esri.com
0 Kudos
3 Replies
ZacharySutherby
Esri Regular Contributor

Hello @HenryPoole

What do you have set for the form_id in the settings worksheet of the XLSForm? The form_id will need to be set to the CruisePoints layer. 

Also what is set for the submission_url in the settings worksheet? 

Thank you,
Zach
HenryPoole
New Contributor

Hey Zach, thanks for reaching out. I had the form_id set to CruiseData since I thought that was where the survey needed send the data.

HenryPoole_1-1691672071109.png

 

So I then switched the form_id to CruisePlots and tried to republish and got this error:

HenryPoole_2-1691672141460.png

 

 

0 Kudos
ZacharySutherby
Esri Regular Contributor

Hello @HenryPoole

If you would like to use CruiseData and the layer the survey submits to you would need to remove all the questions before the begin repeat question as well as the repeat itself. 

 

That message is indicating that you have questions in your survey that either do not have corresponding fields in the respective layer or the value in the name column of your XLSForm does not match the name of the field in the feature service. 

 

Please see the Use Survey123 with existing feature layers documentation for more information. 

Thank you,
Zach
0 Kudos