I am still rather new to coding in Views. I usually do the basics except for when setting up the select. However, I would like to know if it’s possible (if yes, then how?) to display a column based on the value of another column. For example, If my document status field = “xyz” I want to display the value of fld ‘A’ in the column else if my document status = “abc” I want to display the value of fld ‘Z’ in the column. Thanks in advance for any responses!!!
Subject: Views - displaying fld based on the value of another fld
Use @If, perhaps like this:
@If(Status = “xyz”; A; Z)
Which means: if the value of the field Status is “xyz”, show the value of field A. Otherwise, show the value of field Z. Look up @If in the help for more detail.
Subject: RE: Views - displaying fld based on the value of another fld
thanks for your response but as I said I am fairly new…where would this code go in the view…thanks
Subject: M’ s formula goes in the column formula in the
programmer’s pane. Choose formula and then type it in. Make sure to check the little checkbox to check for errors. hth CAthy
Subject: thanks - M’ s formula goes in the column formula in the
A big thanks from both of you for your help. It worked great!!! thanks again