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
yim11Asked:
Who is Participating?
 
qwaleteeCommented:
Proabbly as simple as @Trim(tech:thetech)

If form A sometimes has a field named thetech or form B sometimes has tech (reverse of what you describe), then instead: @If(form = "formA"; tech; thetech)
0
 
HemanthaKumarCommented:
The formula to use here

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

~Hemanth
0
 
yim11Author Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.