Generate index letter in Geocortex Workflow 4 (and actually building the workflow)
This video shows how to generate an index letter (a, b, c and so on) for features selected by an end user using Geocortex Workflow 4.
Originally, the goal is to have talking points for a meeting an 'number' them. The intention was to generate index letters to use in a Geocortex Report. The end user can select one, multiple or all talking points in GeoWeb.
However, the end users wanted letters instead of numbers. Luckily, VB Script has the string function 'Chr' to convert a number to a letter. More information here: https://www.w3schools.com/asp/func_ch...
The video only shows the side of Workflow Designer 4, not how it is implemented in conjunction with the Report. The concept is simple.
1. The user selects one, multiple or all features in a list box.
2. The selected values are converted to a list (.tolist).
3. The workflow iterates through this list (for each) and for each feature calculates an index number.
4. This index number is converted to a letter (Chr()). To each number 96 is added to find the lower-case letter.
5. Finally, the result is shown in an Alert.
In an actual workflow, the number and/or letter could be saved to a feature service or used in any other manner.