Assuming lipman is required, the following 656 results were found.
What? This is a quick article to re-enable desktop notifications after having been prompted initially and having clicked on "Not Now". Why? I'm not sure when this prompt is supposed to prompt you again. A client of ours had accidentally clicked on "Not...
an email as evidence that the workflow was triggered and ran this function sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"Client Test: ZB: Payment Received for Invoice " + v_InvoiceRef message :"Workflow was executed and function...
What? This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on...
What? A noteworthy article in my opinion on how to send a CRM quote record using a template the customer created from a button. Why? Yes you can do this already by going to the record, clicking on the ellipsis or three horizontal dots button in the top...
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: " + v_DocumentId message :"Please find attached your requested...
What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on...
What? 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...
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 deals against a deal owner and needed to repeat this for all the...
What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the...
/ limited list). Do note that the images below were generated using MidJourney v4: Type of Photography {module title="Joel Lipman's List of MidJourney Photography Types"} Nature Photography Aerial Photography Astrophotography Cityscape Photography...
Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert,...
What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA....
What? A really quick article on how to hide these using CSS... at least until Zoho have this as a setting using the GUI. Why? Our use-case is that we have a subform which gets autopopulated with a list of services. The client does not want their...
What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code...
What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What...
Zoho order, but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl [ url:...
What? A quick article on the SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, but there is a Zoho Toolkit to run some checks on the...
What? 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...
What? This is an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using...
What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, 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....