OpenNTF Mail Template - Feature Request: Phone Lookup
I took the ePhone lookup (from Iris Sandbox) a step further and built it into my mail template.
I have an action button in the inbox that calls the ephone script, prompts the user for a name and displays the number.
A similar button in the memo, reply, reply+h forms looks up the phone number of the sender.
This is great functionality with very positive feedback from users with little effort. Might be worth including in ONTF?
Script below could probably be improved by you experts and LS used instead of formula language.
tempname := @Trim(@Prompt([OKCANCELEDIT]; "ePhone Lookup"; "Enter surname (eg. siberry), firstname (eg. jane), or fullname (eg. jane siberry).";""));
surname := @If(@RightBack(tempname; " ") = ""; tempname;@RightBack(tempname; " "));
templist1 := @DbLookup(""; "80256826:0045F644"; "($Users)"; tempname; 2);
templist2 := @If(@IsError(templist1); @DbLookup(""; "80256826:0045F644"; "($Users)"; @Soundex(surname); 2); templist1);
templist3 := @If(@IsError(templist2); @Do(@Prompt([OK]; "ePhone Error";
"The name " + tempname + " you entered was not found in the address book. Please try again"; ""); @Return(0)); templist2);
templist4 := @DbLookup(""; "80256826:0045F644"; "($Users)"; templist3;
"OfficePhoneNumber");
templist5 := @DbLookup(""; "80256826:0045F644"; "($Users)"; templist3;
"CellPhoneNumber");
templist7:=@DbLookup
(""; "80256826:0045F644"; "($Users)";templist3;"Firstname");
templist8:=@DbLookup
(""; "80256826:0045F644"; "($Users)";templist3;"Lastname");
phnlst1 := templist7 + " " + templist8 + " " + "Tel: " + templist4 + " Mobile: " + templist5;
phonelist := @Unique(phnlst1);
@Prompt([OKCANCELLIST]; "ePhone Lookup"; "List of names and numbers. Thanks for using ePhone !"; ""; phonelist)
Taken Actions by OwnersOwners have rejected the request.Documents