Assuming forums is required, the following 38 results were found.
-
note the dates increment and do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to multiply based on the value of the column: SELECT EmployeeNo , DaysOffSick ,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) their password which implies there was an issue with pre 4.1.1...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
it from the users computer) Exit the command prompt and we are Done Other Links: DOS - String Manipulation DosTips.com - Forums SS64.com
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time like I did on the public key, verifying a JWT signature, or...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
// returns something like 1557400230165 Method #1: 5 Randomly Selected Letters Using a snippet from the community forums on how someone shuffled a pack of cards, I came up with a function that will take a list of letters, shuffle the list, and return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot down some notes here on how...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that usually I could customize the receiving PHP script to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
active products in a client's Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that will eventually be uploaded back to CRM. How? At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
when displaying it. I think it will be fine. Source(s) Joel's tired and inefficient brain The non-existent and plethora of forums not explaining how to attach a binary image to eBay eBay Developers Program - eBay Trading API v1247 -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
want attached to their respective records in CRM. This took me a while as our own documentation is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
(eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime() Source(s) Zoho CRM v3 Organization API Zoho Community Forums - CRM Business Hours through the API/Deluge Trial and Error
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the AutoHotkey forums: AddCommas(val) { val:= RegExReplace(val, "(\d)(?=(?:\d{3})+(?:\.|$))", "$1,") Return val } Another not tested:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF