Save form data to Excel with dynamic file name

Hello

I use the Export XLS action in the setup. I now want to save a new XLS each time the form gets submitted.

In the fields File name and Post file name I can enter the name of the file.

But I need a new file name every time. So I did try to enter {name}.xls where name is the name of a form field.
Unfortunately this is not working.

How can I save every submitted form data into a new XLS file that is named with the input from the form field name?

Thanks a lot!

Patrick

Hi Patrick,

I can't imagine why you would want to do this????

You can use the GSheet save which will add a new row to a Google Spreadsheet; you can use a CSV export which you can then import as a new row into an existing spreadsheet.

If you really must do a new Excel spreadsheet with a single record then you can either use a Custom Code action after the Excel export to rename the file; or you can see this FAQ

Bob

Hi Bob

OK thank you, I'll try this :-)

Patrick