Application Tables are a special category of data table available to each Catalytic team. An Application Table is a read-only table that collects and stores helpful information that can be used in automation.
There are currently two types of Application Tables
The Process Template Application Table will automatically collect and store basic information about every process on your team. Including Process ID, name, category, owner, created date, and other general information about each process template.
The User Application Table will automatically collect and store basic information about your team’s Users, such as user name, name, last login date, status, and other general information about each user.
Application Tables are helpful references. They are read-only and are most useful when manipulated with Table actions to filter, sort, and create conditions based on the fields. Application Tables are a high level view where critical information is stored all in one place.
For example, you could automate switching owners of processes using the Process Template Application Table:
- If someone switches roles in a company, filter the application table for processes they own and use the Workflow: Update a process template action to change the old owner to another user.
As another example, you could automate user account management using the User Application Table:
- Filter your users for people that haven’t logged in for more than 3 months and automatically send an email with a reminder that their account may be deactivated.
Every data table you create or have shared with you is tracked and listed on the data tables screen, accessible from the Data section of the menu on the top navigation bar. Application Tables will start with “Application Table:”, like for example, “Application Table: Process Templates”
You can also search for a specific Application Table. Select in the top right corner of any screen to start a search. A global search will search within your entire Catalytic team. Search for “Application Table” to look for these tables across your team.
The Application Tables are preloaded with a bunch of helpful data on each Workflow and user. See a description of each field from the Application Tables below.
- Process ID: The ID for the Workflow. The ID can be used when referencing a Workflow by table, field, or ID.
- Process Name: The process name is the unique name for the Workflow. Two Workflows can have the same display names, but process names are always unique.
- Display Name: The Workflow’s name. This is the name that displays when browsing Workflows.
- Category: The Workflow’s category.
- Owner: The Workflow’s owner.
- Created Date: The date the Workflow was created.
- Archived: Whether the Workflow is archived.
- Public: Whether the Workflow is public.
- Manually Startable: Whether the Workflow can be started manually.
- Duration After Completion to Delete Instances: For a given Workflow, how long after an instance completes that the instance data is deleted. See the data retention article to learn more about deleting instance data.
- User ID: The user’s ID. The ID is unique to a user.
- Team Name: The user’s team name.
- Username: The username is retired throughout Catalytic—the full name is now used as a username.
- Email: The user’s email address. This is set during account creation.
- Phone: The user’s phone number, if supplied.
- Slack Username: The user’s Slack username, if supplied.
- Created Date: The date the user was created.
- Full Name: The user’s full name. This is set during account creation.
- Experience: What version of Catalytic the user has enabled. Either
- Team Owner: Whether the user is the team owner.
- Team Admin: Whether the user is the team admin.
- Deactivated: Whether the user has been deactivated.
- Locked Out: Whether the user is locked out.
- Last Login Date: The date the user last logged in.
- Last Login IP Address: The IP address of the last login.