topic Re: GIS Request Management - Adding a new field in ArcGIS Solutions Questions

GIS Request Management - Adding a new field

BrandiRank22 — Thu, 25 Jul 2024 21:01:43 GMT

Hello everyone! It has been so great to see and hear all the enthusiasm around the new GIS Request Management solution. Many of you are up and running and it is so cool to see.

However the #1 question / issue folks are having is adding fields to the request forms. Here is the approach:

1. Add new fields as needed to the GIS_Activities layer.
Do not add domain values - we have seen issues with this

This layer is used for both the GIS Requests and the GIS Activities Survey forms.

2. Open the forms that you want to add the new field(s) in Survey 123 Connect

3. Add the fields to the form manually

4. Add "choices" to the fields for the pick list as appropriate.

5. Publish the survey

6. Update the views - the views do not automically show the new fields - https://doc.arcgis.com/en/arcgis-online/manage-data/set-view-definition.htm

@DanielWickens

Re: GIS Request Management - Adding a new field

Cierra_Scriven — Fri, 26 Jul 2024 01:44:28 GMT

I did try this but the problem seems to be that it stalls forever during publishing at the “adding # field(a)” step, endlessly spinning.

I checked the itemID for the form (based on other troubleshooting posts) and it matched the AGOL folder so that wasn't it.

Alternatively, I tried adding the field to the hosted feature layer and then re-syncing the form into survey123 connect to add the fields, but still it considered the added fields new schema to be added (double checked edri field type bind, alias, etc all identical).

Re: GIS Request Management - Adding a new field

Cierra_Scriven — Fri, 26 Jul 2024 01:46:20 GMT

Side note: they really should let us go back and edit our previous posts for spelling errors some of us have clumsy thumbs (clumbs?)

Re: GIS Request Management - Adding a new field

BrandiRank22 — Fri, 26 Jul 2024 13:07:06 GMT

Hi Cierra! 😁

Are you deploying the solution in AGOL or Enterprise?
I am going to do some testing this morning.

Re: GIS Request Management - Adding a new field

BrandiRank22 — Fri, 26 Jul 2024 13:26:56 GMT

Some additional details to add to the above I decided to document while I was adding a field - which was a success.

Open the XLS form
Add new row where you want to the new field to be included
- be aware of the repeats for effort and comments and make sure you stay out of those groups in the form
Add the name - make sure it is exaclty what you have added to the feature - this sould be all lowercase
scroll over to the bind::esri:fieldType and bind::esri:fieldLength columns and fill out appropriately.

If you want to add a pick list make sure you add your "choices"

save the XLS - see the new field in the preview
Don't be afraid to click "Update" if things get weird.

Click Publish

When the popup shows alerting you that the survey has already been published and that the survey contains questions that are not consistent with the corresponding field alias - IGNORE IT do not toggle the switcher on you don't want to do this.

Click Publish survey

Re: GIS Request Management - Adding a new field

Cierra_Scriven — Fri, 26 Jul 2024 16:06:20 GMT

AGOL. I'd like to do Portal but after browsing the solutions gallery it does not seem to have been released there yet.

Re: GIS Request Management - Adding a new field

BrandiRank22 — Fri, 26 Jul 2024 18:20:25 GMT

Some more details as I have been working with folks.

1. If you want to update the GIS Activity form - add field to GIS_Activities first, then add field in Survey 123 and publish.

2. If you want to update the GIS Service Request Form - add fields to GIS_Activities first, then "Update View" for the GIS_Requests view layer, then add fields in Survey 123 and publish

3. If you want to update the GIS Request Satisfaction Survey Form - add fields to GIS_SatisfactionSurveys first, then "Update View"on GIS_SatisfactionSurveys_submit view layer, then add fields in Survey 123 and publish.

Another thing came up while talking to a customer - they had created a join view of the GIS_Activities layer to play around and then ended up deleting it because they didn't want or need it. But with the new recycling bin it doesn't fully delete. Therefore the schema was locked on the GIS_Activities layer. Once we deleted that join view permanently from the Recycle Bin the schema was not longer locked.

Re: GIS Request Management - Adding a new field

DanielWickens — Fri, 02 Aug 2024 17:34:55 GMT

The solution is only available for ArcGIS Enterprise 11.3 at this moment. If you're running an earlier version, the solution won't be in the Solutions App gallery in your Portal.

Re: GIS Request Management - Adding a new field

SadieBarker — Thu, 22 Aug 2024 14:48:41 GMT

