... :GET
connection:"joels_connector"
];
if(!isnull(r_Response.get("fields")))
{
// loop through every field to find the customer's timezone one
for each r_Field in r_Response.get("fields")
{
if(r_Field.get("api_name") ...
... when locking it down for security:
Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth
Give your connection a name, I'm calling mine "Joels Connector"
Select the Scopes: ZohoWriter.documentEditor.ALL ...
... $
$
and in my Sales Order:
BILLING ADDRESS SHIPPING ADDRESS
------------------- -------------------
Test Company Joels PO Box
1 Test Street 1 Different Street
Test ...
... photo to CRM:
// init
v_AppOwner = "joel_the_awesomest";
v_AppName = "joels_app";
v_ReportName = "My_Report";
// specify your CRM record ID for this product
v_CrmProductID = 1234567890123456789;
// ...
... = 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 ...
... Update"]
JSON Payload [Multi Line]
2. Joel's first Cheat: If your client has ZohoCRM, let's use a CRM REST Function
Granted this only works if you have a CRM connected to your Zoho Creator:
Log-i ...
What?
A super quick article to demonstrate an example where we create a project with custom fields.
Why?
At time of print, the documentation on the Projects API would only show responses rather ...
... > Connections)
Click on "Add Connection" and click on "Zoho OAuth"
Give a lower connection name, eg. "joels_connector"
Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ):
...
... creating a record in a module that contains a lookup
m_Create = Map();
m_Create.put("Name","Joels Amazing Test");
r_Create = zoho.crm.createRecord("Tests", m_Create);
// now take the ID that was created ...
...
zet init
You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key.
Give the project a name: eg. “joels_awesome_app” (without ...
What?
So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page.
Why?
There might be different articles out there and discussion ...
... As Range
Dim xRow As Range
Dim SplitRow As Integer
Dim xWs As Worksheet
On Error Resume Next
xTitleId = "JoelsTooCoolForExcel"
Set WorkRng = Application.Selection
Set ...
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.