Editing CSV Records in a Form

Overview

The CSV Editor Form component allows for the editing of CSV-formatted tabular data, such as a spreadsheet. A CSV Editor can use Flow data as Input and Output the edited values back into the Flow.

Example

1. From a Designer Project, select the CREATE FLOW button from the Global Action Bar; select Flow, provide a Name, and click CREATE. 
2. From the Flow Designer, click the SETUP INPUT DATA button. Then, click DEFINE. 
3. In the Data Definitions screen, NAME the Data "File", select File Data from the TYPE dropdown. Save the Data Definition, then close the window. 
4. Attach a Show Form step from the FAVORITE STEPS category of the Toolbox tab, to Start step. 
5. From the Show Form step's Properties tab, click PICK OR CREATE FORM, select CREATE, choose Form, provide a Name, then click CREATE.
   
6. From the Form Designer, create a Form containing a Button component from the FAVORITES category of the Toolbox tab, and a CSV Editor from Toolbox > DATA > FILE. 
7. Save the Form, then close the Form Designer via X.
8. Back in the Flow Designer, connect the Done path to the End step, then navigate to the Show Form step's Properties. Under INPUTS, map File to CSVEditor. 
9. Save the Flow, then if desired, close with X.

Debug

1. From the Flow Designer, select the Debug link from the top action bar. 
2. In the Debugger, use the Drag file here field, or the CHOOSE FILE button to select the desired CSV file. 
3. Click START DEBUGGING. 
4. Make any desired edits to the CSV file. 

   To edit any cell, select the cell then adjust the value and either press the enter key or click out of it.
   To add an additional blank Row, click either Insert Above or Insert Below.

5. Click the Download button and verify that the contents of the spreadsheet.