Assuming long is required, the following 76 results were found.
-
v_XeroTime.indexOf("+", v_StartIndex); v_UnixSeconds = v_XeroTime.subString(v_StartIndex, v_EndIndex); info v_UnixSeconds.toLong().toTime(); // yields 15-Apr-2020 17:00:00 Chained v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Download nodejs source code from https://nodejs.org/en/download/. Don't worry about knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through the installation process with the final...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
What I want: First Name Last Name ID Joel Lipman 1 Another Person 2 How? This is a bit of a dirty solution and as long as "id" is not your first column (because "id" can be found in names like "David") it will work. Assume a Map specified in deluge:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
but at this point I couldn't be asked). Then publish the report of this form (eg. "Download File Report") and get the long publish key it returns you. eg. https://creatorapp.zohopublic.eu + zoho.appuri +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 with a zoho.crm.getRecordByID() with a quote that works and a quote that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the Module Layout and drag a "Checkbox" field on to the module We'll call ours "Processed" but it really doesn't matter as long as it's a field to update In your code, sort a list by "Modified_Time", loop through and update each iterated record. (see...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to be exact: v_FormattedData = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // sample data v_Test =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article so that I don't spend so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Generated"; r_Api.Access_Token=r_eBayResponse.get("access_token"); v_AccessSeconds = r_eBayResponse.get("expires_in").toLong(); r_Api.Access_Token_Expiry=zoho.currenttime.addSeconds(v_AccessSeconds); v_Output = r_Api.Access_Token; } } else { //info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"active" } ] } */ You need to select the id of the template that you want to use for the next step (will be an alphanumeric long string). The button function Create a button off the contacts record by going to ZohoCRM > Setup > Customization > Modules...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
but would need adapting to match the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the top to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
items as per my screenshot here: How? This has been raised a few times by multiple clients but the fix is rather quick as long as you can get to the HTML of the template: Login to ZohoCRM > Setup > Customization > Templates > Inventory > Select the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
at: Instead, could they have 10% to display instead of 10.00%, and display 12.5% instead of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for each file with the filename appended. Because of MS Windows 11 limitations (any MS OS really), you need to ensure that long hyphens (#151) and some other funny characters are replaced out as the OS won't allow the file to be sent to a compressed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *