hi… i want to change name format in input translation formula…like if the name is in common name then it shud be change in hierarchical form…i m doing by @name([abbreviate];authorfield)but it is not working…
Subject: changing name format
@Name can’t add information that isn’t there. If the name you are trying to change (from common name to either abbreviated or canonical) is not the current user, you need to do a lookup to the address book.
Subject: RE: changing name format
From the address lookup , name format is already in hierarchical form…but if i m copy pasting any address or common name then it is not changing in desired form…wt shud i do if i am giving common name and want hierarchical form…
Subject: RE: changing name format
Do a lookup (@NameLookup) to the address book.
Subject: RE: changing name format
I m using namelookup but its not returning anything…as i m giving author in author field as its common name…Now using in input translation…@namelookup([NoSearching];Authorfield;“name”)…is it crrect way to do??..
but it is not returing anything…
plz explain me thru example…
as field name is author…
now how to do?
Subject: RE: changing name format
[NoSearching]??? Do you really expect to find the user in your local address book? Try [Exhaustive]. And the field you want to return is Fullname, not name.
Subject: RE: changing name format
Thanks…its wrking now…
one more thing…i want to validate that author…
like i have a field AuthorField…its multivalue field…
i want to validate the authors given in that field…
it may be case that one has access and other not…
i had done this by Queryaccess.in Lotus script …but i want thru field validation…
plz help me in this reagard
Subject: RE: changing name format
Stan can u tell me if one author is not in our addressbook…it is making that blank wen i m using namelookup…so how can i test that if one is in namelookup then only change the name format in full form…plz help me …
Subject: RE: changing name format
For this reason I normally block people from being able to type (or cut and paste) into a names field, instead we give them the help icon and bring up the address book anytime we want someone to enter a name. (Yes there are exceptions to the rules but then you make the owner of the application aware of the risk).
Otherwise, you’ll have the problem with a dozen John Smith’s (and no one puts in the middle initial when typing it in) and the William Jones who everyone calls Bill and types in Bill Jones.
Subject: RE: changing name format
In Input Translation Abbreviate to common thru @name([cn];author) is wrking but wen i m trying to change common name to abbreviate then its not wrking…
Subject: RE: changing name format
As Stan said, you cannot get the system to extrapolate(sp):
Maybe this will help:
You can say a car has wheels. (A part of a car is it’s wheels)
However, you cannot say anything with wheels is a car (because it could be a bike, a truck, a bus, a plane, etc.)
Or in notes terms:
For example: If your company has two Stephen M Christian’s one being in division A and the second in Division B
Stephen M Christian/DIVA/ORG
Stephen M Christian/DIVB/ORG
You CAN go: Stephen M Christian/DIVA/ORG => Stephen M Christian
via @Name([cn];@ThisValue) but this is not a good thing, if you’re using this field for e-mailing or Reader/Author fields.
But you CANNOT go:
@Name([Abbreviated];“Stephen M Christian”)
Because you want the system to add more information. If you’re lucky and there is only one Stephen M Christian then the system will ASSUME that’s who you mean. But since in our example there is two, it doesn’t know if you mean Stephen M Christian/DIVA/ORG or Stephen M Christian/DIVB/CSC
Subject: RE: changing name format
I already said this once: @Name cannot add anything that is not already present. You need to look the name up in the address book to get the hierarchical data for a common name other than the current user.