A database is a structured collection of data and information. In Workflow86, you can create and manage databases with our built-in databases.
Databases can be created and managed in combination with or entirely separately to a workflow. You can create a database and not connect it to any workflow. You can also create a database and have it connected into multiple workflows, and have a single workflow connect into multiple databases.
To create a new database, go to the databases page and click "New Database"
This will open up a dialog where you will need to set the name of the database, as well as the columns and column data types:
You can add more columns, edit existing columns and rename columns once the database has been created.
Once completed, a new empty database will be created:
You can also create a new database by uploading a .csv file with column names and records already inside of it. Select "new database with imported data" and then upload your .csv file.
The first row of the .csv file should contain the column names, and all following rows should contain the data you want to import, like this:
The next step is to check the data and confirm the column names and data types for each column.
Click done to create the database. Notice that the Record ID and Session ID columns are automatically added, and record IDs automatically assigned for each row as well.
Make sure you select the correct data type when importing data from an uploaded .csv file. If the data type in the .csv is inconsistent with the data type selected during the mapping stage, an error will be shown and the database will not be created.
You can also create a new database with a column for each placeholder inside a workflow. Select the "new database based on workflow" option when creating a new database, and then select the workflow you want to create the database for:
All of the placeholders from each component in that workflow will appear. You can then select or unselect the placeholder values you want to create columns for:
Click done to create the database. You will see that the database you just created now has a column for each placeholder that you selected:
Say you have a workflow like this and you want to capture the values of the placeholders every time it runs:
Use the method above to create a database based on the placeholders in the workflow.
You can now add a Create database record component at the end of the workflow:
Then set that up to create a record for each of the placeholders using the database you just created:
Now, every time this workflow runs, the values of all the placeholders will be recorded in the database.
Each column in a database must be associated with a particular data type. There are currently four options: Text, Number, Boolean, Datetime.
Once set, the column data type cannot be changed, so make sure you choose the correct data type when creating that column.
There are two main ways to interact with a database in Workflow86: manually and via a workflow.
Managing a database manually means you are using the database page interface to create, edit, delete records or columns of a database.
At the top of the database, you will see a toolbar with various actions you can take:
Read more about what you can do 👉 here
You can also interact with a database inside of workflow by using the database components:
|Create Database Record||🔀 action||Create a new database record|
|Update Database Record||🔀 action||Update an existing database record|
|Query Database||🔀 action||Retrieve a database record using a query|