What?
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room.
The Problem?
When I select specifying the statement "WHERE IN (c.RoomImages)", ...
What?
A quick article to display a value in a column in a widget in Zoho Analytics.
Why?
Because I keep forgetting how to do it.
How?
I've done this for a query that amalgamated all the ...
... location, for that’s the email id you need to send files to for those to show up on your Kindle.
Getting your email ID approved
Just having your Kindle email address won’t suffice unless you ...
... How to Generate a Shopify Access Token (legacy)
Shopify Community - API To Search Products By SKU
Zoho Deluge: Push Item to Shopify API
Shopify .dev - Getting started with the GraphQL Admin and REST ...
... to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the page and check it out as well as the client to go in and confirm the change was ...
... to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand basic mapping and attachments. ...
... articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link.
...
... = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN");
m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id"));
//
// getting the last ID from the Shopify sort instead of making ...
...
Auth'n'auth (Authentication and Authorization) Process
Not getting notification via the URL but you are getting them via email? Well I read somewhere you need to use Auth'n'auth to enable these notifications ...
... stuff here ... eg getting data fields, generating a title and setting the title:
input.Title = "Hello World ";
//
// output
input.Note_Preview = input.Title;
//
// re-enable auto-update preview
input.Update_Preview=true;
To ...
... If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly?
How?
It may be that when obtaining a date string ...
... snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The ...
What?
This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists.
Why?
Because I keep forgetting ...
... searchRecords function requiring it's 5th parameter which defaults to "not converted" records:
=zoho.crm.searchRecords(,,,,,);
The solution:
The long answer/investigation is
getting a JSON response ...
What?
This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots.
Why?
This is for a Creator app which had a form ...
... to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the ...
... article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me.
How?
So here's an overview and then ...
... the domain joellipman.com.
Why?
This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties ...
What?
This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality.
Why?
Quite simply that at ...
... certain bits out. Just getting the syntax right and using the . setParamName is key.
Let's make it even more interesting: I'm going to use a subform with the file upload field type so our record can ...
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.