lundi 9 février 2015

Working with If Then Loop of Production Mapping Expression Builder and VBscript?


I'm using production mapping and I want to automate the colour of the text inside a table based on the status field. unfortunately I'm not overly familiar with VB. When I enter:



"<CLR red = '255' green = '0' blue= '0'>" &[NAME]& "</CLR>"


it turns my text red which is what it's supposed to do. But I want to use a if then loop to change certain status' to specific colours. below is what I have so far:



if [STATUS] = Available then
"<CLR red = '255' green = '0' blue= '0'>" &[NAME]& "</CLR>"
elseif [STATUS] = Vacation then
"<CLR red = '0' green = '255' blue= '0'>" &[NAME]& "</CLR>"
else
"<CLR red = '0' green = '0' blue= '0'>" &[NAME]& "</CLR>"
end if




Aucun commentaire:

Enregistrer un commentaire