Copying specific Form fields from one page to another based on specific date field

Does date matter, or you just want to copy field values to new fields when you select date?

Name the fields on both pages identically.

Hi @DarthShayder,

Hope you are doing well. Thanks for writing in!

What you're trying to do is definitely possible, but it does require a bit of JavaScript to make it dynamic, since forms don’t natively support “auto-populating tables based on a date selection” out of the box.

Here's something you can try:

Ensure your fields are named in a way that makes scripting easy. For example:

• Page 1:

  • sales_0105 (for Jan 5 Sales)

  • tips_0105 (for Jan 5 Tips)

• Page 2:

  • date_select

  • sales_output

  • tips_output

You can add a custom script to trigger when the date_select field is modified.

Here’s a sample script:

var dateStr = this.getField("date_select").value;

// Convert date to MMDD format
var dateObj = util.scand("mm/dd/yyyy", dateStr);
if (dateObj !== null) {
    var month = (dateObj.getMonth() + 1).toString().padStart(2, "0");
    var day = dateObj.getDate().toString().padStart(2, "0");
    var key = month + day;

    // Get values from Page 1
    var salesValue = this.getField("sales_" + key).value;
    var tipsValue = this.getField("tips_" + key).value;

    // Populate fields on Page 2
    this.getField("sales_output").value = salesValue;
    this.getField("tips_output").value = tipsValue;
}

Here's how to add the script:

• Open your form in Acrobat.

• Select the date_select field.

• Go to Properties (right-click → Properties or use the Prepare Form tool).

• Go to the "Actions" tab.

• Choose:

  • Trigger: On Blur (or On Focus Lost)

  • Action: Run a JavaScript

• Click Add... and paste the script above.

• Click OK and save your form.