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

Conditional formatting (colour) lost when form is saved and reopened?

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

23-03-2015

Hi All

This one has got me confused! I have set drop downs to change color depending on the selection using the following code:

if ($.boundItem(xfa.event.newText) == "1") {

  this.resolveNode("$").ui.oneOfChild.border.fill.color.value = "153, 204, 0";

}

if ($.boundItem(xfa.event.newText) == "2") {

  this.resolveNode("$").ui.oneOfChild.border.fill.color.value = "255, 153, 0";

etc

I have this in the 'Change' event and the 'Layout Ready' event, I have also tried it in the 'Initialize' event but with no success. The issue is this: the colour changes fine as the user fills in the form however is lost when they save and reopen (the selection values are fine just the color coding is lost)

BTW I am saving the PDF with 'Extended Features' as I thought maybe this could be a 'licence' related issue with Adobe Reader

Does any one have any idea of where to look to solve my problem please?

Many thanks

Ellis

Accepted Solutions (0)

Answers (13)

Answers (13)

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

30-03-2015

Hi - yes Iv'e tried in in several events inc 'Initialize' anbd 'Layout Ready', 'Doc Ready' - just cant seem to get it to work.

Here is the troublesome portion of the form, if you add some impact ratings the color will change, then save and close the form, reopen and the color formatting is lost

Dropbox - BIA Impacts for forum.pdf

Any help appreciated

Thanks

E

Avatar

Avatar
Level 1
vivek_yadav
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
vivek_yadav
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
vivek_yadav
Level 1

27-03-2015

Which event have you used to put this script? is it something that triggers while form renders i.e. init, validate etc.

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

27-03-2015

Hi - many thanks I've sent you the part of the form that is displaying this issue - any help appreciated

E

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

26-03-2015

Not sure. Can you send me the form? I tried this but had to use a local database connection to simulate the issue. I got it to work fine for me. mousland@gmail.com

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

26-03-2015

Thanks for your response

Unfortunately this was already checked on my form, I tried unchecking it but no joy - I'm stumped - any further advice?

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

25-03-2015

Here is the same settings in ES2

form properties.JPG

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

25-03-2015

Thanks again - I'm not seeing this option? Perhaps its a version thing as I'm stuck on ES2? I can't see it's equivilant in ES2 either

E

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

25-03-2015

I was finally able to get it to work. Try this:Go to Form Properties, Run-time Check the box that says Allow Automatic... That worked for me in my test.

Runtime options.JPG

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

25-03-2015

Are you populating the drop down manually or from your XML? Did you use a data drop down?

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

24-03-2015

Yes it's a regular drop down for the user to pick the severity of an issue, this is then bound to a value that is passed to the XML

Eg User selects 'Major" the box turns red and the bound value '3'  is passed to xml.

Is that what you mean? Can that cause problems?

Thx

E

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

24-03-2015

Are you using a regular drop down list or a data drop down list that is bound to the XML? I am guessing it is a data drop down list.

Avatar

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ellis355
Level 1

Likes

2 likes

Total Posts

62 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
ellis355
Level 1

24-03-2015

Hi Thanks for the response, I don't have any data connection set up for this form it is purely stand alone, user enters data and I use the xml to inject into Excel.

Any ideas?

Thx

Ellis

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

23-03-2015

I believe the reason is that the data connection is resetting the form. I have seen this happen in other forms.