Link to home
Start Free TrialLog in
Avatar of yim11
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
ASKER CERTIFIED SOLUTION
Avatar of qwaletee
qwaletee

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HemanthaKumar
HemanthaKumar

The formula to use here

@IF(form = "FormA"; Tech; form = "FormB"; thetech; "Unknown")

~Hemanth
Avatar of yim11

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