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
Lotus IBM

Avatar of undefined
Last Comment
yim11
ASKER CERTIFIED SOLUTION
Avatar of qwaletee
qwaletee

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of HemanthaKumar
HemanthaKumar

The formula to use here

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

~Hemanth
Avatar of yim11
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
Lotus IBM
Lotus IBM

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.

21K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo