The new formula is @UpdateFormulaContext in Lotus Notes, and all it does, in lay terms, is switch where the code is running. For example, if you compose a document, normally the code would continue to run where you were before the document was composed. But using the new @-function tells the Lotus Notes 6 client that the code should now run in the composed document.
Read more…
Viewed 8141 times by 2021 viewers
Most of you know that in the United States dates are shown in MM/DD/YYYY format, where many parts outside the U.S. use DD/MM/YYYY format. (And us Americans are also clueless about the metric system that everyone else uses, but that’s another topic). Anyway, on to the tip. What if you have a text date in a certain format and need to convert it to a Notes date-time value?
Read more…
Viewed 7453 times by 2079 viewers
Notes has provided access to the formula language in any text field. If you place a valid @-formula into a text field and press SHIFT+F9, the formula will be computed and the value for the text field replaced with the results of the formula.
Read more…
Viewed 7778 times by 2219 viewers
Yes, I know the title of this tip doesn’t mean much. But I couldn’t come up with a meaningful title in just a few words. So let me describe the situation. Let’s say you have a multi-value keyword fields that contains state names. And another multi-value keyword field that contains city names. The choices for the city names come from the selected state names. If you choose some cities, and then go back and remove a state, how do you eliminate those selected cities that are no longer choices?
Read more…
Viewed 8576 times by 2241 viewers
A co-developer recently had a list of document unique ID’s. He wanted to look up a value from each of the documents. His first thought was to use @GetDocField, as in @GetDocField(unidList; “Form”). (“Form” wasn’t the field he was looking up, but I’ll use it here as an example). @GetDocField only works on a single value, so it was only looking up the field from the first UNID in the list.
Read more…
Viewed 7548 times by 2448 viewers
If you’ve been developing in Notes for any amount of time, one thing you’ve probably accumulated in your “bag of tricks” is an “Edit History” subform where the dates/times of the most recent edits are shown. Here, I’ll talk about our basic edit history subform. This is called “basic” because it only shows overall edits (who and when) instead of tracking changes to specific fields. Tracking changes to fields is a lot more involved, so I’ll leave that for another time.
Read more…
Viewed 7963 times by 2205 viewers
we weren’t aware of the great new feature added to the @DbLookup function in Notes. The @DbLookup function now has an optional parameter at the end. This parameter takes one or more keywords in a list. I’ll describe these by showing an example.
Read more…
Viewed 6119 times by 1514 viewers
I know the title of this tip doesn’t mean much. But I couldn’t come up with a meaningful title in just a few words. So let me describe the situation. Let’s say you have a multi-value keyword fields that contains state names. And another multi-value keyword field that contains city names. The choices for the city names come from the selected state names. If you choose some cities, and then go back and remove a state, how do you eliminate those selected cities that are no longer choices?
Read more…
Viewed 6538 times by 1914 viewers
One of the drawbacks of computed text is that you can’t put a hotspot around it. But, if you’re using a form design element (either a regular form, or a $$Template), then there is a way to get the text of a hotspot to be dynamic.
What you want to do is create a computed for display text field. The value of the field is the same as what your computed text used to be. So now this field will display a text value, and it will be the same as your computed text.
You can now put a hotspot around a compute for display field. Viola! You have a hotspot where the “clickable” text is computed.
Read more…
Viewed 7297 times by 2001 viewers
Recently we had a situation where people have author access to a database, but a certain document in the database needed to be opened up to everyone. Normally, Authors fields contain a list of the people who can edit the document, and those with Author access to the database not listed in the Authors field cannot edit the document. An Authors field can take */O=YourCompany as a value to open up the document to everyone with that final qualifier in their ID file, but how do you open up a document to everyone, regardless of their ID file?
Read more…
Viewed 7882 times by 1999 viewers
