By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Actually, the people view is probably not your best choice. The names in the people view appear in the format: 'lastname, firstname'. My name would appear only as 'Mahoney, Brian' . I would use the view "($NamesFieldLookup)". this view lists people by variations of their name. I appear under three entries: "brian mahoney"; "brian mahoney/domain"; and "bmahoney". This view is more likely to find the name as it is entered in the field.
Additionally, I would wait to do the lookup until the document is being saved, so that you know the name field has been populated. A possible formula for the form's phonefield might be: @IF( @IsDocBeingSaved; @DbLookup ("" : "NoCache" ; "" : "names.nsf" ; "($NamesFieldLookup)" ; formsnamefield ; NABphonefield ); formphonefield )
Dig Deeper on Domino Resources - Part 7
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response.continue reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead.continue reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.