Note: The Tables feature is not included in some subscription plans.
Tables let you simply and securely store data across FLO executions, with no external services or additional credentials required. Example uses include:
- Build FLOs with greater context. For instance, you may have a FLO that processes incoming customer requests and adds information to a table for customers who require special follow-up. The FLO can check to see if it’s the second request that week for a customer and decide to take immediate action. A different FLO can run each Monday morning to assign the remaining customer requests.
- Track and report on data that passes through FLOs. You can keep a running count of specific events. Or, store individual transactions to include in a monthly reports to management.
- Share constants across FLOs. You might need a customer table for the IDs used by different cloud services so your FLOs know how to look up the same customer in different places. Or, you might have a standard price sheet that several FLOs refer to.
Creating and Editing a Table
Create a new table by clicking on the “New” button at the top-right and choose “New Table”.
Give it a name (default is “Unnamed”). Then, click “+New Column” for each field you want to add. You can set fields to be text, number, date or true/false, or there’s a special type called “counter” for fields where the updates will all be adding to (or subtracting from) the current value. The advantage of using a counter field is that multiple FLOs can make updates to the same record at the same time without worry of conflicts or loss of data.
Once a column is added, you can click the gear icon next to the column to edit it. You can resize columns by dragging the right border of the column header. Click a column header to sort by that column. Click again to reverse the sort order. You can drag and drop column headers to re-order the columns. Use the ”Columns” button to decide which fields are visible. Use the “Filter” button to view only those records that match criteria you provide. Use “Import” to read data into the table from a CSV file. Use “Export” to create a CSV file from the data.
To add or edit records, just click in a row and then enter or edit the values. Click the red trash can button to delete the selected record. Fields that include “(Auto)” are automatically generated and cannot be edited, e.g. the row ID or creation date.
All changes to a table are saved immediately.
To duplicate or delete a table, view it in My FLOs or whatever folder it lives in and choose the appropriate button when you move your mouse over the table name. If you want to share a table with other users in your organization, place it inside a shared tab. (For more details on sharing, read Sharing FLOs.)
Accessing a Table from a FLO
Once you’ve created a table, one or more FLOs you build can reference that table.
To use a table from a FLO, add function cards from the “Tables” category when you click “Add Function.” Function cards allow you to create, read, update, and delete records from one of your tables. Click the help button at the bottom of any card for specific help on how to use that card.