It would be great if the output of RSForm could be piped into a Google Doc (spreadsheet) each time a submission was done. Had this feature with other form program and it was awesome.

Anyone try this using the database hooks in RSForm?

Did you ever figure out how to do this?

Thanks,
Dom

I've did this and wrote a short how-to:

crossmediacreations.nl/blog/42-using-rs-...post-to-google-drive
and a youtube video

Thanks for the tutorial! I am sure that others will make use of it as well.

Perhaps i can help out a little bit. I noticed that you are using a small Javascript to copy fields values. You can simply use the PHP Scripts > Scripts called on form display area to do this (i think this is a little bit easier for users that are not familiar with scripts). Example:

@remcojanssen,

In your video you mentioned problems with dropdowns. Basically, you will have problems with checkboxes and radio groups - all fields that have multiple options. The reason for this is RSForm!Pro handles these fields differently then Google. There is no right or wrong here - just different solutions.

For more advanced users there is always the option of using silent posting with PHP scripts. Though not a copy/paste solution, a good starting point is provided here:

http://www.rsjoomla.com/support/documentation/view-article/83-silent-post.html

remcojanssen wrote:
I tried this method, but I haven't seen any responses from my tests. It looks like I did everything the same as in the tutorial, and I made sure the form is accepting responses, but no joy. Thoughts?

no more ids are present in google sheets so it seems impossible to handle this solution.. i would have an howto update...

Seems like this solution is not working anymore. At least the blog post has disappeared and the last reply in the chain sounds like there is a problem.

Is there any hope to have a plugin or another way to solve this in the future? It would certainly be beneficial, as more and more people are using Google Sheets.