Search - Joel Lipman .Com

1. Zoho Creator: Populate a Multi-Lookup: / Zoho /; 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, ...; Created on 18 August 2022
2. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; What? This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module ...; Created on 28 April 2021
3. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; What? A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...; Created on 28 June 2019
4. SSIS Multiple Lookups in one: / SQL Server Integration Services /; What? A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" ...; Created on 05 August 2014
5. Country Lookup by IP address CSV: / MySQL /; ... Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to create ...; Created on 17 March 2013
6. Sync Outlook 2007 Shared Calendar with SharePoint 2007: / SharePoint /; ... other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you ...; Created on 09 November 2012
7. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that ...; Created on 04 November 2024
8. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
9. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... A custom field against the item record has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per line item, the staff can specify which Sales Order ...; Created on 09 July 2024
10. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics, ...; Created on 02 July 2024
11. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... with rowspans and the borders need to merge cells). But here we're simply going to use ZohoCreator and its PDF rendering options. What's wrong with just using CSS? It looks beautiful on ZohoCreator ...; Created on 07 May 2024
12. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... apps may create similar webhooks so you need to make sure the script below is looking for your custom webhook for each m_ThisWebhook in r_ShopifyWebhooks.get("webhooks") { if(m_ThisWebhook.get("id") ...; Created on 22 April 2024
13. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... the fault/description, and a subform to a form called "Documents" linked by a bi-directional ticket lookup. The document form is a subform derived from an existing form (called "Document"). Mainly, because ...; Created on 26 January 2024
14. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... in, not_equal, greater_equal, greater_than, less_equal, less_than and between. The supported data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, ...; Created on 14 November 2023
15. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year the week is in. Weeks which ...; Created on 06 July 2023
16. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... include:spf.mycompany.com include:spf.protection.outlook.com include:one.zoho.eu ~all Check using the toolkit: Some registrars will say this can take between 24 to 72 hours to propagate. In our ...; Created on 04 May 2023
17. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... void the invoice, delete the package and shipment. - Added chart of accounts lookup to set purchase account for an item: now ticks purchase information and track inventory. - Issue on create ...; Created on 27 April 2023
18. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; What? Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement ...; Created on 06 March 2023
19. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... you want an image of» Subject Attriutes This is just a list of ones where it actually followed the prompt (eg. Looking/Facing down made the subject look up???) Arms Up Contrapposto Cross-Legged ...; Created on 11 February 2023
20. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... CustomModule6: Candidate: Lookup to the Candidates module Job Opening: Lookup to the Job Opening module (called "Vacancies" in client's system) Candidate Ref: A single line text field Vacancy Ref: ...; Created on 08 February 2023