1T - CSV Creator

POTENTIALLY BREAKING UPDATE: Version 3.6.0 added error handling to the Create CSV from JSON (SSA) action. Be sure to test any workflows that use this action when upgrading to this version.
Create a CSV file with calculations, nested lists, data from connected things, and much more!

Whatever you may need, there is no limit to the data that can be exported using the CSV Creator.

There are two supported actions:

CREATE CSV FROM JSON
This is a standalone action that allows you to quickly create CSV files and allows the user to download them directly to their computer

SEND JSON TO CSV CREATOR
This action is available only when the element CSV Creator is placed on your page. This action will return a file to the CSV Creator element which you can then save to your database, email to the user, etc.

This action also exposes an event called 'A CSV Creator has created your file' which will be triggered anytime a CSV is generated.

<--- HOW TO USE --->

This uses the operator :format as text on a list in Bubble. Get started by adding the Create CSV from JSON action to your workflow.

The File Name field can be set to a static text or you can make it dynamic if you want to save your files by date or user, etc.

NOTE: Generally you will get the option to change the file name before saving the CSV file as well.

The JSON content field simply needs valid JSON and you are good to go. However, the idea is to do a search for the data you want to export and then use the :format as text operator and create your JSON in that field as shown below.

Add a comma to the Delimiter field

Sample JSON

{
"Sale Date": "This Sales's Order Date",
"Sale ID":"This Sales's Order ID",
"Items":["This Sales's Items"],
"Region":"This Sales's Region's Name"
}

If you want to export a nested list, simply add square brackets around the value as shown in the Items value in the JSON sample

CREATE A DYNAMIC CSV FILE
(note: This action is fully functional but will not be updated further)

This action is less technical to use but is also more limited than the Create CSV from JSON action. You can use export linked data but are not able to export calculated values.

To use add the action Create a Dynamic CSV File to your workflow.

File Name
This can be dynamic or you can add static text here.

Header Fields
The header field controls the header text for that column. It also controls whether that column is included in the download. If the header field is empty, the column will be ignored.

Note, the header fields are dynamic. Why does this matter? Hey, give your users the ability to name the columns or choose which columns they want included in their download... tons of options available here.

Data
Enter a dynamic search. Remember that every column should have the same search or your CSV file will be inaccurate. You can use an element such as a repeating group as your data source if it's easier.

Select a field or select a linked data type and then select a field from that object.