Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

Explorer ,
Aug 10, 2016 Aug 10, 2016

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?

TOPICS
Acrobat SDK and JavaScript
764
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 10, 2016 Aug 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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Aug 10, 2016 Aug 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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 10, 2016 Aug 10, 2016
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines