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 ...
... 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 ...
What?
A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown.
Why?
Because I find myself doing ...
... and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every active product and list their IDs.
How?
So here' ...
... s if you don't want to sit on a call with eBay. If you use Oauth as above then contact eBay and ask them to enable it once you've run the above function. For me, I didn't have this patience and find it mo ...
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.