Hello,

Is there a way to automatically generate a report with all form results and then send this report automatically to the client (for example once a day)?

Explanation:
I've created a dynamic form for registration for a seminar. Every day I want to send a list with all registration data to another person.
I know I can download an excel file with all form results and then send an email. But I want to schedule this activity so it executes every day.


Kind regards, Jeannine

There is currently not a method to schedule this, it would be worth asking DataSprings if they could add it as a feature to the module.

Hi Lee,

I've asked DataSprings if there is a way to solve my problem (wish).

Here is a reaction:
I don't believe this is possible within the context of Dynamic Forms because email completion event gets fired when the form is submitted. You can't set it to run only once a day. To accomplish this, you would need to create a Scheduled Task within SQL Management Studio (SQL Server Agent) to email the recipient based on an SQL query.
The SQL query would be an inner join on two tables (dynamicforms_question and dynamicforms_questionresponse). You can filter on "responsedatetime" to get responses for that particular day only. You could also set it to save to a CSV file some where and email it out as well (perhaps create an SSIS package) for automation. -- David

So this is what I'm going to find out right now.

Anyhow, thanks for your help.

Jeannine