This article applies to:

FirmFlow API utility — configure FirmFlow workflows

If you request specific FirmFlow workflow type data, complete these steps to calculate the amount of time between the workflow steps.

In FirmFlow select File
then Get Users and Groups
.

Create a table called GFRUSERSANDGROUPS in your database. This table will store GoFileRoom user and group data.

Select File
again then choose Workflow Step Duration Config
.

Select the arrow in the Table Name
field to choose a table.

If this table includes a Workflow JSON request, the workflow name will appear in Workflow Name
.

If the application didn't populate Workflow Name
, review your JSON request on the Main screen.

Select Get Steps
to populate Starting Step
and Ending Step
. This lets you choose steps to compare.

Enter the Column Name
. This name will appear in the SQL database with a "Duration_" prefix.

Select Add
to add the table.

Select Update
or Delete
if you need to change or remove an existing row.

Select Save
.