... (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example:
SELECT
Date,
Reservation,
Contact, ...
The Issue
You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data.
Solution
I've seen a lot of people write CGI requests but ...
... for myself is as follows:
Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true
Popup a confirmation box to proceed or cancel.
Popup the email from CRM mailer ...
... ~all
ZohoCRM: Get IT to do the DKIM
The following are steps as to what to add in the TXT record. How to add the TXT record itself will depend on your mail server or the domain registrar's website ...
...
What I have
Me,Myself,I\na,b,c
What I want
Me,Myself,I
a,b,c
How?
So in this article I just want to list some various methods of inserting a new line character.
Works on most ...
... the modified records of a day and ensure that the data in Zoho is the same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself:
void ...
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? ...
... admin account)
Log in to https://accounts.zoho.com/developerconsole
Click on Add Client ID
Select "Self Client"
Provide the details and register your application
Upon successful authentication, ...
What?
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page.
Why?
Cos
How?
The below is a template ...
What?
An article to remind me how to install an SSL certificate with GoDaddy.
Why?
A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing ...
... which in turn generates an order in Shopify. This article is primarily for myself as I need to do this for some other clients and I just want to continuously refine and improve my code below.
How? ...
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 ...
... = zoho.creator.createRecord(v_AppOwner,v_AppName,v_FormName,m_CreateRecord,m_Blank,"joels_connector");
/*
// Email yourself as a test but remember to remove this before going Live.
sendmail
[
fro ...
What?
This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...
What?
A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). ...
... data.
And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and ...
... as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice.
Why?
I needed a command ...
... was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my ...
... is a function I find myself using more and more called equalsIgnoreCase() which could be used:
...
l_ProductDetails = Product[Product_Name.equalsIgnoreCase(v_Name)];
...
Other Functions of ...
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.