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?

ellis355
Level 3
Level 3

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

13 Replies
mouslander
Level 7
Level 7

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

ellis355
Level 3
Level 3

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

mouslander
Level 7
Level 7

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.

ellis355
Level 3
Level 3

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

mouslander
Level 7
Level 7

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

mouslander
Level 7
Level 7

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

ellis355
Level 3
Level 3

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

ellis355
Level 3
Level 3

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?

mouslander
Level 7
Level 7

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

ellis355
Level 3
Level 3

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

E

vivek_yadav
Level 1
Level 1

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

ellis355
Level 3
Level 3

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