Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

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
0
yim11
Asked:
yim11
1 Solution
 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now