Hi,
I'd like to install a pro version of Chronoforms in a website. My customer ask to get at the end of every day just a .cvs file contain all the new data collected in just that day.
Is it possible?
How can I set the "send" action to do this?
I don't know if is it possible to collect every single form in joomla db and at the end of the day the system send all the day collected data by email in a cvs format.
Thank you for answer
I'd like to install a pro version of Chronoforms in a website. My customer ask to get at the end of every day just a .cvs file contain all the new data collected in just that day.
Is it possible?
How can I set the "send" action to do this?
I don't know if is it possible to collect every single form in joomla db and at the end of the day the system send all the day collected data by email in a cvs format.
Thank you for answer
Hi webmasterinaffitto,
It's probably simplest to do this using a cron job on your server with a bit of PHP (or you could call a from event if you like).
There is also a MySQL excel extension that can sync between your server database and Excel - provided that your server allows remote access.
Or you can save the form data on submission to Google Sheets and export from that as needed.
Bob
It's probably simplest to do this using a cron job on your server with a bit of PHP (or you could call a from event if you like).
There is also a MySQL excel extension that can sync between your server database and Excel - provided that your server allows remote access.
Or you can save the form data on submission to Google Sheets and export from that as needed.
Bob
It is possible.
In your form, set your event to "standalone"
Read data, save to csv, email the client.
Set up your cron job to point to yoursite.com/index.php?option=com_chronoforms6&chronoform=YOURFORMNAME&tvout=view
You could also do the same thing, but purchase my Save to Google Sheets action.
In your form, set your event to "standalone"
Read data, save to csv, email the client.
Set up your cron job to point to yoursite.com/index.php?option=com_chronoforms6&chronoform=YOURFORMNAME&tvout=view
You could also do the same thing, but purchase my Save to Google Sheets action.
This topic is locked and no more replies can be posted.
