What?
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
What?
Quick note on how to do this.
I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters.
How? ...
What?
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code.
Why?
I ...
The Why
So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) ...
This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to ...
What?
An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system.
Why? ...
What?
This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...
... print (6 June 2022) and I wanted to make sure it didn't just disappear or be difficult to find in future.
How?
The process of sending a PDF file to your Kindle device is also quite straightforward. ...
... for
Select the Server Type and then click on "Download Zip File" button
Decompress the ZIP and find the CRT file
Return to your GoDaddy page and scroll down to "Web Hosting" then click ...
What?
This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS).
Why?
Because I couldn't find any other article in the whole world ...
... in a different CSS color, and which date to enter into the Selected_Date field:
// creating map for offset (determine which CSS box was selected)
m_Offset = Map();
v_StartDate = input.Starting_Date;
v_RefIndex ...
... time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me.
How? ...
... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10.
How?
Two methods ...
... > Select the template with this issue
Click on the "Edit HTML" icon in the top right of the editor:
Find the code "page-break-inside"
Change this from "avoid" to "auto":
And optionally, ...
... Tools"
Caveats
Only make the changes necessary to how you like it. You will find issues with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the day ...
... find the invoice in CRM
v_CrmInvoiceID = 0;
l_SearchCrmByXeroID = zoho.crm.searchRecords("Invoices","Xero_Ref_ID:equals:" + v_Xero_ResourceID);
for each r_Result1 in l_SearchCrmByXeroID
{
if(!isnull(r_Result1.get("id")))
{
v_CrmInvoiceI ...
... + l_Params.toString("&"));
//
// if we got a response from the third-party API, let's go through the CRM picklist options to find the relevant one
if(!isnull(r_Timezone.get("zoneName")))
{
v_TimeZone ...
What?
This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge.
Why?
Because I find a need to document anything that takes longer than 30 minutes to ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.