Array Formula – A Better Way For Quick User Interaction.

In Microsoft Excel, an Array Formula provides you with a way to do powerful calculations on one or more value sets. The Array Formula works with an array of values, rather than a single value. Array formulas can return a single result, or multiple results. That sounds pretty simple enough, and indeed many array formulas […]

Continue Reading

The Power Of IBM Notes Formula Language

IBM Notes’ Formula Language is a powerful and versatile tool which can do almost everything a robust programming language may offer. It is used in forms, views, agents and almost all design elements and it can also be invoked from Lotus Script. Formula language provides this powerful functionality through a wide range of @functions. These […]

Continue Reading

WordPress Technique: Add Custom Column To The Posts List.

Add Custom Column (Featured Image) to the Posts List in WordPress Admin.Set a custom size of say, 55 pixels that will be used to show the featured image’s under Featured Image column: GET Featured Image of the provided Post Id. And at last we define two functions: the first will add the new column (featured_image), […]

Continue Reading

MS Excel Technique: Calculation of Public Holidays in USA

Microsoft Excel provides a very powerful formula language. You can achieve amazing things if you’re well capable of using it. Here’s the calculation of some of the public holidays in USA. You can calculate the rest in the same manner. Place the years in column A. Please refer to the below images taken from the […]

Continue Reading

LotusScript Trick: Loop Through The Selected Documents And Delete Permanently

Simple and self-explanatory example. Learn and enjoy! Set workspace = New NotesUIWorkspaceSet notesuidb = workspace.CurrentDatabaseSet collection = notesuidb.documentsFor i = 1 To collection.Count Set currentdoc = collection.GetNthDocument(i) Call currentdoc.Removepermanently(True)Next Call workspace.Viewrefresh()

Continue Reading

IBM Notes Technique – Filter the Documents on the last 15 working days.

View Selection Formula: Get the records of the last 15 working days. This is achieved by calculating total days (TotDays) by moving back from now() and excluding all sundays (weekday=1). So for instance, If there are 3 Sundays in this period then we have to take 15+3=18 as TotDays (total working days) to get the […]

Continue Reading

JQuery Technique: Parse JSON data

A couple of very simple and intuitive code examples to parse data received in JSON format: var resultJSON = ‘{“FirstName”:”John”,”LastName”:”Doe”,”Email”:”johndoe@johndoe.com”,”Address”:”123 dead drive”}’;var result = $.parseJSON(resultJSON);$.each(result, function(k, v) { //display the key and value pair alert(k + ‘ is ‘ + v);}); Or var obj = $.parseJSON(resultJSON);for (var prop in obj) { alert(prop + ” is […]

Continue Reading