Skip to main content
Participant
October 15, 2019
Question

Submit Form Data to an Excel or Google Sheet

  • October 15, 2019
  • 1 reply
  • 380 views

Hello,

 

I am working with an educational non-profit that has a print worksheet they'd like to turn into a interactive digital experience. Most basic form software doesn't cut it, as the input fields need to be in circles (here's a rough sketch: https://snipboard.io/xDaqlY.jpg notice the inputs are circles and there are multiple columns, rather than having one plain text input field directly below the other like Typeform or Formstack). Additionally, the client would like that when users submit their data, a Tag Cloud  (like this: https://www.nngroup.com/articles/tag-cloud-examples/) can be generated based on the responses. It's so participants can quickly see what the most common values entered are in a "fun" way. 

 

Anyone have experience building something like this using Acrobat, CC software or another product? The closest solution I've come to is creating the form in Adobe Acrobat, but I'm unclear if adding a submit button will cleanly put the data into a spreadsheet format (and furthermore, how easy would it be to subgroup? I.e., if we only wanted to use data from responses on a certain day, how easy would it be to filter that data? Or would it be best to duplicate the form and create a new spreadsheet for each use case.)

 

Again, it's a small educational group. They will not have any sort of live tech person on site at the workshops where the form is utilized. Trying to figure out the best way to deliver something they can use without much opportunity for technical errors. They are open to investing into a new piece of software, but it can't break the bank.

    This topic has been closed for replies.

    1 reply

    Legend
    October 15, 2019

    Submit buttons don't do that. Submit buttons send the file to a web script, in exactly the same way a web page form does. A professional web programmer makes the back end which reads what is submitted and does what it needs to do with the data. (Don't skimp on this or attempt to do it yourself: web scripts are the main attack point for hackers, and if your work isn't to the highest and latest standards, your web server will be hijacked to send spam, host illegal photos, or worse.)