Selasa, 23 Oktober 2012

[ExcelVBA] Using google form data in web form response

 

This is another of my challenges.

I want to neatly integrate google docs form data with web form
responses. From what I have seen, google docs allows only RSS, which
makes a ugly looking web form, does not allow data processing and
calculations, and returning selected data fields only. Other than that,
Google docs will show the actual spreadsheet itself.

All I want to do is use web user-entered data (written to a spreadsheet
using Google form) to calculate an authentication code (a simple excel
function) and neatly return the entered data plus authentication code
via web and e-mail.

Integration with Dropbox or Jotforms or some other web service would be
all right as well.

Does anyone have an idea of how to do it? Any suggestions? I obviously
lack SQL knowledge to do and run that independently of third-party web
services.

Laerte J Silva

--

----------------------------------------------------------
tradutormg@gmail.com - ljstrans@gmail.com
laertejs@ljstraducoes.com http://juramentado.ljstraducoes.com (31)
3498-6020 - 9992-8118

----------------------------------------------------------

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar