yim11
asked on
2 fields from different forms in 1 view?
Hello,
I have 2 different forms (lets call em formA and formB), formA has a field name 'tech' formB has a field named 'thetech'. I need to display those fields in a view, along the lines of:
if form=formA then display field 'tech' else if form=formB display field 'thetech'
Can this be done (using Notes r5) and if so how?
Thanks in advance!
-jim
I have 2 different forms (lets call em formA and formB), formA has a field name 'tech' formB has a field named 'thetech'. I need to display those fields in a view, along the lines of:
if form=formA then display field 'tech' else if form=formB display field 'thetech'
Can this be done (using Notes r5) and if so how?
Thanks in advance!
-jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it with qwaletee answer. Thanks for the fast response!
I'm working on a similar situation with a date field that your answer may work for HemanthaKumar, so I may post another question this afternoon.
Thanks again!
-jim
I'm working on a similar situation with a date field that your answer may work for HemanthaKumar, so I may post another question this afternoon.
Thanks again!
-jim
@IF(form = "FormA"; Tech; form = "FormB"; thetech; "Unknown")
~Hemanth