I trying to build a invoice template, how do I stack "if 0" actions? Or can you even do that?
I’m building an invoice template.
I have an “Hr” column and a “Cost” column.
The actions I want the “Cost” Column to perform are as followed:
(Hr = number of hours work, 18 = Hourly rates)
- “Hr” * 18 =?
- If the return is “0” OR no calculation, show blank.
- If “0” “0” OR no calculation, allow for manual entry of cost.
- Allow entry, show, and calculate (+ and -) of positive and negative numbers.
- Show negative numbers in “Red” and show format with -. (-$100) for prints.
Current Scripting for Hr1-14:
Calculate>Simplified Filed Notation.
Hr*18
Validate>Run Custom Validation script.
if (event.value<0){event.target.textColor=color.red}
else{event.target.textColor=color.black}
if (event.value ==0) event.value ='';
else event.value = defalt;
(Note: Above Script was found on Adobe Forums)
At the end of the “cost” column, they are added or subtracted to show a “Grant Total.”
- The “Grand Total” adds up but does not subtract changes, update, or is wrong.
- I need “Grand Total” to Add and Subtract with changes and Subtract discounts.
Current Scripting for Hr1-14:
Calculate>Value is the>Sum (+).
Cost1, Cost2, Cost3, Cost4, Cost5, Cost6, Cost7, Cost8, Cost9, Cost10, Cost11, Cost12, Cost13, Cost14,
I try to make it as easy as possible to understand what I am working on and what the aim is, however, if this is still unclear I can email you the file as you see what is going on.
AdChoices