Workflow Wizard - Definition

Why are there 2 sets of columns?

All GeoSync GO workflows include 2 SQL tables (2 primary views) for storing information. One is designated for Feature information and the other for FeatureInspection records.  The columns included in each table will be identical but a different set of columns can be activated for each table. Tables are named [WorkflowName] and [WorkflowName] + "Inspection"

What does it mean for a column to be checked?

Checked columns on the left (Feature) represent active Feature columns and Checked columns on the right (Inspection) represent active Inspection columns.  These are stored as SQL Database views with a naming convention of "vw" + [WorkflowName] and "vw" + [WorkflowName] + "Inspection"

Do I have to use both sets of columns or tables?

No, simple or standard workflows only use the Feature table (left side).  Advanced workflows take advantage of the "Inspection" table (right side).  Advanced workflows are typically used when you want to develop 1 to many relationships (Feature to Inspection) or you want to capture field reports and have a chance to review and approve them before the Feature table is updated.

How do I add columns?

There are two ways to add columns 1) click the Add button and specify the column and 2) use the import tools to pick columns from other "GsGo" workflows or an existing "MDB" or "DBF" file.

Can I modify a column once it has been added?

No, if you need to change the column definition you will need to delete it and then add it back.  Note: deleting a column deletes any existing data stored in this column.

Can I change the order of the columns?

Yes, select a column and use the up / down arrows to change its position in the list; or, you can drag and drop columns up and down the list (this is more flexible and quicker).

Why does the PROJECTID column always show up in my list?

This is a system feature and is always included. Workflows are deployed based on the GeoSync GO project they are assigned to.  The PROJECTID column is always included to track which project a report was created from.  This feature provides a way for you to use the same workflow to collect and track information from multiple projects - just sort or filter records based on the  PROJECTID to separate records.

How do I specify drop down lists for columns?

You can do this by selecting the column and clicking the field option button. Use the text editor to create the drop down lists you want associated with this column.  Lists are associated based on Column name across workflows - each account supports one list for a given column name. Note the syntax for comma separated lists: [value];[prompt],[value];[prompt]