Solved

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

Posted on 2008-10-20
3
375 Views
Last Modified: 2013-12-18
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
Comment
Question by:fordraiders
  • 2
3 Comments
 
LVL 5

Expert Comment

by:daj_uk
ID: 22761220
It will return the value in the 17th column of the view "Lookup", based on the value set in the field CRSNumber
0
 
LVL 5

Accepted Solution

by:
daj_uk earned 500 total points
ID: 22761273
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
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 31507959
Thank you so much   .....makes perfect sense now...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now