I've just spent the last two days putting together a complex form and it is almost perfect. I have three outstanding issues:
1) Skip fields - I want to set it up so that if the user clicks the "No_6" checkbox the tabbing function jumps multiple fields to the "Total Annual Gross CommissionsRow5" field. How do I do this?
2) Equation? - I have the user input a name into the "ProducerName1" field. Later in the form what was input into the "ProducerName1" field needs to appear in another field so that the user doesn't have to reinput it. I know that I can name the second field the same as the first but that doesn't allow me to have different properties. The user needs to be able to input the name into the "ProducerName1" field but the second field needs to be read only.
3) Tools > Advanced Editing > Touch Up tools - I used this to delete some text. Unfortunately that text had some word underlined and the underlines will not go away. I tried creating Text Boxes over them which made the lines disappear but then those text boxes became tab stops. How do I get rid of the underlines or how do a stop text boxes from becoming tab stops?
Your help is greatly appreciated.
Newbie Needs Help
2011-01-21 06:44:54
Answered
My Product Information:
Acrobat Standard 9.4, Windows
Acrobat Standard 9.4, Windows
2011-01-21 12:25:48
#2
Hi George:
Thanks for the quick response. Your answers worked perfectly! I have one more issue / question:
I am on Acrobat Standard X.
I do File > Save As > Reader Extended Version > Enable Form Fill In
I send the form to my client, who fills it out, saves it, and emails it back to me.
I open the file and can see all the answers.
I do File > Save As > Spreadsheet > Excel WorkbookThe program saves the entire form and I can see it in Excel but the data the client entered is not there. What do I need to do to get the data to come over to excel as well?
Thanks Again,
Jon
Thanks for the quick response. Your answers worked perfectly! I have one more issue / question:
I am on Acrobat Standard X.
I do File > Save As > Reader Extended Version > Enable Form Fill In
I send the form to my client, who fills it out, saves it, and emails it back to me.
I open the file and can see all the answers.
I do File > Save As > Spreadsheet > Excel WorkbookThe program saves the entire form and I can see it in Excel but the data the client entered is not there. What do I need to do to get the data to come over to excel as well?
Thanks Again,
Jon
2011-01-21 12:34:23
#3
What is your goal in saving the document as a spreadsheet? Are you trying to work with the form data, or something else?
2011-01-21 12:49:03
#4
You should be using Manage Form data to gather the response files into an Excel file. Managing Form Data featuring Tim Plumer.If you manage your responses into a CSV (Coma Separated Value) file, you can import that file into Excel or Access. If Excel, you can sort the file, auto filter, subtotal, name a data range and perform vLookups or hLookups. Importing the data into Access will create a table and then you can print a report from the table, create quires to select data and export that data, or create a report.
When I starte to learn programming, companies had Data Procesing Deprtments. They now call them Information Systems, but data is still gathered, sorted, summarized, and reported.
When I starte to learn programming, companies had Data Procesing Deprtments. They now call them Information Systems, but data is still gathered, sorted, summarized, and reported.
2011-01-21 13:02:21
#5
Thanks George K. That link showed me what to do. BTW, Is everyone on here named George?
2011-01-21 13:05:33
#6
No, we occasionally let Thom post.
// Set the focus to this text field if selected
if (event.target.value !== "Off") {
getField("Total Annual Gross ComissionsRow5").setFocus();
}
2. You can either set the value of the second field in the first field's Validate event or in the second field's Calculate event.
// Validate script for ProducerName1 field: set the other field's value
getField("ProducerName2").value = event.value;
// Calculate script for ProducerName2 field: set field value to same as other
event.value = getField("ProducerName1").valueAsString;
3. You should not edit the underlying PDF in Acrobat. Instead, edit the source document, create a new PDF, and with your form opened in Acrobat select "Document > Replace Pages" to replace the old pages with the new. All of your form fields, code, links, bookmarks, etc. will be retained.