Quality Control Suggestions Wanted

363
4
Jump to solution
04-14-2021 12:22 PM
JoshuaBillings
Occasional Contributor

Hey all,

I have published an Events Dashboard that staff in my Recreation and Parks department contribute to via a Survey. 

There are 4 main supervisors who are responsible for 8-10 staff each. None have any type of GIS experience.

ALL of the staff are submitting events via the Survey.

I have tried to make the Survey as simple as possible by providing predefined choices where necessary, but errors are still being made - especially in areas where data can't be predefined, such as a description of an event.

I am trying to develop a hands-off approach where all I am responsible for is dashboard maintenance, while supervisors are responsible for data integrity (correct grammar, checking for spelling, etc.).

Since I am the author of the survey, I can't allow the supervisors to go in and make edits themselves - this currently isn't allowed in Survey123.

I am in need of some sort of QC Check process that goes through staff and supervisors before it is uploaded to the events dashboard (by staff).

Does anyone have a system in place or have any suggestions on what I could do?

Thank you!

 

 

0 Kudos
1 Solution

Accepted Solutions
jcarlson
MVP Frequent Contributor

This can get quite complex, but it's possible using a variety of Layer Views together with Survey123 Connect. We have a document approval workflow that we use Survey for, and it could probably work for this.

On your main layer, add fields called something like department and reviewed. (You might not need department, I'm not sure of your situation.) Create domains on the fields to constrain the department choices and set the default value of the reviewed field to no / 0. I like to use an integer field for boolean values, but they could as easily be literal strings of 'yes' and 'no', just as long as they're consistent.

Create a number of view layers, and define their views.

Staff View

This would be similar to what you're using now in terms of sharing and editing settings, and would use whatever survey is in place. Hide the reviewed field.

Supervisor View(s)

Define the view as features where "reviewed = 'no' or reviewed is null". Allow attribute edits, but no adds/deletes. Expose only those fields which supervisors need to review / correct.

Create a new survey that references this view layer. Make that survey expose the attributes that need reviewing and correcting, and include a hidden question to set the reviewed field to "yes" upon submitting.

Create a dashboard that lists the features in this view with a linked Embed element that goes to the URL "https://survey123.arcgis.com/share/<survey-itemID>?mode=edit&globalId={globalid}&hide=theme,header,f..."

Share that dashboard with supervisors only, perhaps through group sharing settings. If your supervisors are specific to certain departments, you can repeat this process for each one. In my org, our County Treasurer and Clerk each have their own dashboards like this:

jcarlson_0-1618429935005.png

Public View

Define this view as features where "reviewed = 'yes'". Turn off all editing and make public. Use this to populate your final dashboard.

 

Like I said, complex, but the end result is a two-stage process in which only "reviewed" items will make it to the final dashboard.

- Josh Carlson
Kendall County GIS

View solution in original post

4 Replies
jcarlson
MVP Frequent Contributor

This can get quite complex, but it's possible using a variety of Layer Views together with Survey123 Connect. We have a document approval workflow that we use Survey for, and it could probably work for this.

On your main layer, add fields called something like department and reviewed. (You might not need department, I'm not sure of your situation.) Create domains on the fields to constrain the department choices and set the default value of the reviewed field to no / 0. I like to use an integer field for boolean values, but they could as easily be literal strings of 'yes' and 'no', just as long as they're consistent.

Create a number of view layers, and define their views.

Staff View

This would be similar to what you're using now in terms of sharing and editing settings, and would use whatever survey is in place. Hide the reviewed field.

Supervisor View(s)

Define the view as features where "reviewed = 'no' or reviewed is null". Allow attribute edits, but no adds/deletes. Expose only those fields which supervisors need to review / correct.

Create a new survey that references this view layer. Make that survey expose the attributes that need reviewing and correcting, and include a hidden question to set the reviewed field to "yes" upon submitting.

Create a dashboard that lists the features in this view with a linked Embed element that goes to the URL "https://survey123.arcgis.com/share/<survey-itemID>?mode=edit&globalId={globalid}&hide=theme,header,f..."

Share that dashboard with supervisors only, perhaps through group sharing settings. If your supervisors are specific to certain departments, you can repeat this process for each one. In my org, our County Treasurer and Clerk each have their own dashboards like this:

jcarlson_0-1618429935005.png

Public View

Define this view as features where "reviewed = 'yes'". Turn off all editing and make public. Use this to populate your final dashboard.

 

Like I said, complex, but the end result is a two-stage process in which only "reviewed" items will make it to the final dashboard.

- Josh Carlson
Kendall County GIS
JoshuaBillings
Occasional Contributor

@jcarlson This will work perfectly!

I have everything set up, but when a supervisor attempts to submit any changes on the embedded form, it gives an error that says "Failed to submit" without any further information.

Have you ran into this issue at all?

 

JoshuaBillings_0-1618503345614.png

 

0 Kudos
jcarlson
MVP Frequent Contributor

Ah, that's probably the sharing settings. Even if your "supervisors" layer is editable, it needs to be shared publicly to be edited by non-Creator user types.

We've never had anyone spam our view layers, but it's another reason to use the embed in the dashboard. Even though the survey and view layer are public, the dashboard isn't, so there's at least a little more control.

- Josh Carlson
Kendall County GIS
JoshuaBillings
Occasional Contributor

@jcarlson You're the man. It's working 100% now.. Thank you so much for your help!