There is no auto-export function. Nothing in WordPress can happen without accessing a page. And there is no function to merge data from different exports into the same file.
You could use the Google Live Data mechanism to have a google spreadsheet pull the data in. The problem is that the SS caches the data. It updates it intermittently, but there is not way to trigger it. Also there isn’t a way (I know of) to merge data from different sites. You could make a tab for each.
You could write a bash script on Linux using curl or wget to fetch an export URL for each of your sites. You can create an export URL on the Short Code Builder page by selecting the [cfdb-export-link] short code then copying the URL on it.
I have been thinking about writing something to push form submissions into a cloud based DB which would allow you to get submissions from different sites at the same place. But that would cost me money to run, so I would have to sell it as a subscription service. It’s unclear if there is much demand for that.
Hi Michael,
Thanks for your reply. I will make a tab for each site than and use a macro to combine all those tabs. I guess that will work for me.
