Assuming take is required, the following 76 results were found.
-
if that isn't populated then the first estimate, sales order, invoice created by someone in relation to that customer; else take the sales person against the record: SELECT DISTINCT c."Customer ID" AS "Customer ID", c."Customer Name" AS "Customer Name",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
include:spf.protection.outlook.com include:one.zoho.eu ~all Check using the toolkit: Some registrars will say this can take between 24 to 72 hours to propagate. In our cases, a working example can return within the hour as authenticated. Use the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Universal Time) should be zero, then for checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the day counting starts at 7, followed by 1 for Monday, 2 for Tuesday, and so on... How? The logic behind this would be to take the date of the order, check if the order date is a Sunday, subtract a day, and return the week number: c_Order = Order[ID ==...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
******************************************************************************* */ // // Go create a folder in workdrive, take the last hash string after the word /folders/ in the URL: v_TargetFolder =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
order ID" LEFT JOIN "Sales Order Items" soi ON so."Sales order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales Order which was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the button was). Why? If anyone has the envious task of sending a document out for signing by a customer, you will know this takes a while to do: You have to find the contact record in CRM for example Click on "Send for Zoho Sign" Select the template...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Both aren't required but at least one should be. How? We can do this without code and only using ZohoCRM layout rules. Let's take a contact record for demo purposes: If I enter a phone number: If I enter an email: And then let's specify a couple of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
color picker at some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of rounding which differs to Zoho Books so when pushing an invoice, there's a strong chance of being a cent/penny off. Let's take the following example of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
Frontpage Item Orderinghttp://mail.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect. To set them, do this in your Joomla! Admin Panel (back-end). Choose Menu > Main Menu from the pulldown menus. Click on the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution Explorer Go to File » Source Control » Go Online The "Go...
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
How? You could buy an SEF extension that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF