A spreadsheet is nothing more than a formated file. This formatted fila is opened via some spreadsheet application that knows how to interpret the file format.
Find out which spreadsheet application you are using and determine what file formats are automatically interpretted as a spreadsheet. The dat ayou collect would then need to be saved in this format.
At the very least you could store the data in a comma separated value format (.csv) which can be opened by Excel and the fields would be loaded into individual cells.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you chose file based db then the data is stored in a "data.dat" file that uses "|" as the separation character. Which by the way can still be imported into Excel. If you wanted csv then this separation character would need to be modified.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can my existing form be modifed to save results to dat or csv?
I am just looking to add this feature to an existing form
I need a form to email and save results to a file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The easiest thing to do is create a simple form with file based db selected. Then using this new form, open the process.php file and copy the syntax of the file write functions and modify them to fit your completed form.
The data.dat file will need to be modified for your new form as it is prepared by adding header fields during form creation. These header fields will need to match your new form data.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a working form and completions are emailed.
How can I add saving the results to a spreadsheet too?
A spreadsheet is nothing more than a formated file. This formatted fila is opened via some spreadsheet application that knows how to interpret the file format.
Find out which spreadsheet application you are using and determine what file formats are automatically interpretted as a spreadsheet. The dat ayou collect would then need to be saved in this format.
At the very least you could store the data in a comma separated value format (.csv) which can be opened by Excel and the fields would be loaded into individual cells.
thanks!
How can I modify my existing form to save the data to a csv file>
If you chose file based db then the data is stored in a "data.dat" file that uses "|" as the separation character. Which by the way can still be imported into Excel. If you wanted csv then this separation character would need to be modified.
yes thank you
Can my existing form be modifed to save results to dat or csv?
I am just looking to add this feature to an existing form
I need a form to email and save results to a file.
The easiest thing to do is create a simple form with file based db selected. Then using this new form, open the process.php file and copy the syntax of the file write functions and modify them to fit your completed form.
The data.dat file will need to be modified for your new form as it is prepared by adding header fields during form creation. These header fields will need to match your new form data.