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
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
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
The following function returns a List of Names (users) given a comma-separated-value string of levels: 0-No Access, 1-Depositor… 6-Managere.g: Levels = “1,2,3,4” or “4,5,6” or “5”The users having one of these access levels are returned in a list.
Continue Reading
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
Source: https://goalkicker.com/
Continue Reading
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
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
Sometimes it is required e.g, to get a comma-delimited-values list in a field from a relational database table. This is only possible to find some way to concatenate rows of the table. Following is one of the possible solutions using ‘FOR XML PATH’ expression in T-Sql. You may find other solutions as well. Suppose you […]
Continue Reading
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