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

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

Avatar

Not applicable

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

0 Replies

Avatar

Level 7

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

Avatar

Not applicable

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

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.

Avatar

Not applicable

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

Level 7

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

Avatar

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

Avatar

Not applicable

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

Not applicable

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

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

Avatar

Not applicable

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

E

Avatar

Level 1

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

Avatar

Not applicable

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