Submit a Code Fragment... Submit a Code Fragment...
Previous Next Expand Collapse Search
CategoryLink to viewNameLink to viewDescriptionSourceLink to viewDateLink to view
5
Show details for ActiveX/OCX/OLEActiveX/OCX/OLE
4
Show details for C/C++C/C++
240
Hide details for FormulaFormula
Date/Time HandlingDay of the YearComputes the day number of the yearRlatulippe@romac.com02/13/1999
Date/Time HandlingConverting seconds to d:h:m:srobert.j.wragg@britishairways.com02/28/2000
Date/Time HandlingAdjust a Date Into the FutureAdjusts a date field ahead by one year. This type of formula is ideal when you want to compute a date into the future based on a date entered into a particular field. For example, the formula listed below is used to set a warranty expiration date (WarrantyExpires) one year from the date of purchase (DatePurchased).Rlatulippe@romac.com04/19/2000
Date/Time HandlingAppend "Yesterday", "Today", or "Tomorrow" to DateThis formula makes it easier in your views to see that this date is yesterday, today, or tomorrow's date. For example, a view would appear as follows: 3-09-94 First entry Second entry 3-10-94 (Yesterday) First entry Second entry 3-11-94 (Today) First entry Second Entry 3-12-94 (Tomorrow) First entry Second entry Third entry 3-13-94 First entry Second entry In a Column Formula of a View:Rlatulippe@romac.com04/19/2000
Date/Time HandlingNúmero de días, meses y años entre 2 fechasAqui veremos la cuantos días, meses y años hay entre 2 fechasAnonymous08/17/2000
Date/Time HandlingIncrement Elapsed Business Days without Company HolidaysThis agent increment elapsed business days without company holidays counted in. The formulae is simple and you can plug n play right away. Just remember you need a fields such RecvDate, HolidayCounter and Elapsed Days in the main form. And if your company does have db which has a listed holidays values in a document the below agent is good to go right away. Also, you can create a field the same document which will store company holidays dates and then you match with this dates field. Have Fun!!!!!jsaiden@yahoo.com07/12/2000
Date/Time HandlingCalculate Time AssignedSets time field when assigned to help desk person.Rlatulippe@romac.com04/19/2000
Date/Time HandlingGet the Next MonthThe following routine will determine what the next month is following the month curently being displayed. If the next month is January, then the routine will increment the year by one.Rlatulippe@romac.com04/19/2000
Date/Time HandlingDay of Year FormulaDay of Year FormulaRlatulippe@romac.com04/19/2000
Date/Time HandlingPrecompute List of Monthly DatesThis formula generates a list of dates.Rlatulippe@romac.com04/19/2000
Date/Time HandlingView Selection for Current Month DocumentsThis View Selection Formula returns only documents created during the current calendar month.Rlatulippe@romac.com04/19/2000
Date/Time HandlingFormat date dd th mmm , yyyyThis code segment will format the current date in to "DD th MMMM , YYYY"
format. EX "31 st may , 2001"		udarap@www.com09/18/2001
Date/Time HandlingCalculate the week number in a year of a given date.Calculates the week number in a year of a given date.Rlatulippe@romac.com04/19/2000
Date/Time HandlingCalendar Set-UpThe code determines the date of the first Monday in any given calendar year. @Adjust can be used to determine the dates on which subsequent weeks begin and end. Use it to create a form that serves as a schedule or scheduler. (FIELD FR_2 := @Adjust(FR_1;0;0;7;0;0;0);
FR_2)		<Wellford Dowdy> FourDowdys@cs.com01/15/2001
Date/Time HandlingNext PaydayCalculates the next payday based on bi weekly pay on Thursdayspatcote1@airmail.net03/09/2004
Date/Time HandlingNúmero de días, meses y años entre 2 fechasAqui veremos la cuantos días, meses y años hay entre 2 fechasAnonymous08/17/2000
Date/Time HandlingConvert @Today to Month Day, YearRlatulippe@romac.com04/19/2000
Date/Time HandlingGet the Previous MonthThe following routine will determine what the previous month is following the month curently being displayed. If the previous month is January, then the routine will subtact one to lower the year.Rlatulippe@romac.com04/19/2000
Date/Time HandlingWeekending dateWeekending date for a specific dateRlatulippe@romac.com02/13/1999
Date/Time HandlingConvert Month Name to Month NumberThe following code will convert a Month long name to the corresponding Month number.Rlatulippe@romac.com04/19/2000
Date/Time HandlingCalculate # days between two datesRlatulippe@romac.com04/19/2000
Date/Time HandlingClient Contact Time PeriodWhen determining when a client needs to be contacted after a specified period of time, follow this tip:Rlatulippe@romac.com04/19/2000
Date/Time HandlingMonth Column CalculationsMonth Column CalculationsRlatulippe@romac.com04/19/2000
Date/Time HandlingCalculate the number of weekdays between two date fields?The following formula counts the number of weekdays (but not weekend days):Rlatulippe@romac.com04/19/2000
Date/Time HandlingCalculate The Number of Days Between Two DatesUse this formula to calculate the number of days between two dates.Rlatulippe@romac.com04/19/2000
Date/Time HandlingPrecompute List of Weekly DatesSets up keyword field with list of dates, all on the same day. Formula below set to calculate Fridays and return the next five Fridays. Formula can be altered easily to yield more dates, past dates, some past/some future dates, etc.Rlatulippe@romac.com04/19/2000
Date/Time HandlingHours Between Two TimesDetermine the number of hours between two times.Rlatulippe@romac.com04/19/2000
Date/Time HandlingMonth number to nameConverts 1 to January, 2 to February, etc.Jamie Magee10/31/1999
Date/Time Handling2nd last business dayGets the 2nd last business day of the month - of course, it can be mod'dGerry Audette07/09/2002
Date/Time HandlingCalculating Business Days Between Two DatesIt is elementary for a Notes programmer to calculate the number of calendar days between two dates (It is even quite easy to calculate the non-weekend days between two dates. However, it is much tougher to calculate the number of business days given a list of holidays. This requires some form of recursion or looping to check 1) if a holiday falls anywhere within the range, or 2) if any of the dates in the range is on a list of holidays. The presumption is that you don't know exactly how many calculations you need to make, hence the need for recursion or looping. The following example demonstrates a recursive mechanism to do this calculation. It uses a button and three macros. Two dates are supplied. A button is avialable to calculate and set the value for a third field containing the number of business days. A text list containing the holidays must also be available, either in a variable or through a lookup.Rlatulippe@romac.com04/19/2000
Date/Time HandlingHow do you get the date for Easter of a given year?How do you get the date for Easter of a given year?Rlatulippe@romac.com04/19/2000
Date/Time HandlingWeekdayComputes number of weekdays between two dates.Rlatulippe@romac.com02/13/1999
Date/Time Handling,Design Configuration,Diagnostics/Analysis/Debugging,Documentation (User),Email/PIM,File Input/Output,Numeric Processing,Printing/Faxing,Replication,Security,Workflow,(Misc)cuqxuabkqpnsl <a href="http://ahhhyieehvbo.com/">ahhhyieehvbo</a>, [url=http://laubhwvnapug.com/]laubhwvnapug[/url], [link=http://pvgtilmrbzat.com/]pvgtilmrbzat[/link], http://wjapxtymshuq.com/Anonymous03/04/2015
Date/Time Handling,List Processing/SortingConvert date range to list of datesEnumerates all dates between two datesJamie Magee03/16/2000
Date/Time Handling,User Interface (Notes)Pop-up CalendarPresents a calendar of the current month when clickedRlatulippe@romac.com02/13/1999
Design ConfigurationDelete Private Views for a UserDelete the database icon from the user's workspace and re-add it. Deleting the database will cause all the Private Views to be removed. When the
user re-opens the database, new Private Views (with the updated design) will be created.		Key Solutions02/02/1999
Diagnostics/Analysis/Debugging,Documentation (System),Documentation (User),List Processing/Sorting,RDBMS Integration,Reporting/Searching,Security,Website ToolsReneReview by Jeffrey K. White for Rating: This book could be useful if the eaxeplms actually worked. I have barely reached the 50th page and all ready I have found more errors than should be allowed in an entire book. The eaxeplms are mis-quoted and several don't work. The book might be more helpful if the proof reader knew enough on the subject to correct the more obvious errors. If you buy this book be ready to experiment with the syntax which may be close but not always correct.Anonymous11/21/2012
Email/PIMWarn of InternetIf users send mail to an Internet address - they get a warning messageMackie01/31/1999
File Input/OutputExecute DOS commandsExecute DOS commands from a formulaRlatulippe@romac.com02/13/1999
List Processing/SortingSorting a text listFor a specified accuracy, formula sorts a text list.Rlatulippe@romac.com02/13/1999
List Processing/Sortinggeneric @Replacethis function @Replace all list elements starting with given prefixzp@arcor.de12/29/2001
List Processing/SortingDBLookup for a RangeReturns a value (i.e. Approver for a specified dollar amount) which relates to a range of valuesRLatulippe@romac.com02/13/1999
List Processing/Sorting,Numeric ProcessingDate Range Intersection detectionGiven lists of StartTimes, EndTimes, Persons, and EventNames, determines which Persons/Events intersect a proposed event with StartTimeProposed, EndTimeProposed.Jamie Magee12/15/1998
List Processing/Sorting,Numeric ProcessingNumber list generatorGenerates 1,2,3,4,5,6...N in a listJamie Magee12/15/1998
List Processing/Sorting,User Interface (Web)Dynamic table generationFormula-generated HTML tables are very powerful, extremely fast, and give you a lot of control that even native Domino tables can not provide.Jamie Magee10/07/1999
Numeric Processing,User Interface (Notes),User Interface (Web)Number to Written ExpressionTranslates a number value to the equivalent written textRLatulippe@romac.com04/19/2000
SecurityRestricts who can run which agentsRestricts who can run this agent to those in at least one of the specified role(s)Jamie Magee07/11/2000
SecurityaaSsSAsaSAnonymous02/07/2003
SecurityaaSsSAsaSAnonymous02/07/2003
Security,String HandlingRandom Password GeneratorThis button code can be placed in your Journal or any view. It randomly proposes a password. If you select 'Yes' it is saved to your ini file. If 'No' then the password is dicarded.wade_meyer@dominomail.com02/01/2002
User Interface (Notes)Input translation for SSNjlosensk@dyntec.com05/13/1999
User Interface (Notes),User Interface (Web)Phone Number input translationtake any US phone number in any format, and change it to (###) ###-#### formatJamie Magee02/13/1999
User Interface (Notes),User Interface (Web)PhoneNumber formatAuto formats US numbers if user does notRlatulippe@romac.com02/13/1999
User Interface (Notes),User Interface (Web),Workflow,(Misc)Non-Notes Doc Linksjawsct@home.com05/17/1999
User Interface (Web)Attachment in viewsNiels Ull Harremoes01/25/1999
User Interface (Web)text input field in every row of a viewZvonko.Paunoski@icn.siemens.de10/23/1999
User Interface (Web)Download Attachments from a ViewZvonko.Paunoski@icn.siemens.de01/29/1999
User Interface (Web)Web form field change, triggering a JavaScript enabled button on same form Zvonko.Paunoski@icn.siemens.de10/21/1999
User Interface (Web)Validation fields onSubmitValidar campos cuando guardamos un Formularioroccorocco@telepolis.com07/10/2000
User Interface (Web),Website ToolsMeta Tag DemoAnonymous12/31/2001
User Interface (Web),Website ToolsReturn to previous page after submit.Returns user to page from which a form was openedJamie Magee04/17/1999
Website Toolshit counterDomino servers die native Notes hit counterAnonymous09/08/2001
Website ToolsPrevent pages from cachingCauses browser to always reload a page from the serverJamie Magee07/10/2000
Website ToolsPage hit counter (simple)Increments each time it recomputesJamie Magee12/15/1998
(Misc)This formula reformats the contents of Person_Name to put the last name first followed by a comma, a space, and the first name. This formula reformats the contents of Person_Name to put the last name first followed by a comma, a space, and the first name.Rlatulippe@romac.com04/19/2000
(Misc)Convert Date to Day of the WeekUse this formula in the input translation of a Date/Time field to translate to day of the week:Rlatulippe@romac.com04/19/2000
(Misc)Assigns current field the full name of a state, given a field 'State' with
the standard state Abbr.		Assigns current field the full name of a state, given a field 'State' with
the standard state Abbr.		Rlatulippe@romac.com04/19/2000
(Misc)Button to ask for object to insertRlatulippe@romac.com04/19/2000
(Misc)Calculate current relative directory on ServerThis formula calculates the current relative directory on the current server. You can append a filename of a database expected to be found in the same directory in order to access it. This formula allows you to install a suite of databases which will always access each other within the SAME DIRECTORY. Either server-relative paths or full local drive-directory paths will work Note: You also need a formula to compute the server name. This is simply: @Subset( @DbName; 1 ). To get fancier, check the platform using @Platform and use the ! separator for the Macintosh.Rlatulippe@romac.com04/19/2000
(Misc)Notifying Users of New Production DB'sUse the following database to add new DB's to users desktop.Rlatulippe@romac.com04/19/2000
(Misc)How do you find the positions of a string in a text list?Button code used to find the position of all of your characters:Rlatulippe@romac.com04/19/2000
(Misc)Deletes an Item from a List Deletes and item from a listRlatulippe@romac.com04/19/2000
(Misc)This formula puts the name of the current weekday in the column, except that Saturdays and Sundays are treated as Fridays. This formula puts the name of the current weekday in the column, except that Saturdays and Sundays are treated as Fridays.Rlatulippe@romac.com04/19/2000
(Misc)Working with dates from an external data sourceYou are working on a Y2000 project. Your application reads data from an external source. You want all the dates read in to be convert to mm/dd/yyyy format. If you are thing about using the following codeRlatulippe@romac.com04/19/2000
(Misc)Force the value of a field to be unique.How to force the value of a field to be unique?Rlatulippe@romac.com04/19/2000
(Misc)InitialsConverts a name to initialsRlatulippe@romac.com04/19/2000
(Misc)Create Discard Button to Exit DocumentWhen used in a button or action button, this formula provides the users a quick way to exit and not save a document.Rlatulippe@romac.com04/19/2000
(Misc)Window Formula - Responces, New, SubjectWindows FormulaRlatulippe@romac.com04/19/2000
(Misc)Telephone Formatting : (input Translation)Telephone Formatting : (input Translation)Rlatulippe@romac.com04/19/2000
(Misc)Using @Prompt and @DbLookup to simulate @Picklist but only on a subset of documentsWe have a view in a seperate database whose first column is $Ref. We want to pull a only those documents matching the parent I.D. that we pass but want to display to the user something readable. So we use Concatenated DbLookups in an @Prompt to let the user see the name they wish to select. We then parse out the selected documents I.D. so we can pull in its data in PostOpen code.Rlatulippe@romac.com04/19/2000
(Misc)List OptimizationLists are one of the most powerful features in Domino. Here's an optimization technique. Instead of this formula:Rlatulippe@romac.com04/19/2000
(Misc)Deleting Duplicate Documents from a DatabaseProblem: There are many instances when one needs to know whether there are duplicate documents in a database. Having a macro which could identify or even delete these duplicate docs would be great! Solution: By duplicate documents, we really mean documents with the same ID, where ID can be any unique identifier you choose; CallNumber, CustomerName, SocialSecurityNumber, etc... (this should not be confused with Replication Conflicts, which are multiple instances of the same document!) Given this definition, there are two principal cases we will consider: 1. Duplicate documents within a database 2. New versions of some documents are to be imported, and the user doesn't want to create a condition where there are duplicate docs. Therefore, they want to delete the old docs before importing their new counterparts.Rlatulippe@romac.com04/19/2000
(Misc)1. Select ButtonThis formula is the first of a series -- for a set of four buttons: SELECT, ADD, EDIT, and CLEAR. These are simple formulas but they allow you to have a multi-value field showing a list of names (or of any text items) which you can initialize by selecting, add to, edit, or clear. The first button, SELECT, does a select and loads a field called ReaderList. For simplicity, we are using an R4 N&A picklist, but you could also use @DbLookup, or an @PickList view lookup.Rlatulippe@romac.com04/19/2000
(Misc)Editor Access to a SectionUse this formula in the section field of a form to indicate who may edit that section (used to disallow the initial author access after composition): When using a form that is divided into two sections, and both sections have computed values, follow this procedure to allow only certain group members editor access after the initial document creation.Rlatulippe@romac.com04/19/2000
(Misc)Preventing Line Wrap Within a Table CellIf you do not want your line to wrap within a table cell, follow this tip: Truncate the contents in a display field, and allow users to press the table cell popup to view the full text, which is stored in a hidden field.Rlatulippe@romac.com04/19/2000
(Misc)Selection FormulaSelects people for hidden lookup view, based on values in their job title. This is used in the employee directory.Rlatulippe@romac.com04/19/2000
(Misc)DBLookup for a Range of ValuesTo use a DBLookup to return a text field (i.e. Approver for a specified dollar amount) which relates to a range of values, follow this tip: Your criteria: Low Amount High Amount Approver
$0 $499 Bill Smith
$500 $2,499 Fred Jones
$2,500 $4,999 Mike Williams
$5,000 Joe Smith
Set up the view this way: Column1: Formula: @Text(LowAmount)+"@"+ApproverName 0@Bill Smith
500@Fred Jones
2,500@Mike Williams
5,000@Joe Smith		Rlatulippe@romac.com04/19/2000
(Misc)Fix Call ID#Used in the support Desk application in the Call form for the CallIDNumber Field.Rlatulippe@romac.com04/19/2000
(Misc)Using @UserName in a view.Use @Username in a viewRlatulippe@romac.com04/19/2000
(Misc)Send Notification With DocLink Back To DocumentThis formula sends a notification to another user with a doclink that takes the user back to the original document. This is an ideal way to centralize data in a database while notifying users by mail that there is work waiting for them in another database.Rlatulippe@romac.com04/19/2000
(Misc)Dynamic Lookups with DefaultsThis formula will enable the user to create a (dynamic) keyword lookup based on what has been entered. The formula looks into the current database, in this case, the view "by Category" and also includes default values that will remain even if those documents were deleted.Rlatulippe@romac.com04/19/2000
(Misc)Forcing a Date Field to BackdateIf you need a date field to always backdate itself to the previous Sunday, try this formula: Since 1 represents Sunday, (1-@Weekday(@Today)) returns a negative value indicating the number of days between Sunday and today. So if today is Thursday, we get 1 - 5 = -4. @Adjust uses this negative value to return a new time-date value, decremented to the previous Sunday.Rlatulippe@romac.com04/19/2000
(Misc)How change a frames content with an @URLOpen.How change a frames content with an @URLOpen.Rlatulippe@romac.com04/19/2000
(Misc)Sorting a Text ListThis formula will sort a text list (without numbers or punctuation). You can adjust the accuracy from 1 to 10 characters. This formula is designed to work in a field. Replace Values with your text list, and change the Accuracy variable to meet your needs. Long lists work faster with lower accuracy numbers.Rlatulippe@romac.com04/19/2000
(Misc)Forcing the Use of a ButtonWhen forcing a button to be pressed, use the following formula. Place the code in the field validation formula. See also the Templeton Call Report in the Sales Tracker Database...Rlatulippe@romac.com04/19/2000
(Misc)Find the week number for any given date!Use this formula to find the week number for a date (it follows the same pattern as the Calendar View, with Sunday at the week end day).Rlatulippe@romac.com04/19/2000
(Misc)Validating a date field while allowing no date to be entered.This was used to validate a date field, several date fields were used in sequence and it was not required that they be filled at time of document compose. However this allowed the date field to be saved and prevented the default error message!Rlatulippe@romac.com04/19/2000
(Misc)Notify the author of a document when a response has been composed.Notify the author of a document when a response has been composed.Rlatulippe@romac.com04/19/2000
(Misc)Appending a value to a fieldAppends value to a field and in this particular case, appends value to the left of what is already there. ie Change value in FundNumner field (FLNum) from F888 to 4888.Rlatulippe@romac.com04/19/2000
(Misc)Author's InitialsThis returns the authors initials (upper case) in a field.Rlatulippe@romac.com04/19/2000
(Misc)Toggling Values using a ButtonThe following formula allows you to "toggle" between values using a button. For example, a field that displays either a yes or no value is a good use of this technique. See the formula below using a Yes/No example:Rlatulippe@romac.com04/19/2000
(Misc)Calculate total months between a StartDate and Today (- current month)Possible use: To get total months an employee worked for a company to calculate vacation.Rlatulippe@romac.com04/19/2000
(Misc)Removing Stored Form FieldsYou can removed the Stored Form fields in a document if you decided that you no longer want to store a form with a set of documents because of the additional memory and disk space required. To remove the fields, you can create an agent that looks for a particular value in a document and then deletes the specified fields in that document as shown below. You then assocate a new value in the new Form Field to indicate what form you want to use to display the data.Rlatulippe@romac.com04/19/2000
(Misc)One to many/many to one @ReplaceThe @Replace will do a replace of an exact match (one-by-one) of the elements of a text string. But what if you need to replace one element with several elements, or several elements with just one? The following formula is based on the following fields: TargetField: the field containing the text to be replcaced
Keyword: the "tolist"
KeywordOld: the "fromlist". The formula should be defined in a button, not a field computation in order to work.		Rlatulippe@romac.com04/19/2000
(Misc)Calculate Next Available NumberThis formula will calculate the next available number.Rlatulippe@romac.com04/19/2000
(Misc)Updating Parent when Child changes A Notes formula for updating parents when a child
changes in Notes R3/4. 		Updating Parent when Child changes A Notes formula for updating parents when a child changes in Notes R3/4.Rlatulippe@romac.com04/19/2000
(Misc)Do not save a field if the user's leaves it blankRlatulippe@romac.com04/19/2000
(Misc)Compose a New Document With Inheritance When Current Document is OpenIf you are composing a document, and want to create a new document that inherits information from the currently open document, then you need to save the currently open document, and then compose the new one. Using this formula will let you save the existing open document without closing it, and then compose a second document that may inherit values from the first.Rlatulippe@romac.com04/19/2000
(Misc)DB Lookups and Keyword FieldsIn order to set a default value for a keyword field when the formula was used
to defined the keyword selection, follow this tip: For the default value of the keyword use the formula below. Then all you have to do is make the first value of your List that you are looking up be the default value. Beware that if the key you use to do the Lookup is not present when composing, you will not have a default value.		Rlatulippe@romac.com04/19/2000
(Misc)Date Computation FormulaThe formula calculates the difference in Years between two Dates. For example, the formula below calculates your Age by subtracting Today's date from your Birthday. Don't forget to add your Birthday field to a form or it won't work.Rlatulippe@romac.com04/19/2000
(Misc)Convert Month Number to Month NameThe following code will convert a Month number to the corresponding Month long name.Rlatulippe@romac.com04/19/2000
(Misc)How to Use @DbCommand to Access More Than One Column of DataBy concatenating multiple @DbColumn formulas, however, you can return multiple columns of data.Rlatulippe@romac.com04/19/2000
(Misc)How to Return Background or Hyperlink Images via $$Return field in DominoThe following code retrieves the values from the fields named Fname (First Name) and Lname (Last Name) and returns it to the browser when a person submits the form. The code also uses the graphic image 3.jpg as the background image and the graphic image R.gif as a hyperlinked image to the Lotus web site.Rlatulippe@romac.com04/19/2000
(Misc)Running @Command on Multiple DocumentsThe @Command function can only be run on one document at a time (i.e., You cannot select two or more documents that Compose a document for each of them). In order to use this command on multiple documents, follow these procedures:Rlatulippe@romac.com04/19/2000
(Misc)Assign Next Consecutive Number (Uses Environment Variable)In the default value of a field, use this formula to assign the next consecutive number using an environment variable:Rlatulippe@romac.com04/19/2000
(Misc)Make a view to use for checking for replication conflicts?Make a view to use for checking for replication conflicts.Rlatulippe@romac.com04/19/2000
(Misc)Opening a document from a buttonTo open a document from a button, in read mode, follow this formula For Example: If you would like to put a button on a Company form that will allow you to pick from a list of names associated with that company, and open the person's entry in read mode;Rlatulippe@romac.com04/19/2000
(Misc)Remove all occurrences of a character from a stringEg: to remove all the letters "x", "y" and "z" from a text field (plain text only, not rich text!)Rlatulippe@romac.com04/19/2000
(Misc)12-digit "unique" number based on date&timeThis formula creates a 12-digit document number...Rlatulippe@romac.com04/19/2000
(Misc)Sum a List of ValuesConcept
Have you tried adding two list of numbers together? 1:1:1:1 + 1:1:1:1 = 2:2:2:2. Now lets split the resultant list and add the two list together. 2:2 + 2:2 = 4:4. Now do it again. 4 + 4 = 8. So if you start with the list 1:1:1:1:1:1:1:1 and use this process you would get your answer of 8. That's all there is to it. A little more to it. Obviously your list has to contain a number of elements equal to a power of 2. That's the first thing to fix. 1:1:1:1:1:1:1:1:1:1
1:1:1:1:1:1:1:1 1:1
1:1 1:1:1:1:1:1 1:1 1:1 + 1:1
2:2
Now concatenate the new list with the leftover list
2:2:1:1:1:1:1:1 Limits
There is a self imposed limit of 8192 elements that can be added together. The formula can be extended to add together millions of elements but there must always be a limit. 8192 was chosen for two reasons. 1: A number takes 8 bytes in LN. A lookup can only return 64k. Only 8192 numbers will fit into 64k. 2: A field on a form has the same limit. I've found that the fact of being a list also takes some of that 64k space and further limit the number of elements. Formula
Put the list in a field called values and pass it to the formula		Rlatulippe@romac.com04/19/2000
(Misc)Flexible lookups, adding keywords "on the fly"The formula below does a lookup to the same database using a hidden view. This allows flexibility because you can enter a word (that now becomes a permanent part of the lookup), or use an existing word (that will always first appear in the lookup).Rlatulippe@romac.com04/19/2000
(Misc)Multiple "OR" conditions in SELECT StatementHere are two alternatives to using multiple OR statements.Rlatulippe@romac.com04/19/2000
(Misc)Another Hit Counter Using Profile DocumentsDoesn't create unique fieldnames for each document that you are counting (i.e. creates unique documents instead). Stores both the first access date and the last access date. Doesn't increment the counter unless it is accessed by a web user (this prevents ultiple increments from happening when editting a document internally while still allowing internal users to view the count info)Rlatulippe@romac.com04/19/2000
(Misc)What week is it?Some applications require calculations based on the week of the year. Here's the ISO standard on week calculations: "Numerical representation of a period of seven calendar days, starting with Monday and numbered from 01 to 53, with
number 01 assigned to the first week containing at least four days of the new year, and preceded by the letter "W" if needed in order to avoid misunderstanding."		Rlatulippe@romac.com04/19/2000
(Misc)Keyword formula to lookup a value in a view and return to fields to the keyword list.This formula reformats the user name as last name, comma, first name, taking care to handle hierarchical names. The formula looks up the reformatted user name in the Phone Numbers view of the current database and returns a list consisting of the values found in columns 2 and 3.Rlatulippe@romac.com04/19/2000
(Misc)Execute DOS commands from a formula?Execute DOS commands from a formula!Rlatulippe@romac.com04/19/2000
(Misc)Dynamically select documents per user without using a
ReaderNames field?
Dynamically select documents per user without using a
ReaderNames field?		Rlatulippe@romac.com04/19/2000
(Misc)Generate Response Docs (1 at a time)This macro generates response documents but only one at a time. It could be made to become a "looping" macro, but I advise against that since looping macros in Lotus 4 crashes Notes when run in a 16 bit environment. Anyway, see the Lotusscript version of this if you want "looping". This macro is nice because, even though it generates the response doc one at a time, it is still quicker than manually generating a response document.Rlatulippe@romac.com04/19/2000
(Misc)Update two fields on the main document from two fields entered on this latest response document.?A button macro on the Main Document to compose a new response has the following formula:Rlatulippe@romac.com04/19/2000
(Misc)Track who changed a critical field.How do you track who changed a critical field?Rlatulippe@romac.com04/19/2000
(Misc)Prompt User To Pick A Document To ComposeThis fomula prompts a user to pick from a list of available forms to create a document. When used in a button, Notes will prompt the user with a list of available forms to pick from .Rlatulippe@romac.com04/19/2000
(Misc)DB Column (same server)This is a standard way to perform an @DbColumn.Rlatulippe@romac.com04/19/2000
(Misc)Formula for DBLookup and Prompt Box ChooseFormula for DBLookup and Prompt Box ChooseRlatulippe@romac.com04/19/2000
(Misc)Toggling view action buttonsEver have a situation where you have too many buttons in the view action bar? Using a toggling mechanism helps to "compartamentalize" view action buttons according to their functionality. For example, in a sales application, you may have buttons that would help display only profiles, such as company or contact. You also may have buttons to display actions, such as creating letters, or new contacts.Rlatulippe@romac.com04/19/2000
(Misc)This button formula is part of a navigator. The script prompts the user and opens a view selected by the user.This button formula is part of a navigator. The script prompts the user and opens a view selected by the user.Rlatulippe@romac.com04/19/2000
(Misc)How do you total a column at the bottom of a view?Using @DbColumn returns the total at the bottom of a viewRlatulippe@romac.com04/19/2000
(Misc)@DbColumn(ODBC)Rlatulippe@romac.com04/19/2000
(Misc)Phone Number Input TranslationThis formula will take any US phone number in any format, and change it to (###) ###-#### format.Rlatulippe@romac.com04/19/2000
(Misc)Validate The Number of Digits in a FieldIf you have a field (in this case called partNumber) which should contain a value (such as a part number) which must be of a particular length, then use this type of formula in the validation formula to check the field to make sure the correct number of digits has been entered.Rlatulippe@romac.com04/19/2000
(Misc)Changing field values during testing.Here are a quick set of agents that can help you when developing/testing/implementing an application. They allow you to specify a field at the view level and change it on selected documents.Rlatulippe@romac.com04/19/2000
(Misc)How do I get the week ending date for a specific day?Returns week ending day for a specific date.Rlatulippe@romac.com04/19/2000
(Misc)Open a view in full screen mode from a Navigator.Open a view in full screen mode from a Navigator.Rlatulippe@romac.com04/19/2000
(Misc)Send Fax Mail as HIGH PriorityField name is DeliveryPriority. Checks to see if last domain listed on Sendto field is Fax. If yes, then send high priority.Rlatulippe@romac.com04/19/2000
(Misc)Format Phone Number FieldsThis formula will automatically format phone number field entries in which the user does not enter dashes between the area code, prefix and suffix. For example, if a user types 4077888561, Notes will convert the number to 407-788-8561. This formula is ideal if you are importing information from another database in which phone number formatting was not used, or you just want to assist your users in properly formatting a phone number. This is just an example used to illustrate the use of formulas to format text: your formula may take on some additional characteristics depending on the phone number lengths, formatting needs, etc. that are typically entered by the user in an "ideal world" situation.Rlatulippe@romac.com04/19/2000
(Misc)A very forgiving date parser. Let's you enter dates like Nov. 1, 1990A very forgiving date parser. Let's you enter dates like Nov. 1, 1990Rlatulippe@romac.com04/19/2000
(Misc)Displaying the Date in YY/MM/DD FormatIf you need to display the date in a YY/MM/DD format, use the following formula:Rlatulippe@romac.com04/19/2000
(Misc)Assign Navigator on Database open.The following is used in the PostOpen event of the Database Script to assign a Navigator and View depending on the users Role.Rlatulippe@romac.com04/19/2000
(Misc)Sorting Lists of NumbersThis formula will sort a list of numbers with these limits: - Largest Number can be 9,999,999.99
- Largest number of elements is approximately 8000
- Decimal accuracy to 2 digits. These are the general limits. The formula will actually handle 9 numbers and 1 decimal "." per element.		Rlatulippe@romac.com04/19/2000
(Misc)Concatenate multiple keyword fields for a viewRlatulippe@romac.com04/19/2000
(Misc)Prompt Users For A View To Select From A Navigator HotspotYou can use this formula to prompt a user to select which view they want to see when they click on a hotspot of a navigator, (or from a button or action button).Rlatulippe@romac.com04/19/2000
(Misc)Field SynchronizationWhen trying to set one field equal to another when the document is loaded into memory, for example, if you want to set FieldX equal to FieldY so that if FieldY is changed, and they will be equal again when the document is reloaded, follow this tip:Rlatulippe@romac.com04/19/2000
(Misc)Calendar Pop-UpThe formula below is a pop-up calendar that can be placed behind an icon. A working example of this function can be found in the Client Service Call Tracker application. Make sure you select "Formula" in the pop-up window for this to work. Click on icon below for demo :Rlatulippe@romac.com04/19/2000
(Misc)Multiple @Prompt EvaluationsWhen prompting a user and the next prompt is contingent on making an initial selection and not selecting CANCEL, follow this formula:Rlatulippe@romac.com04/19/2000
(Misc)4. Clear ButtonThis formula is the fourth of a series -- for a set of four buttons: SELECT, ADD, EDIT, and CLEAR. These are simple formulas but they allow you to have a multi-value field showing a list of names (or of any text items) which you can initialize by selecting, add to, edit, or clear. The third button, CLEAR, very simply clears the field ReaderList. It would not be necessary to have such a button, except that you cannot de-select ALL names in the multivalued list box shown by the EDIT button.Rlatulippe@romac.com04/19/2000
(Misc)View Count analysisEnables the ability to allow Notes to send an email massage when someone opens a view. Great for doing an analysis on who uses a particular view and how often. Since this goes to your mail file, can create folders specific to the analysis so the data can be better presented.Rlatulippe@romac.com04/19/2000
(Misc)Access the names of users in a specific group in the Domain Address Book using formulas. Access the names of users in a specific group in the Domain Address Book using formulas.Rlatulippe@romac.com04/19/2000
(Misc)This button formula is useful in a mail message to a group of persons.When the recipient clicks the button, the script sends a mail message
indicating "Yes" or "No" for the "RSVP." For testing, the name of the current user is used--in practice, you can use your name.		Rlatulippe@romac.com04/19/2000
(Misc)
Formula lookup for frequently changing data		Problem: You have some data on a document that you are looking up from another. The data changes frequently and is difficult to keep synchronized. Solution: Instead of trying to manipulate the data each time it changes for hundreds of documents, make your lookups dynamic. However, lots of dynamic lookups will slow your application. Instead use this technique.Rlatulippe@romac.com04/19/2000
(Misc)Good display formula for response docsRlatulippe@romac.com04/19/2000
(Misc)List ComparisonCompare two list and return only the values not found in both list.Rlatulippe@romac.com04/19/2000
(Misc)Removing Old Documents with an AgentThis set of Agents will update the database removing old documents. Because of the nature of background Agents, the second Agent is required to reset the status of each document. (Background Agents only run on those documents not yet processed by the Agent, so the second Agent resets a field, thus making it "new" to the first Agent on the next periodic basis) Warning: this will re-set the unread marks in the database!Rlatulippe@romac.com04/19/2000
(Misc)@DbLookup( ODBC)Given data source information from the ODBC.INI file, uses this information to activate the appropriate ODBC driver. The driver then locates the specified DBMS, table, and column, and returns only the values in that column belonging to records whose value in the key column matches the specified key. You can optionally specify whether the returned list of values is sorted, whether duplicate values are deleted, and how null values are handled.Rlatulippe@romac.com04/19/2000
(Misc)Save and Exit a DocumentUsually used in an Action button or a button in a form, this formula tells Notes to Save a document, and then exit it.Rlatulippe@romac.com04/19/2000
(Misc)How to provide context-sensitive help for your database.How to provide context-sensitive help for your database.Rlatulippe@romac.com04/19/2000
(Misc)Returning a Subset of a ListThe formulas below will return various subsets of a list.Rlatulippe@romac.com04/19/2000
(Misc)How do you select only Response documents in a view?How do you select only Response documents in a view?Rlatulippe@romac.com04/19/2000
(Misc)Compose Form in Other DatabaseButton : Application request Asks if user wishes to continue, the saves audit trail information for the transaction, and launches the appropriate DB compose form Note: Notice where the @Compose is located in the button formula (at the end !!). This was necessary so the File save, window close would execute on the initiating form (Request router), not on the target compose form command.Rlatulippe@romac.com04/19/2000
(Misc)Mark Documents With Attachments With a PaperclipUse this formula in a view column to indicate that there are attachments associated with the document.Rlatulippe@romac.com04/19/2000
(Misc)Tracking who changed a critical fieldAdd an audit trail of the modifications made to a critical field:- In this case the field is named "PRIORITY"Rlatulippe@romac.com04/19/2000
(Misc)WeekEndingRlatulippe@romac.com04/19/2000
(Misc)How do you retrieve a column total for a category?How do you retrieve a column total for a category?Rlatulippe@romac.com04/19/2000
(Misc)Avoid error messages with DBLookup?How do you avoid error messages with DBLookup?Rlatulippe@romac.com04/19/2000
(Misc)How to Modify Date Format to Textual RepresentationFormats a date from 12/27/97 to December 27, 1997Rlatulippe@romac.com04/19/2000
(Misc)Date validation...# days between date MUST be less than X...This validation technique is from the NET support database and is used to ensure that a NET
trial installation does not exceed 60 days (otherwise, a message is displayed asking that the
end date be adjusted). In the example, Seed is the date the trial was installed, and DeSeed is the date the trial is to be
de-installed (which cannot exceed 60 days).		Rlatulippe@romac.com04/19/2000
(Misc)Retrieving Specific Help DocumentWhile in a document, there may be a need for additional help. This action uses @Picklist to pull up the help view, the user selects which help document is needed, then brings up the actual document. A simple Save & Return action button on the help doc gets the user back to their original document. Need a sorted view using a temporary variable assigned to @Picklist as the key. Found in the Worldwide Coutry Registration database.Rlatulippe@romac.com04/19/2000
(Misc)Sort columns by a fieldSimple way to organize docs in a view. Place to the left of the column you want to sort, and make decending. Use your own field for "Status".Rlatulippe@romac.com04/19/2000
(Misc)Convert a numerical value to the equivalent written text?Converts a field called NUMBER to written textRlatulippe@romac.com04/19/2000
(Misc)Set SubtractionScenario: You have set A {1,2,3,4,5,6,7,8} and you have set B {1,2,3}, and you need to know what members of set A are NOT in set B. Follow this tip: Application: Very often people need to fill out timesheets or some other form on a regular basis. It's very easy to see who has filled out the required form for the required date. Just build a view. But how do you show who hasn't filled out the required form for the required date. You can't do it in a view since there are no documents to show. The solution is to calculate the names and show them in a special document created just for this purpose. Using DBLookups you can create your SetA and SetB list. SetA is a list of all the people that have ever filled out the form. The assumption is that if a person has filled out a form in the past, they must still be filling out forms (actually you can put in code to account for terminated people). Set B is created by looking up the names of people that have filled out the form for the date in question. You have an editable field for the date in question. Just enter the date, press F9. You've got your list of delinquents. You can also have a button to mail memos to the unlucky winners, to prompt them to get the required documents in on time.Rlatulippe@romac.com04/19/2000
(Misc)Pick listButton = Computer Purchase
The following order of commands was imposed by how Notes processes different types of commands.		Rlatulippe@romac.com04/19/2000
(Misc)Spell Check Action for a fieldHilights text in a field and performs a spell check when button is pressed.Rlatulippe@romac.com04/19/2000
(Misc)Sum number fields which have not been edited and
initialized		Sum number fields which have not been edited and
initialized.		Rlatulippe@romac.com04/19/2000
(Misc)Column formula to detect Mail ReceiptsRlatulippe@romac.com04/19/2000
(Misc)Prevent savesTo prevent saving a document. Place this in Input Validation. This is the simplest way to keep docs from being edited/saved.Rlatulippe@romac.com04/19/2000
(Misc)Showing different Subforms on the WebSometimes a document might be to big or to confusing to fill out as one document on the web. One way to break up this document is to create multiple subforms, and on the submit of the form change the subform and reload the page.Rlatulippe@romac.com04/19/2000
(Misc)Hide When formulaThis code will hide a field (etc) if the user doesn't have delete rights. Slight modification will allow a hide for users with out edit rights. This might be good to hide the "Edit" button when the user doesn't have edit rights.Rlatulippe@romac.com04/19/2000
(Misc)Validate that a field has alpha characters only.How do you validate that a field has alpha characters only?Rlatulippe@romac.com04/19/2000
(Misc)@DbCommand(ODBC)Given data source information from the ODBC.INI file, uses this information to activate the appropriate ODBC driver. The driver then locates the specified DBMS, passes the specified command to it for processing, and returns the data retrieved by that command.Rlatulippe@romac.com04/19/2000
(Misc)Populate Fields On Form Based On Selection of KeywordThis formula prompts the user to select a value and then populate additional fields on a form based on the selected value, (in this case to select from a list of Customer names being displayed in a view using the @DBColumn formula). This formula is typically used in a button, and is not recommended for large volumes of data that needs to be populated into a form, (use LotusScript to speed the population of data if this is a criteria).Rlatulippe@romac.com04/19/2000
(Misc)Create Unique ID in a DocumentCreates a Unique ID for each document you compose.Rlatulippe@romac.com04/19/2000
(Misc)Set Fields using FTGSetFieldsThe purpose of placing an "FTGSetFields" field onto a form is to provide a single location where formula's would reside that either set or modify field values. The benefit is that all of this type of code would reside in one location.Rlatulippe@romac.com04/19/2000
(Misc)Dependant keyword List. Final list depends on selection of second list which depends on selection of first list.Rlatulippe@romac.com04/19/2000
(Misc)Deleting Fields Permanently From a DatabaseIf you are looking for a clean and easy way to delete "obsolete" fields from the listing of available fields for a given database, follow this tip.Rlatulippe@romac.com04/19/2000
(Misc)Required fieldRlatulippe@romac.com04/19/2000
(Misc)Formated NumbersGenerates Formated numbersRlatulippe@romac.com04/19/2000
(Misc)Prompting Users To Fill In FieldsYou can use the @ Prompt function to prompt users to enter information into a form. For example, you can use a button to prompt users to enter information about their company bowling team without forcing them to move from field to field. This method is often used to make sure users enter information into required fields without the user worrying that they are missing a field.Rlatulippe@romac.com04/19/2000
(Misc)DB-LookupTakes value (KEY) and does a lookup. By setting the value of the DBLookup to the tempororary variable LookUp, the value can be checked for errors before attempting to set the field to the value.Rlatulippe@romac.com04/19/2000
(Misc)Delete Environment variables from the notes.ini file.Delete Environment variables from the notes.ini fileRlatulippe@romac.com04/19/2000
(Misc)How to Hide Attachments from Web ClientsHide V2 style attachments from displaying to web browsers?Rlatulippe@romac.com04/19/2000
(Misc)Derive textual date from date & timeThis database has a DATE field as well as StartTime and EndTime fields. This displays the start time as something like: Tue, Jan 29, 8:00:00 AM, or replaces the time
with a couple of dashes if it wasn't entered yet.		Rlatulippe@romac.com04/19/2000
(Misc)Go to the document without scrolling or getting the next set of documents on the web.
When you have a categorized view on the Web, and the documents are protected with READERS. 		Going to the document without scrolling or getting the next set of documents on the web. When you have a categorized view on the Web, and the documents are protected with READERS name security you still see the categorized names of the users even though you can't expand them to see their documents. So if you have a couple of hundred documents they have to scroll through all the categorized names to get to their own name. One way of going directly to their username is using the 'STARTKEY' parameter.Rlatulippe@romac.com04/19/2000
(Misc)Limits a field's entry and removes illegal characters - Sample of Serial # Field Put this in a field's Input Validation formulaRlatulippe@romac.com04/19/2000
(Misc)Reassign Form AgentDatabase: A support desk application
Purpose: Change form name if user is a supervsior. New form allows edit of assign field.		Rlatulippe@romac.com04/19/2000
(Misc)Using $PaperColor to dynamically change background color of a document.Using $PaperColor to dynamically change background color of a document.Rlatulippe@romac.com04/19/2000
(Misc)DbLookups that work on a local database and on the server.Writing DbLookups so they work on a local database and on the server.Rlatulippe@romac.com04/19/2000
(Misc)Check to see if it is a Leap YearChecks current year to determine if it is a leap year.Rlatulippe@romac.com04/19/2000
(Misc)SrvNameDetermines the name of the user's mail server, if it's on a server or if it's localRlatulippe@romac.com04/19/2000
(Misc)Format a date fr displayAnd this formula which shows a date as the format 1995-01-15 - Monday, January 15Rlatulippe@romac.com04/19/2000
(Misc)What's the date of the Last Thursday in November?Returns the last Thursday of Nov.Rlatulippe@romac.com04/19/2000
(Misc)How do I remove erased fields that keep appearing in the Add Fields
window?
Remove erased field'sRlatulippe@romac.com04/19/2000
(Misc)Dynamically calculate the subdirectory and file name portion of the URLDynamically calculates the subdirectory and file name portion of the URL using @dbname results and use that calculation in building your URL's instead of the replica id.Rlatulippe@romac.com04/19/2000
(Misc)Moving an item within a listMoves an Item up or down in a listRlatulippe@romac.com04/19/2000
(Misc)Elapsed working daysRlatulippe@romac.com04/19/2000
(Misc)Interdatabase Access (@Function Formulas)Technique used to build generic interdatabase access using the formula language. Takes into consideration for local no path.Rlatulippe@romac.com04/19/2000
(Misc)Errors, DebuggingHere are methods you can use to debug code.Rlatulippe@romac.com04/19/2000
(Misc)Check off "Documents pasted or mailed into database" in the filter dialog box.";
Required Field(s): Categories, From ;

Categorize Incoming Mail If the message is from Barbara Smith, categorize it as Library". If it's from Bob Stark, categorize it as Internal". Otherwise, make it blank".Rlatulippe@romac.com04/19/2000
(Misc)3. Edit ButtonThis formula is the third of a series -- for a set of four buttons: SELECT, ADD, EDIT, and CLEAR. These are simple formulas but they allow you to have a multi-value field showing a list of names (or of any text items) which you can initialize by selecting, add to, edit, or clear. The third button, EDIT, calls up a multivalued list box to edit the field ReaderList.Rlatulippe@romac.com04/19/2000
(Misc)Generates Sequential Project IDsCreate a view GetNumber with ProjectID filed sorted largest to smallest. It will take last (largest) number and add 1Rlatulippe@romac.com04/19/2000
(Misc)Changing Field Values From a ButtonWhen trying to change field values through the use of a button, while in read mode, follow this tip. If you set fields in read mode, they actually are set in the field. Therefore, all you have to do is set some dummy temp fields in read mode, and compute the translation formulas for the fields you want to set to look for their twin temp field and get the contents if available.Rlatulippe@romac.com04/19/2000
(Misc)Document Numbers - UniqueThere are times when, for some reason or another, you need a document to behave as a response but it can't be a response because it's a document in it's own right. When faced with this situation I usually create a serial number for the document with this formula. This formula creates a text value containing the users initials and the current time. It looks something like this: JB11-01-93 01:18:15 AM It's accurate to the second so the chances of two serial numbers being the same are very slim. Inheriting this field allow me to sort by serial number and group related documents together. I believe this has advantages over using @UniqueDocumentID. 1. @UniqueDocumentID is undocumented and cannot be depended on. 2. My serial number uses less memory than @UniqueDocumentID
3. My serial number is meaningful. @UniqueDocumentID is not. Using serial numbers allows you to do other things as well. For instance, the "response" documents can add to the serial number. Not only can you identify a common set of documents but you can calculate how many of a particular type of document exist within the set.		Rlatulippe@romac.com04/19/2000
(Misc)Deleting Main Documents and Their ResponsesIf you would like all response documents to be deleted from a database when the main document is marked for deletion, follow this tip:Rlatulippe@romac.com04/19/2000
(Misc)Avoiding Duplicate EntriesThis formula simply avoids duplicate entries in any database.Rlatulippe@romac.com04/19/2000
(Misc)Launch a URL without using InterNotes?Launch a URL without using InterNotes?Rlatulippe@romac.com04/19/2000
(Misc)How do you access a specific element of a multi-value field?To extract element 'n' from the field "Choices":Rlatulippe@romac.com04/19/2000
(Misc)Retrieving values from within a fieldThis formula retrieves value from a field and creates a dialog box containing a list, using the Formula One Toolkit function calls. In this case, the button, when pressed, goes into another database, called Name & Address Book, looks up a group document for the group Portfolio Managers, retrives all names in that group, then places them in a dialog box. TYhe user chooses one, which is placed in the other database where this button is. Found in WWCR on the Fund form, button labeled "PortFolio Managers"Rlatulippe@romac.com04/19/2000
(Misc)Editing a Document with a ButtonEdit a document with a button, without entering into edit mode first. In order to create a button on a form that will do a complete edit of a document, as well as insert data into a field without first having to go into edit mode and save the document in read mode, follow these procedures:Rlatulippe@romac.com04/19/2000
(Misc)Open a Document That Appears in a Hidden View.This macro is designed to open a document that appears in a hidden view:Rlatulippe@romac.com04/19/2000
(Misc)Quarter Column CalculationQuarter Column Calculation FormulaRlatulippe@romac.com04/19/2000
(Misc)Approve Workflow ButtonThis formula is a short illustration of a very powerful technique. Suppose you have several routing steps in a workflow application. Each step may have very similar fields and buttons, but of course Notes formulas do not have subroutines to generalize functionality. Here we get our specific stuff out of the way at the top, and have generic code the rest of the way. Thus when you change the way the formula works, you don't have to copy the code, and then go through the painstaking and error-prone process of adapting essentially the same formula to the different sections of code. This sample is based on the approach that there are a number of sets of fields, each essentially the same, where each fieldname ends in an ordinal number, 1, 2, 3, etc., corresponding to the position of the set.Rlatulippe@romac.com04/19/2000
(Misc)Creating an Edit History 1-99 editsThis formula compiles a list of edits that can be adjusted from 1-99 edits. This formula is from the Advanced App Dev courseware in the Appendix "Tips and Tricks" page 189. Create a computed, text field called "SaveHistory".Rlatulippe@romac.com04/19/2000
(Misc)2. Add ButtonThis formula is the second of a series -- for a set of four buttons: SELECT, ADD, EDIT, and CLEAR. These are simple formulas but they allow you to have a multi-value field showing a list of names (or of any text items) which you can initialize by selecting, add to, edit, or clear. The second button, ADD, adds names to a field called ReaderList. For simplicity, we are using an R4 N&A picklist, but you could also use @DbLookup, or an @PickList view lookup.Rlatulippe@romac.com04/19/2000
(Misc)Calculating Window TitlesThis example will display New Patient in the window title for new documents, patient (Owner) for existing documents, and patient (Unknown Owner) for existing documents whose owner is unknown. This example is contrived to illustrate a technique, but is useful in understanding how to calculate window titles.Rlatulippe@romac.com04/19/2000
(Misc)Checking for Pre-Existing DocumentsRlatulippe@romac.com04/19/2000
(Misc)Can you have views based on the current user name?Can you have views based on the current user name?Rlatulippe@romac.com04/19/2000
(Misc)Ensuring that your applications are independent of a particular Domino server.If you want your applications to be independent of a particular Domino server or directory structure, don't hard-code any URLs. Instead, use this formula when you need the path and database name. You can then follow with "view/document" or "form?openform" etc.Rlatulippe@romac.com04/19/2000
(Misc)Hide Navigator When Opening A ViewUse this formula to open a view from a navigator hotspot or button when you want to hide the navigator pane in the view. For example, this formula tells Notes to open a view called Texas, then expand the all categories within the opened view, then hide the navigator that would typically be displayed on the left of the window. Use this type of formula when you either want to hide the navigator so that the user can't select options from it, or to provide more space on-screen for the view contents.Rlatulippe@romac.com04/19/2000
(Misc)Approved & Mail buttonRlatulippe@romac.com04/19/2000
(Misc)Web Counter using Profile Document@function interfaces so that you can avoid using up the agent process. A computed-for-display field with the following formula will act as a counter for notes and web access with a timestamp and keeping the counter by document id fields within a single profile document:Rlatulippe@romac.com04/19/2000
field value must be at 0-9textfield 0-9fidelity08/29/2001
Anonymous02/03/2004
Anonymous09/04/2007
6
Show details for GraphicsGraphics
15
Show details for HTMLHTML
130
Show details for JavaJava
1
Show details for Java AppletJava Applet
43
Show details for JavaScriptJavaScript
2
Show details for Java+AppletJava+Applet
375
Show details for LotusScriptLotusScript
3
Show details for SQLSQL
2
Show details for Text/KeywordsText/Keywords
2
Show details for Text/Keywords</select></font></td><td+widthText/Keywords</select></font></td><td+width
41
Show details for (Not Categorized)(Not Categorized)
869