I am seeing this same behavior in AGOL (hoping to publish in our Enterprise account once we've upgraded to 11.3, but wanting to test the solution for now). Publishing stalls indefinitely while trying to add a new field to the request survey even though the spreadsheet is filled out (all fields mentioned above) and the Survey123 Connect app updates correctly. Everything looks right, but when I click Publish, I get an endless spinning circle.

Re: GIS Request Management - Adding a new field

DanielWickens — Fri, 23 Aug 2024 17:04:35 GMT

Hi @SadieBarker - If you want to update the GIS Service Request Form - make sure you add fields to the GIS_Activities feature layer first, then "Update View" for the GIS_Requests view layer to have the added fields show up in the view, then add fields in Survey 123 and publish. Let me know if you're still running into issues.

Re: GIS Request Management - Adding a new field

SadieBarker — Tue, 27 Aug 2024 15:49:30 GMT

Thank you for the clarifying details, but I'm pretty sure I'm following all of these steps correctly and still getting stuck on the Publish step. Again, this is via AGOL (will move to Enterprise later), so not sure if that could explain it. We are just experimenting for now.

Re: GIS Request Management - Adding a new field

DanielWickens — Sat, 31 Aug 2024 19:05:06 GMT

Is there a specific step of publishing in Survey123 connect that it hangs up on? Would you be able to share your XLS form with me and I can take a look? I'm also happy to connect with you to further investigate.

Re: GIS Request Management - Adding a new field

Kara_Shindle — Tue, 17 Sep 2024 15:31:50 GMT

I have added a few fields in the GIS_Activites hosted feature layer, but the GIS_Activities_effort view doesn't not provide an update view option in the Settings. Was able to update other views. Any thoughts?

Re: GIS Request Management - Adding a new field

BrandiRank22 — Wed, 18 Sep 2024 13:59:39 GMT

@KaraShindle

Yeah, so those are "joined views" which means they must be deleted and recreated to acknowledge the adds. If you need those new fields in the views, I would make some copies of the current views and apps, because it could be very helpful when configuring the apps when you make the new updated views.
I have also spoken with customers who elected not to recreate the views, but rather use a different source for those applications. The functionality you lose is the ability to filter in the applications by customer satisfaction - which at least one person I know of decided was worth the loss.

Re: GIS Request Management - Adding a new field

pbirdwell — Tue, 01 Oct 2024 16:29:26 GMT

I am experiencing the same issue that other users have. I followed the workflow, but I'm still stuck on the Publish step. In the publishing process, the GIS service request step keeps endlessly spinning and does not get published. I tried to modify the Arcgis account request, and even with another survey I created and published using the same workflow, and it is happening the same. I wonder if it is something related to survey123, the XLS form, and the connect desktop app after publishing? Thanks

Re: GIS Request Management - Adding a new field

BrandiRank22 — Tue, 01 Oct 2024 16:37:54 GMT

@pbirdwell
To confirm - if you are updating the GIS Service Request form you have:

1. Modified the GIS_Activities layer by adding a new field.
2. Updated the view GIS_Requests and added that new field to the view?
Check the view to make sure you see the new field.

3. Opened the GIS Service Request form in Survey123 Connect
4. Added the new field to the form and filled out the row.
5. Added a choice list if appropriate.
6. Publish

Re: GIS Request Management - Adding a new field

pbirdwell — Tue, 01 Oct 2024 17:22:01 GMT

Yes, that is what I am doing. The issue is that when I publish (step 6) the survey, it keeps spinning, and it happens with any survey I have published. Thanks

Re: GIS Request Management - Adding a new field

pbirdwell — Tue, 01 Oct 2024 18:29:39 GMT

Thanks, @BrandiRank22 . I reinstalled the Connect desktop app again, and it is working.

Re: GIS Request Management - Adding a new field

pbirdwell — Thu, 03 Oct 2024 17:43:04 GMT

Hello! Yesterday, I followed all the steps, and it worked. Today, even though I perform the same workflow, the next button is inactive when I try to publish the survey. Do you have any suggestions or explanations? I

Thanks

Re: GIS Request Management - Adding a new field

DanielWickens — Thu, 03 Oct 2024 20:21:05 GMT

@pbirdwell - It looks like you added a question/field (department) to your survey that is not currently in the existing AccountRequests feature service. To proceed, you'll need to toggle on the option to 'Add the following fields when publishing' in order to add the new field to the feature service. You will then be able to click Next and continue publishing the survey.