Hi,
I have a dynamic table where end users will add rows as needed and some of the fields will automatically calculate based on the numbers. What I need is if one of the calculations is below a stated value, I need the row highlighted automatically in yellow. In the example below, say I want the values less than $10.00 highlighted.
Example:
Cost | Sq Ft | Cost/per Square |
---|---|---|
50 | 10 | 5 |
300 | 10 | 30 |
Can anyone help me with this please?
Views
Replies
Total Likes
On the calculate event for the field in question using FormCalc (placed after your current calculation script), try:
if($<10)then
$.fillColor = "255,255,0" //yellow
else
$.fillColor = "255,255.255" //white
endif
You can change the font color also:
if($<10)then
$.fillColor = "255,255,0" //yellow
$fontColor = "255, 0,0" //red
else
$.fillColor = "255,255.255" //white
$.fontColor = "0,0,0" //black
endif
Good luck,
Stephen
I think I am still doing something wrong. I entered in the formula, Form Calc, Calcluation script and changed $ to the names of the Cost field and the field I want highlighted. I get back the numbers 255,255,0. I dont see where to attach my sample (wasnt that an option before?) Here is my script, hiearchy, and a screen shot:
if
(Cost<100)then
PolicyNo.fillColor
= "255,255,0" //yellow
else
PolicyNo.fillColor
= "255,255.255" //white
endif
and my hiearchy is:
Table 1
Header Row
Policy
AddRow
DelRow
PolicyNo
Renewal
AdjDate
SqFt
AOI
Cost
Views
Replies
Total Likes
My example had an error doh!
the
= "255,255.255" //white
S/H/B
= "255,255,255" //white (replace the . with a , )
Also, personally, I would place the script on the Cost field (not the PolicyNo)--after your cost calculation.
Good luck,
Stephen
Views
Replies
Total Likes
Stephen,
Thank you so far for your help. I really do appreciate it.
It is still not working. When I set up the formula in the caluclate field, it will not calculate my AOI/SqFt. You are right. I cannot place it in the PolicyNo field or else the field becomes read only and that is a data entered field. The closest I come to getting anything is getting the numbers "255,255,0" to print as if LiveCycle think it is text. I am saving this as a dynamic, Acrobat 8. Would that make a difference? I did get the field to highlight once, but I lost that code and the code was not reading the if then statement, just the last portion of the statement so no matter what was entered, it highlighted it yellow.
Views
Replies
Total Likes