Hello, I have basic experience with InDesign and would like to do something a bit daunting (don't know if it's even possible).
I'm coordinating an awards competition where people will fill out a form and I'd like that data to populate an Excel spreadsheet. I also make these forms publicly available so I would need a way to 'lock' the form from being edited.
I want to layout my form in InDesign and give it a few data fields (e.g. Name, contact information, etc...) and radio buttons (e.g. which awards category would you like to compete in). There are some data fields (e.g. provide background information on your submission) that I do not need populating my Excel spreadsheet.
The Excel spreadsheet will simply be used for administrative purposes (e.g. keep track of how many people are competing in a specific category).
Is this possible? Any online tutorials that people can direct me to? Thanks!
Yoou can design the form in ID, then export to PDF and use Acrobat to convert to a form and "publish." You have several options on how you get the data back from the published form, and one is designed to allow you to populate a spreadsheet, I believe, but that's really an Acrobat topic. How large scale will the distribution be? A standard Acrobat license permits only 500 returns.
Ah thanks for the info Peter. I will ask this in the Acrobat forum then.
In terms of the return rate we will be way below 500.
I don't know if it would meet your requirements but another option would be to use Google Docs to create and share an online form which will automatically populate a spreadsheet.