Geoprocessing service for web application
Hi! I've never created a geoprocessing service before and have just started looking at what is involved. Before I get too far, I wanted to check with some more knowledgeable folks about whether what I'm wanting to do is possible and see if there are any recommendations on where to get started.
I'm creating a web application using a combination of Experience Builder and Web App Builder for Developers (embedded in Experience Builder). The geoprocessing service would be available in the WAB application. I want to create a custom tool using the geoprocessing service that does the following: (1) allows the user to subset particular columns from a feature layer, (2) creates a new field in that layer, (3) populates that new field with the sum of values in the selected columns, (4) displays/symbolizes the results of the new column on the map.
So, my feature layer looks something like this with the following attribute table:
| OID | A | B | C |
| 1 | 5 | 8 | 5 |
| 2 | 1 | 2 | 6 |
| 3 | 2 | 7 | 9 |
I'm imagining that the user opens the tool and has a list with checkboxes where they can select A, B, and/or C. If they select A and C, the tool subsets those columns and creates a new column with the sum of those values across, like so:
| OID | A | C | SUMCOL |
| 1 | 5 | 5 | 10 |
| 2 | 1 | 6 | 7 |
| 3 | 2 | 9 | 11 |
And the layer on the map would display the SUMCOL results like so:
My questions are - is this possible for a geoprocessing service? And any suggestions on where to get started/tips/tricks? Thanks in advance! I've watched a couple of geoprocessing service videos so far this morning but don't yet fully understand the potential or limitations.
Thanks! I do have a model that does most of what I need (see below). This creates a final feature layer with the new column that represents the sum of the user-inputted columns. However, I don't know how to do the final step, which is to automate adding the layer to the view and symbolizing it.
