@Formula

HCL Domino Domino Forum
1

Hi,

I have following 2 links:

  1. http://apps.test.com/cgi-bin/contests/index2.pl?wauid=<<>>

  2. http://test.test.com/cgi-bin/honeybee/requestmassmail.cgi?wauid=<<>>&waemail=<<>>

Once I create the links, I am unable to get the value for the waemail. I am using following formula:

ClassCache := “Notes”:“NoCache”;

Lkp := @DbLookup(“”:“nocache”; “”; “vwLkpLinkNav”; “Left]”; 4);

Links:= @If(@IsError(Lkp); “”; @Implode(@Trim(@Unique(Lkp))));

HTML := Links;

URL := @UrlQueryString;

WIDString := @Trim(@Right(URL;“wauid=”));

WebLinkID := @Trim(@ReplaceSubstring(@Unique(Lkp); “wauid=<<>>”; “wauid=” + UNLkp));

WEmailString := @Trim(@Right(URL;“&waemail=”));

WebLinkEmail := @Trim(@ReplaceSubstring(@Unique(Lkp); “wauid=” + UNLkp + “&waemail=” + IELKP; “wauid=” + UNLkp + “&waemail=” + IELkp));

Web := @If(@Contains(HTML; “wauid=” + WIDString + “&waemail=” + IELkp); WebLinkEmail;WebLinkID);

Web

I have the value for the wauid and waemail for the current user, but the waemail is empty when click on the link.

I don’t know how to read each link and check to see if the string “waemail” exists then use different format.

Any help is appreciated.

Thanks

KS

2

Subject: Was that complete? If so, where are the IELKP and UNLkp vars coming from?

WebLinkEmail := @Trim(@ReplaceSubstring(@Unique(Lkp); “wauid=” + UNLkp + “&waemail=” + IELKP; “wauid=” + UNLkp + “&waemail=” + IELkp));

3

Subject: RE: Was that complete? If so, where are the IELKP and UNLkp vars coming from?

Sorry,

Here is the complete formula:

REM {03/11/04 - Short Name};

UserName := @Left(@Name([Abbreviate]; @UserName );“/”);

key := @ReplaceSubstring(UserName; “%20”; " ");

DatabaseName := NamesDB;

ViewName := “(LkpFName)”;

keyLkp := @DbLookup( “” : “NoCache” ; “” : DatabaseName ; ViewName ; key; “ShortName”);

UNLkp := @If(@IsError(keyLkp);“Not available”;keyLkp);

UNLkp;

REM {03/11/04 - Internet Address};

UserName := @Left(@Name([Abbreviate]; @UserName );“/”);

key := @ReplaceSubstring(UserName; “%20”; " ");

DatabaseName := NamesDB;

ViewName := “(LkpFName)”;

keyLkp := @DbLookup( “” : “NoCache” ; “” : DatabaseName ; ViewName ; key; “InternetAddress”);

IELkp := @If(@IsError(keyLkp);“Not available”;keyLkp);

IELkp;

ClassCache := “Notes”:“NoCache”;

Lkp := @DbLookup(“”:“nocache”; “”; “vwLkpLinkNav”; “Left]”; 4);

Links:= @If(@IsError(Lkp); “”; @Implode(@Trim(@Unique(Lkp))));

HTML := Links;

URL := @UrlQueryString;

WIDString := @Trim(@Right(URL;“wauid=”));

WebLinkID := @Trim(@ReplaceSubstring(@Unique(Lkp); “wauid=<<>>”; “wauid=” + UNLkp));

WEmailString := @Trim(@Right(URL;“&waemail=”));

WebLinkEmail := @Trim(@ReplaceSubstring(@Unique(Lkp); “wauid=” + UNLkp + “&waemail=” + IELKP; “wauid=” + UNLkp + “&waemail=” + IELkp));

Web := @If(@Contains(HTML; “wauid=” + WIDString + “&waemail=” + IELkp); WebLinkEmail;WebLinkID);

Web

I see the value (user’s short name and their email address). But I just don’t know how to write formula to loop each link and assign user name and email. The problem I have is some links will only need the name and others will have both name and email.

Thanks in advance…

KS