Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

51sunshine
Community profile 51sunshine Level 1
Job title here
Location here
4 BADGES
Level 1

Level 1

Learn more
Joined the community 08-11-2012 11:23:46 AM
Offline
Top badges earned by 51sunshine
Customize the badges you want to showcase on your profile
Re: script for calculated-read only field that will change color based on condition
Avatar
Give Back 3
Level 1
51sunshine
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
51sunshine
- Adobe LiveCycle
Thanks once again!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!You are correct (for anyone who did not understand my question) - it is a drop down-list where 3 of the 8 options have the same condition to follow.The second suggestion of spelling out the entire condition worked like a charm.

Views

79

Likes

0

Replies

0
Re: script for calculated-read only field that will change color based on condition
Avatar
Give Back 3
Level 1
51sunshine
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
51sunshine
- Adobe LiveCycle
I'm having the same issue now that my script includes more than one option from the drop-down list. Using the example above, I now have included the option of year 4,6, or 8:form1.#subform[0].#subform[1].#subform[2].YEAR4.TextField17::calculate - (FormCalc, client)if (form1.#subform[0].#subform[1].#subform[2].Row[0].YearLevel == "4" or "6" or "8" & ((B1P+BP)>".45" or (B1P+BP)<".30") & CourseNum>="20")then$.fillColor = "225,225,0";else$.fillColor = "255,255,255";endifHope you can help.

Views

79

Likes

0

Replies

0
Re: script for calculated-read only field that will change color based on condition
Avatar
Give Back 3
Level 1
51sunshine
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
51sunshine
- Adobe LiveCycle
Thank you for taking the time to answer!!!!!

Views

79

Likes

0

Replies

0
Re: script for calculated-read only field that will change color based on condition
Avatar
Give Back 3
Level 1
51sunshine
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
51sunshine
- Adobe LiveCycle
update - I've provided a screen shot below. I'm a newbie, so my terminology may not be correct as I describe my question.When the user enters data in the "number of students" row - the "percent of class total" is auto-calculated. Depending on the year level, class size, and percent of class the percent range the fields in the chart belwo change colour (see screen shot). My problem is that more than one field changes colour once the data is enetered although the script specifics the year level. I...

Views

81

Likes

0

Replies

0
script for calculated-read only field that will change color based on condition
Avatar
Give Back 3
Level 1
51sunshine
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
51sunshine
- Adobe LiveCycle
I need help creating a script that would make a calculated-read only field change color if a condition is met. Should the script placed in the calculated event? The fields are as follows: CourseNum (auto sum calculates 11 numeric different fields)A1P (numeric calculated read only field)AP (numeric calculated read only field)HIGHA (the sum of A1P and AP) - this is also a calculated read-only fieldSo the condition would be: if CourseNum >20 and HIGHA >=50%then change the background color of HIGHA ...

Views

1.8K

Likes

0

Replies

8