• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Transfer Data from one form to another..WHAT DOES NUMBER MEAN in formula

Lotus Notes 4.6/r5
domino r5

What I have:  code below
I'm pressing a button on a form to bring in data from another form...
One of the fields "CrsOnSite" has this in the "Input Translation"   event
@If(CRSNumber = "";"";@DbLookup("";"862570D5:00609C95";"Lookup";CRSNumber; 17))

What does the 17 in the formula above stand for....

Thanks
fordraiders



FIELD CompanyName := CompanyName;
FIELD Address := Address;
FIELD City := City;
FIELD State := State;
FIELD Zip := Zip;
 
FIELD TransNumber := TransNumber;
FIELD ProjectNumber := ProjectNumber;
FIELD WorkRequestType := WorkRequestType;                      
FIELD WorkRequestType := INVWorkRequestType;                   
FIELD ProjectSize := ProjectSize;
FIELD OffSiteDataFormat := OffSiteDataFormat;
FIELD ProjectCategory := ProjectCategory;
FIELD AcctLevPriceYN := AcctLevPriceYN;
 
FIELD ContactName := ContactName;
FIELD ContactTitle := ContactTitle;
FIELD ContactPhone := ContactPhone;
 
FIELD WWGContactName := WWGContactName;
FIELD WWGContactTitle := WWGContactTitle ;
FIELD WWGContactPhone := WWGContactPhone ;
FIELD RequestorVM := RequestorVM;
FIELD RequestorCell := RequestorCell;
FIELD RequestorEmail := RequestorEmail;
 
FIELD AccountManager := AccountManager;
FIELD AMOfficePhone := AMOfficePhone;
FIELD AMMobilePhone := AMMobilePhone;
FIELD AMVoiceMail := AMVoiceMail;
 
FIELD DSM := DSM;
FIELD RSVP := RSVP;
FIELD LifecycleMgr := LifecycleMgr;
 
FIELD NAParentCode := NAParentCode;
FIELD WWGAcctNumber := WWGAcctNumber;
 
FIELD DT_SubmitDate := DT_SubmitDate;
FIELD DT_DueDate := DT_DueDate;
FIELD EstimatedSKUs := EstimatedSKUs;
 
FIELD GapYesNo := GapYesNo;
FIELD GAP := GAP;
FIELD ListContains := ListContains;
FIELD CustomerAccepts := CustomerAccepts;
FIELD InstallGrainger := InstallGrainger;
FIELD InstallOther := InstallOther;
FIELD CF1 := CF1;
FIELD CF2 := CF2;
FIELD CF3 := CF3;
FIELD OppPipeline := OppPipeline;
FIELD CustAction := CustAction;
FIELD DSMApproval := DSMApproval;
FIELD Comments := Comments;
FIELD Region := Region;
 
FIELD CRSDataTransferConfirm := CRSDataTransferConfirm;
FIELD CRSTempConfirm := ("Request data transferred and loaded on " + @Text(@Now));
 
@SetField("CompanyName";CRSCustName);
@SetField("Address";CRSAddress);
@SetField("City";CRSCity);
@SetField("State";CRSState);
@SetField("Zip";CRSZip);
 
@SetField("TransNumber"; CRSTransNumber);
@SetField("ProjectNumber"; CRSTrackingNumber);
@SetField("WorkRequestType"; CRSOnSite);
@SetField("ProjectSize"; CRSProjectSize);
@SetField("OffSiteDataFormat"; CRSFileFormat);
@SetField("ProjectCategory";CRSCustAlign);
@SetField("AcctLevPriceYN"; CRSPricing);
 
@SetField("ContactName"; "NA");
@SetField("ContactTitle"; "NA");
@SetField("ContactPhone"; "NA");
 
@SetField("WWGContactName";CRSReqName);
@SetField("WWGContactTitle";CRSReqPosition);
@SetField("WWGContactPhone";CRSReqPhone);
@SetField("RequestorVM";CRSReqVM);
@SetField("RequestorCell";CRSReqCell);
@SetField("RequestorEmail";CRSReqEmail);
 
@SetField("AccountManager";CRSSellerName);
@SetField("AMOfficePhone";CRSAMOfficePhone);
@SetField("AMMobilePhone";CRSAMCellPhone);
@SetField("AMVoiceMail";CRSAMVoiceMail);
 
@SetField("DSM";CRSDSM);
@SetField("RSVP";CRSRSVP);
@SetField("LifecycleMgr";CRSCLM);
 
@SetField("NAParentCode";CRSNAParentCode);
@SetField("WWGAcctNumber";CRSAcctNum);
 
@SetField("DT_SubmitDate";CRSSubmitDate);
@SetField("DT_DueDate";CRSDueDate);
@SetField("EstimatedSKUs";CRSNumberItems);
 
@SetField("GapYesNo"; CRSGapYesNo);
@SetField("GAP"; CRSGAP);
@SetField("ListContains"; CRSListContains);
@SetField("CustomerAccepts"; CRSCustomerAccepts);
@SetField("InstallGrainger"; CRSInstallGrainger);
@SetField("InstallOther"; CRSInstallOther);
@SetField("CF1"; CRSCF1);
@SetField("CF2" ; CRSCF2);
@SetField("CF3"; CRSCF3);
@SetField("OppPipeline"; CRSOppPipeline);
@SetField("CustAction"; CRSCustAction);
@SetField("DSMApproval"; CRSDSMApproval);
@SetField("Comments"; CRSComments);
@SetField("Region"; CRSRegion);
 
@Command([ViewRefreshFields]);
@SetField("CRSNumber";"");
@SetField("CRSDataTransferConfirm";CRSTempConfirm);
@Command([ViewRefreshFields])

Open in new window

0
Fordraiders
Asked:
Fordraiders
  • 2
1 Solution
 
daj_ukCommented:
It will return the value in the 17th column of the view "Lookup", based on the value set in the field CRSNumber
0
 
daj_ukCommented:
Just to expand on that a little....

It will take the value of the CRSNumber field and locate a document in the view "Lookup" on the database with a DB ID of 862570D5:00609C95.  It will return the value of the 17th column of the view at the position it fond the document

The view "lookup" will be sorted on a column, which is what it uses to search the view for the CRSNumber
0
 
FordraidersAuthor Commented:
Thank you so much   .....makes perfect sense now...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now