Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me out because i have this field that has three values and i want all caption to change colors for each value that they pick in the field but i cant seem to find the right formula because the normal if is only good for 2 colors like
if(GetFieldSelections([Field]) = 'A',RGB(0,0,0),RGB(255,255,255))
how can i make a three color if statement?
Help would much be apreciated. ;)c
As far as my understanding of your problem. You can write in this way
if(ID=1,rgb(55,255,255),
if(ID=2,rgb(255,25,205),
if(ID=3,rgb(2,55,255))))
As far as my understanding of your problem. You can write in this way
if(ID=1,rgb(55,255,255),
if(ID=2,rgb(255,25,205),
if(ID=3,rgb(2,55,255))))
Hi,
do you want to find a substring, so could help that function:
Position of a substring. This function gives the starting position of the n:th occurrence of substring s2 in string s1. If n is omitted, the first occurrence is assumed. If n is negative, the search is made starting from the end of string s1. The result is an integer. The positions in the string are numbered from 1 and up.
index( 'abcdefg', 'cd' ) returns 3
index( 'abcdabcd', 'b', 2 ) returns 6
index( 'abcdabcd', 'b', -2 ) returns 2
left( Date, index( Date,'-') -1 ) where Date = 1997-07-14 returns 1997
mid( Date, index( Date, '-', 2 ) -2, 2 ) where Date = 1997-07-14 returns 07
Hope, that's it!
Thats it..thanks so much!