Contract Labor Rates

Question

Good afternoon,

I need some help writing a script for a negotiation form. I have multiple contracts (CI-2485A, CI-2485B, CI-2485C, etc.) each company has the same professions but different rates.

If I put CI-2485A in the Contract ID field, I want that company's rates to populate the rates for each profession.

Do I have to use this script under each profession or is there a quicker way?

var a = this.getField("Contract ID")

if (event.value == "CI-2485A") {

value = "Amount 1";

} else if (event.value == " CI-2485B") {

value = "Amount 2";

} else if (event.value == " CI-2485C") {

value = "Amount 3";

} else {

// do nothing

}

Thank you,

Badhawg66

PDF Automation Station · Accepted Answer

One method you can use is a dropdown for the Contract ID, with the corresponding rates as the export values. Use a separator in the export values (example: 27.50--13.75--19.73--35.45--33.89). Then split the export values by the separator like this:

event.value=this.getField("Contract ID").value.split("--")[0]; //for 27.50

event.value=this.getField("Contract ID").value.split("--")[1]; //for 13.75, etc.

I have a (paid for) tool to populate a dropdown by copying and pasting an Excel column into a window to make it easier, but it is not necessary. This video shows how to do it.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded