Skip to main content
RobRusher
RobRusher
Participating Frequently
August 10, 2016
Question

Can I get the data from submitted forms to populate a Google Spreadsheet?

  • August 10, 2016
  • 1 reply
  • 744 views

I'm trying to create a form for a friend, but I don't want the data to come back to my email address or for me to have to export form data from my Acrobat account.  Is there a way to get the form data to go straight into a Google Sheet instead?  If not, can someone tell me how to set up a form for someone else so that they can manage the information once it starts coming back in?

This topic has been closed for replies.

1 reply

G
George_Johnson
Inspiring
August 10, 2016

Will the person who'll be receiving the emailed forms have access to Acrobat, or just Reader? Since you won't be receiving the responses, don't use the Distribute Form feature and instead add a button and configure it to submit by email.

RobRusher
RobRusherAuthor
Participating Frequently
August 10, 2016

They will be using Reader.  If it's submitted by email, how will they get the data out of it?  The Export Data option is a little clunky in that they'd have to define what should be exported every time, right?

G
George_Johnson
Inspiring
August 10, 2016

Reader doesn't have a built-in method of exporting data (unless you're able to Reader-enable the document with LiveCycle Reader Extensions $$$$), so you have to get creative. What I've done is use a script to get the field data, put it in a tab-delimited format, and display it in a multiline text field in a custom dialog, which allows the user to simply copy & paste it into a spreadsheet.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices