Don’t know how ideal this solution would be for you but you can try…
Create a new resource with content/type TSV and richtext false
(I prefer TSV over CSV as escaping commas can get messy). (You’ll also need to create a new content type under Content > Content Types – file ext .tsv and mime: text/tsv).
Using Rowboat extra add this to your resource document
Make sure to publish the resource… (I forgot and took me a solid 5 min to figure out why it wasn’t pooling data… ).
- Create a chunk called
formit_tsv and add the following:
[[+form]] [[+values]] [[+ip]] [[+date]]
Make sure that those placeholders are actually spaced by tabs (open a code editor and find/ replace \s with \t should work). Also, make sure that you have a new line after this code (so 2 lines with second one empty).
Now when you view the resource it should download a TSV file with your forms… do note that if your forms are encrypted you’ll only get a hashed string in the
[[+values]] field. I highly recommend you encrypt your forms to conform with GDPR (and its good security practice). I personally haven’t figured out how to decrypt the data… i’ll get there someday This is just an example after all.
- Create a google sheet and add
This will add that data directly to the Google Sheet, you can then share that with your client.
I’ve tried the above and it seems to be working alright… the issue is my forms are encrypted so I’m just getting the hashed values. If you figure out how to decrypt them let me know
Best of luck