Assuming well is required, the following 158 results were found.
-
Replace all commas in between a pair of double-quotes: Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample data. If you are expecting a 3rd comma in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the CRM Invoice module. How? Therein lies the reason. For the quote conversion mapping, it needs the CRM Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
have 1 eTag which combines all input fields into 1 MD5 or hash. Do you need to add a comparing if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
(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 if you don't want to sit on a call with eBay. If you use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
because the IDs of each quote record are different. Having spoken to Zoho and raised with the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
output info "[" + l_ProductIDs + "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers delimited by a comma. However, to match my use-case, I want a list to which I can give it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
not expired). Thereafter, I use the GetMyeBaySelling API Call with specific criteria to only return the active listings as well as specific fields so my function doesn't get overwhelmed with the amount of data in the response: map...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
}, "message": "invalid data", "status": "error" } How? We're going to parse the created date and time parts as well as the timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to cover all aspects of this, I create a Zoho Creator form with the timezone names, their offset and their DST offset as well as a boolean to say whether Daylight Savings Time is in effect for this timezone or not. So let's pretend we have a creator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
agent would be referring to 2 status fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time I'm using it so I'm...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 snippet for a Zoho Creator page. We set the parameters of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Instead, all we want is the URL of an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record. Well I don't want to research this often so here's the quick parsing instruction to get the eBay photos; this snippet stores the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_Attach = zoho.crm.attachFile("Deals",v_DealID,r_File); info r_Attach; // // to send this as an email as well sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"ZohoSign Test - Request: " + v_RequestId + " - Document: " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
) GROUP BY invitm."Item ID", invitm."Quantity" And lastly we can group by invoices in the month and sum up the profits as well as include the customer name and other invoice references for the client's report: SELECT MAX(invsopoitm."Invoice Date") AS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the client script...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 "cursor"; we're also going to use "hasNextPage"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So at time of print, this is the only way I know: add a note field to inject some CSS into it and hide the delete icon as well as the "Add new row" link. In Design mode: Add a special field of type "Add Notes" to your form. I'm going to call it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use an access token...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *