I have a data table with addresses where I need to look for and abbreviate certain words, in various countries.
I have created an IF statement that works, but only for 1 country;
However, I have tried various ways of adding further IF statements to this for the other countries, but they seem to cancel each other out.
So basically I have 5 country codes (AT, BE, GB, NL, DE) each with it's own set of words that I would like to highlight when that particular country code is selected from the 'CountryFilter' field.
Is it possible to insert multiple if statements here, or is there a better way of going about this?
Any suggestions would be much appreciated.
I'd add an extra field in the script when loading the data and store the color value in that field. You could then use that new field to set the background color in the front end table.