Assuming works is required, the following 81 results were found.
-
other requests with these dates, we're going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a month in one go - increase the submonth/addmonth parameter if an employee can book...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
for testing but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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-in to your ZohoCRM Create a Connection Go to Setup > Developer Space...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
The solution: The long answer/investigation is getting a JSON response with a zoho.crm.getRecordByID() with a quote that works and a quote that doesn't Comparing both records JSON and finding the $converted system field is different. Checking the Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works (tested with both the keyword 'distinct' and without it with no difference in the response): // // build up COQL query...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use the .addDay(), check none of these are a Sunday, and move the next few...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ "-" + r_LeadDetails.get("Created_Time").subString(8,10); // // parse date into yyyy-MM-dd (using toString - often works) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").toString("yyyy-MM-dd"); // // parse time into HH:mm:ss v_LeadCreatedTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
own delivery drivers and want them to mark a sales order & package as shipped and delivered. How? Here's a code snippet that works for me. It is triggered when a user ticks a decision box in Zoho Creator (on iPad displays as an on/off switch). My...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
initial GraphQL query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The GraphQL The key value to retrieve is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a risk that the removeAll() command would remove every customer from the "all" list. That didn't happen so the above code works at time of print. Things can change though and if the function is changed to remove every instance of the "distinct" list,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
period/dot character... Some might suggest it's an authorization error but if you do a getRecordById and it works then the connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
url :v_Endpoint type :POST parameters: m_Params content-type: "multipart/form-data" connection:"zcreator" ]; // // this also works r_Upload = invokeurl [ url :v_Endpoint type :POST files: f_TestFile connection:"zcreator" ]; info r_Upload; } }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to get a single event record by its record ID. Note that this isn't in the official documentation but at time of print, this works: // // get event record by ID v_EndpointEvent = v_BaseURL + "/restapi/portal/" + v_PortalID + "/projects/" + v_ProjectID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
m_ZBooks_LineItem.put("rate",v_ListPrice.toString().replaceAll("^(\d+\.\d{2})\d*$", "$1", false)); Works a treat at truncating but still does NOT match how ZohoBooks does it. ZohoBooks rounds the .545 to .55 and .544 to .54... so let's abandon the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Select the profile(s) that will have access to this button and click on Save Go to a CRM account record and test the button works. Go back to your Zoho CRM function and simply include HTML and CSS in the output of the function... done. What we're here...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
*/ // // -------------------------------------------------------------------- // using Analytics API v1.0 (suprisingly still works in September 2025) /* v_OwnerEmail = ""; v_WorkspaceName = "Zoho CRM Reports"; v_ViewName = "ZohoSurveys - Spider Chart";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
longer or subject to change. l_Items = {"a" , "b" , "c" , "d" , "e" , "f"}; info l_Items.get(3); // yields "d" This approach works well for reference lists, configuration values, or ordered datasets where readability during development is helpful. 3)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to a system URL My site has been switched to SEF in the global configuration (where all SEO settings are set to "Yes") and works fine irrespectively. In time, if I ever learn to use it properly, I may change my opinion but why complicate things...?
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *