We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

2 fields from different forms in 1 view?

yim11
yim11 asked
on
Medium Priority
259 Views
Last Modified: 2013-12-18
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
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
The formula to use here

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

~Hemanth

Author

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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.