Export To Google Docs
Started 8 years ago by branson123 | 7 posts |
Ok so firstly im a front end designer not developer so stop me if im talking rubbish.
Is it possible to incorporate the google spreadsheet API into the form to get the results to post straight to a Google Docs Sheet?
BriPosted 8 years ago #
Technically speaking, it is possible to do so. However, the details might require some effort.
Basically you can plug any additional code into machform form processing function.
The file need to be modified is "includes/post-functions.php" file. You'll find a function called "process_form" there.
You can put any custom code at the end of that function.
To give you some example, here is modification by other machform user:
it's not Google Docs, but the process is similar as above.
MachForm FounderPosted 8 years ago #
Hello Yuniar, this reply is over three years old and I was wondering if it's still the answer?Posted 5 years ago #
@danielmee: I'm sure that the solution presented in the message linked to above is completely out of date by now, although I admit I haven't even looked at it; however the Machform code has change a lot since then. It may now be possible to do what you want by using the new webhook feature, without modifying any Machform code.
However, I can't help you with this, assuming it's possible.Posted 5 years ago #
I'm happy to report that I have tested out using Zapier and successfully send Machform data to a Google spreadsheet! It took a few times to get all the fields to populate in Zapier so I could match them from the form, but it worked very well. I didnt use the 'send raw data' because I didn't know the code to put there. So I opted to match the fields and select them.
Hope that helps others! I know this is going to be a great addition to my workflow - it gives instant access to form submissions to people vs. waiting for the final spreadsheet when a form closes.
Note - Initial testing showed that I could manually add a record (row) in the Google Spreadsheet and then the next new from submission was simply placed in the last available row.
he4gaveme, can you provide some direction on how you did that? I'm tired of copy and pasting in google every day ;)
oh i figured it out... that is pretty darn handy, wish I knew this a long time ago!
You must log in to post.