Assuming case is required, the following 142 results were found.
-
Configuration" and set the "Include site name in page titles" setting to "No" Open your templates component file (in the case of Yootheme using the Warp Framework this is \templates\\warp\systems\joomla\layouts\head.php, in the case of others this is...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
00–99 Date %D mm/dd/yy 07/4/11 %x locale's date representation (mm/dd/yy) 07/4/2011 %F %Y-%m-%d 2011-07-4 Hours %l (Lowercase L) hour (12 hour clock) 1 %I (Uppercase I) hour (12 hour clock) zero padded 01 %k hour (24 hour clock) 13 %H hour (24 hour...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html
Interface” means an interface that either is an official standard defined by a recognized standards body, or, in the case of interfaces specified for a particular programming language, one that is widely used among developers working in that language....
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and CAP as the entity. (If your change spans different entities, just use the parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are included in the output or not. Select...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an access token used in OAuth2.0 for an API. How? All with deluge but we will split the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
\"...\" already exists."}. Documentation advises that the payload is empty which is not true in my case. This is my invokeUrl: v_DataEndpoint = "https://inventory.zoho.com/api/v1/items?organization_id=123456789"; r_Response = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
You can then use the following snippet to get all the fields for the module. In our case, for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line items. You may...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article so that I don't spend so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
eBay Order coming into the system via a webhook... I would like to mark a shipment as delivered only if the courier, in this case DHL, confirms the tracked order was delivered. How? So first I'll give some brief instructions on how to get an API key...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a file to be hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= 0; r_Users = zoho.crm.getRecords("users"); for each m_User in r_Users.get("users") { if(m_User.get("email").equalsIgnoreCase(zoho.loginuserid)) { v_LoggedInUserID = m_User.get("id"); } } // // create CRM zohosign document recipient m_CreateRecipient =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying tags on a contact record which needed to be copied to a deal record. I wanted to copy over the tag...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to 2 decimals but finance is so much more complicated. Why? Playing around with VAT / Tax, inclusive /exclusive, but in this case it is the rate that gets rounded. The numbers at the end still need to match what's in CRM and with ZohoBooks rounding...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF