Any limits to number of fields I can collect on a form?

Try using page templates. Go to the tutorials section on this site and search by keyword - template.

Here's an example:


Spawning pages from templates provides you with the option to adding content on-the-fly by adding new pages to a PDF document. Here's how:

Step 1: Add a page to a document that you want to use for a template and navigate to that page.

Step 2: Click the Edit Layout tool in the Forms toolbar.

Step 3: Choose Forms | Page Templates.

Step 4: Type a name in the Page Templates dialog and click Add. To hide the template from view, click the Eye icon.

Step 5: Add a JavaScript to a button field and enter the following code in the JavaScript Editor.

var a = this.getTemplate(“myTemplate”);
a.spawn ({
nPage:this.numPages,
bRename:true,
bOverlay:false
})

Be certain that you use the name you assigned to the template in Line 1. When you click the button, a new page is spawned from the template. By default the bOverlay switch is off meaning new pages are appended to the document. If you want to overlay the new page on an existing page (like adding a watermark), set the toggle to true as shown below:

bRename:true,

Do the page templates allow for more fields than simply continuing the form onto the next pages? I'm interested because I might have 1000 or more fields per submitted form.

Also is there a limit to the number of fields I can include in a form that has several pages? Or am I simply limited to the number of fields that my Excel or Access sheet can contain once I export the data?

Thanks