Don't want zero dollar value

[Elliott_Steinberg@adobeforums.com]

Hi all,

I set up an invoice form to calculate totals from quantity x unit price. Every line has this formula, however the users may not have a priced item on every line of the form. My total column shows a $0.00 value until I input data. I'd rather have nothing show in that column unless quantity and price are entered. Is that possible?

Thanks!

Elliott

[Elliott_Steinberg@adobeforums.com]

Oh, I'm using Acrobat 8.11 on an Intel with OS 10.5.4 (just upgraded yesterday).

[George_Johnson@adobeforums.com]

What you need to do is use a custom Format and Keystroke JavaScript for the calculated field. Add the two following functions to a document JavaScript that you create:

function ds_format() {

if (+event.value) {
// $ format for nonzero values
AFNumber_Format(2, 0, 0, 0, "$", true);
} else {
// Don't show anything if result is zero
event.value = "";
}

}

function ds_keystroke() {

AFNumber_Keystroke(2, 0, 0, 0, "$", true);

}

Then, place the following as the field's custom Format and Keystroke scripts, respectively:

// Custom Format script
ds_format();

// Custom Keystroke script
ds_keystroke();

You can now use this for any other fields you want to do this for. Note that the Keystroke script isn't really necessary since you're dealing with a calculated field, which should be set to read-only, but I included it here for completeness in case you want to do this for a data entry field.

George

[Elliott_Steinberg@adobeforums.com]

many thanks, but the only places I see to put non-canned scripts in "Text Field Properties/Calculate" are 2 boxes called "Simplified Field Notation" and "Custom Calculation Script." Do they all go in the latter one?

Sorry, I'm a newbie at doing forms in Acrobat.

Elliott

[George_Johnson@adobeforums.com]

For the document-level scripts, you access them via a menu item. I'm using version 6 on the machine I'm typing on at the moment, and the menu item is "Advanced > JavaScript > Document JavaScripts".

For the field level scripts, select the Format tab of the Field Properties dialog, and select "Custom" from the drop-down list. You should then see where you can enter a Format and Keystroke script.

Be sure to create the document-level script before setting up the Format/Keystroke scripts.

George

[Elliott_Steinberg@adobeforums.com]

Mine's in "Advanced/Document Processing/Document Javascripts" but that option is greyed out. Any idea what I have to do to activate that?

[Elliott_Steinberg@adobeforums.com]

Never mind. It was because I had already put Usage Rights in place. I'll give your script a try. Thanks!

[Elliott_Steinberg@adobeforums.com]

Works well. Many thanks!

Elliott