Search - Joel Lipman .Com

1. Zoho Creator: Input Color Picker: / Zoho /; ... radio options to the left to be horizontal rather than vertical v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-cell"; v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-row"; // first ...; Created on 14 October 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Then click on the API switch to enable it and copy the resulting URL to your clipboard Now login to ZohoSign In the left sidebar, go to > Settings > Developer Settings > Webhooks Copy and past ...; Created on 06 August 2024
3. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info ...; Created on 31 July 2024
4. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 5), 'Data Warn', 'Data Failed' ) ) AS "Status" FROM "Accounts" acc ) AS t1 LEFT JOIN "Joels Image Library" img ON t1."Statu ...; Created on 25 July 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... to Zoho Analytics, and choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select ...; Created on 09 July 2024
6. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... bottom; border-bottom: 1px solid #eee; } #my-line-items thead tr th:first-child{ width: 50%; text-align:left; } #my-line-items tbody tr td img{ width: 75px; height: auto; max-height: ...; Created on 07 May 2024
7. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... and a consumer_secret. Login to the administrator's section of the Wordpress website (mysite.com/wp-admin) Expand WooCommerce in the left sidebar Go to Settings (in the menu/sidebar) > Advanced (tab) ...; Created on 15 April 2024
8. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create ...; Created on 05 December 2023
9. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... or Access You should be in "My Folders" (left sidebar) Create a folder, I'm calling mine "Email Signature Images" Within that folder, create another folder called "_Global". At the same level, create ...; Created on 05 December 2023
10. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Department: / Zoho /; ... icon (top-right most) to edit any profile On the user's dialog/popup in the bottom left, there will be a link saying "Manage Fields" Add a picklist field type called "Department" with the options "Hir ...; Created on 16 October 2023
11. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... list of unique ones from the "all" list to be left with just the duplicates. The Code v_CountDiscrepancies = 0; // l_Customers1 = Customer[ID != 0].distinct(Customer_Name); l_Customers2 = ...; Created on 12 July 2023
12. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... = v_ThisCurrentWeekNumber.leftPad(2).replaceAll(" ", "0", true); // // or // v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("ww"); // // ...; Created on 06 July 2023
13. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023
14. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
15. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... a list based on the number of days ago (list of dates to check) l_GeneratedList = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // ...; Created on 21 March 2023
16. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign 1", cp."Campaign 2", cp."Campaign 3" FROM "Contacts" c LEFT JOIN "Contacts vs Campaigns ...; Created on 20 March 2023
17. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... output return m_Response; click on "Save Script" Test using the sidebar on the right Click on "Done" when satisfied. Click on the left arrow/caret to return to the ZohoCRM ZIA main page Clic ...; Created on 06 March 2023
18. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = 1500; // // now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ...; Created on 01 March 2023
19. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other ...; Created on 11 February 2023
20. ZohoCRM: Import Attachments: / Zoho /; ... the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately will display a notification saying your migration is ...; Created on 16 January 2023