Skip to main content
August 5, 2019
Answered

Sum up values

  • August 5, 2019
  • 1 reply
  • 1444 views

Hi, how can I sum up the following values?

[A-H]&[J-U]&[W-Z]

[a-z]

[I,II, III, IV, V, VI, VII]

if (event.value=="A") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value=="B") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value=="C") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value=="D") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value=="a") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value=="b") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value=="c") { event.target.textColor = color.red;

        this.getField("Field1").textColor = color.red;

        this.getField("Field2").textColor = color.red;

        this.getField("Field3").textColor = color.red; }

else if (event.value>=0) { event.target.textColor = color.black;

          this.getField("Field1").textColor = color.black; 

        this.getField("Field2").textColor = color.black;

        this.getField("Field3").textColor = color.black; }

else if (event.value=="I") { event.target.textColor = color.green;

    this.getField("Field1").textColor = color.green;

    this.getField("Field2").textColor = color.green;

    this.getField("Field3").textColor = color.green; }

else if (event.value=="II") { event.target.textColor = color.green;

    this.getField("Field1").textColor = color.green;

    this.getField("Field2").textColor = color.green;

    this.getField("Field3").textColor = color.green; }

else if (event.value=="III") { event.target.textColor = color.green;

    this.getField("Field1").textColor = color.green;

    this.getField("Field2").textColor = color.green;

    this.getField("Field3").textColor = color.green; }

else if (event.value=="IV") { event.target.textColor = color.green;

    this.getField("Field1").textColor = color.green;

    this.getField("Field2").textColor = color.green;

    this.getField("Field3").textColor = color.green; }

else if (event.value=="V") { event.target.textColor = color.green;

    this.getField("Field1").textColor = color.green;

    this.getField("Field2").textColor = color.green;

    this.getField("Field3").textColor = color.green; }

else event.target.textColor = color.blue;

as well I would like to sum up the "get.Field" method. I tried this:

this.getField(["Field1","Field2","Field2"]).textColor = color.red;

but it didn't work

can you please help me?

This topic has been closed for replies.
Correct answer try67

the options are lower and upper case letters, roman numerals I-VII and numbers


OK, then I would do it like this:

var newTextColor = color.black;

var romanNumerals = ["I", "II", "III", "IV", "V", "VI", "VII"];

if (romanNumerals.indexOf(event.value)!=-1) {

    newTextColor = color.green;

} else if (/^\d+$/.test(event.value)) {

    newTextColor = color.blue;

} else if (/^[a-z]+$/i.test(event.value)) {

    newTextColor = color.red;

}

var fields = ["Field1", "Field2", "Field3"];

for (var i in fields) this.getField(fields).textColor = newTextColor;

1 reply

try67
Community Expert
Community Expert
August 5, 2019

Are these the only options?

August 5, 2019

what do you mean with the only options?

edit:

there's a table with 30 rows and 3 columns. actually there are more options. field 1-3 only represents one row in this table

the color of one row should depend on the value that ist entered in the target field

try67
Community Expert
Community Expert
August 5, 2019

I mean if the only options are the lower and upper case letters and I-VI in Roman numerals.