• Anonymous
  • Login
  • Register



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 Owners

Owners have rejected the request.



Documents
In this field you can enter the actual request.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.
In this field owners can describe what they have done or want to do.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.