What do i use in place of action "Excel: Create Spreadsheet or CSV file"

Options
Matthew_759207
Matthew_759207 Posts: 9
in Questions

What do i use in place of action "Excel: Create Spreadsheet or CSV file"

I've used this action several times to email the data that was submitted to a web form during a run but now "Excel: Crate Spreadsheet or CSV file" is no longer available.

What can i use in its place?

Answers

  • Grant_213559
    Grant_213559 Posts: 11 admin
    Options

    Hi Matthew,

    Assuming your data is stored in a data table, I would use the "Excel: Create a Spreadsheet from a Data Table" action. You'll have to enter both, the reference table along with file type, such as .xlsx or .csv. For more information, I recommend consulting the following help article.
    Excel: Create a Spreadsheet from a Data Table

    Thanks,

    -Grant

  • Matthew_759207
    Matthew_759207 Posts: 9
    Options

    Thanks Grant, but that doesn't help.

    1 - "Excel: Create a Spreadsheet from a Data Table" action will create a spreadsheet with all of the rows in the table. I only need the fields that were submitted in the most recent submission of the web form. The action "Excel: Create Spreadsheet or CSV file" allowed me to do this in a single step.

    2 - Also, there is no longer a "select file type" option on "Excel: Create a Spreadsheet from a Data Table" action.

    matt

  • Jozef_783863
    Jozef_783863 Posts: 331 admin
    Options

    @Matthew_759207 Excel: Create spreadsheet or CSV file is now named Excel: Populate template.

    Excel: Create spreadsheet from data table does allow you to specify the output file type. The instructions for the setting named Output file name consist of inputting the file name and the file format.

    Excel: Populate template
    https://help.catalytic.com/docs/excel-populate-template/

    Excel: Create a Spreadsheet from a Data Table > File name
    https://help.catalytic.com/docs/excel-create-a-spreadsheet-from-a-data-table/#file-name

Categories