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
BedrockMission!

Learn More

View all

Sign in to view all badges

Change the Fill Color Based on Expiration Date

Avatar

Avatar
Validate 1
Level 1
Michalleddy92
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
Michalleddy92
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
Michalleddy92
Level 1

08-01-2019

I am trying to make a field change its fill color based on its expiration date. I have tried to figure out a way to do it using the action builder to no avail.

Example:

User enters expiration date in the date field

if the date is greater than 90 days out the fill color stays white

if the date is greater than 60 days out but less than 90 days out it turns green

if the date is greater than 30 days out but less than 60 days out it turns yellow

if the date is less than 30 days out it turns red

I was easily able to make this work in excel using =XX>TODAY() + 60 and a quick format change but livecycle is proving to be much more difficulty. Obviously I could stick with excel but PDF is so much cleaner IMO.

Any help would be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 1
Level 1
camilot95966368
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

2 solutions
Top badges earned
Affirm 1
View profile

Avatar
Affirm 1
Level 1
camilot95966368
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

2 solutions
Top badges earned
Affirm 1
View profile
camilot95966368
Level 1

28-01-2019

Hi Michael,

For this function, you'd have to use the fillColor properties script in JS see: Adobe LiveCycle ES4 * fillColor

I'd be happy to help you further: https://www.fiverr.com/share/yj5Pe

Best,

Camilo

Answers (0)