Search - Joel Lipman .Com

1. Regular Expression Basic Usage Examples: / Web-Development /; What? A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the ...; Created on 28 October 2013
2. JDatabase: using the Joomla database with examples: / Joomla /; ... don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x This article applies to Joomla 1.5.x, 2.5.x and 3.x. for Joomla 2.5.x Building ...; Created on 27 January 2013
3. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different, ...; Created on 10 October 2012
4. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks Source(s): ZohoCRM: ...; Created on 04 May 2023
5. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; 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 ...; Created on 20 March 2023
6. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... on your CSS with regard to referring to elements by ID, so for example, if my subform is called "Item Details", then I would adjust the code to something like the following: // // CSS overrides v_CssNotes ...; Created on 28 February 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... then press So to use these now, simply append 2 hyphens/dashes and the name of your custom parameter, for example: /imagine a beautiful face --portrait Effects So I can now build a ...; Created on 11 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation ...; Created on 16 January 2023
9. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... Another example of looping through a subform In the following snippet of code, we are going to loop through a subform called "Skillset" which has a column called "Skill" which is a lookup to ...; Created on 09 December 2022
10. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... uploads 1 photo. Error(s) Encountered The endpoint is wrong (for example you don't need the organization ID parameter at the end of the URL) The .setParamName() function is setting the data ...; Created on 21 June 2022
11. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the user to be able to click and download/open ...; Created on 11 March 2022
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... displayed here for testing purposes: the starting date, and then based on the offset, the selected date. The first bit of this snippet creates a map which for this example would be . This means that ...; Created on 09 March 2022
13. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... (in this example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call ...; Created on 02 March 2022
14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up with something like this screenshot: * Some of these fields are unnecessary for this example but are used to accommodate ...; Created on 14 February 2022
15. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... I'm using it so I'm documenting it. For this example, we're going to use my use-case scenario mentioned earlier: first-line agents can't select a specific option in the Lead Status picklist: Login ...; Created on 11 February 2022
16. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... don't have this see alternative steps below on "Inspect page Elements in Chrome"). In the Developer Tools Inspection Window for Elements, make the changes to your box using your HTML knowledge (in my example, ...; Created on 25 January 2022
17. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy): You will then be shown a summary of your import: You can then ...; Created on 12 January 2022
18. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... you will need to consider using a third-party server (my example here is a LAMP server): Complete webhook setup by passing 'Intent to receive' required stage. Xero will test both a valid and invali ...; Created on 10 January 2022
19. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... the appointment example mentioned above for a customer in UTC+1 @ 4pm their time. The server is on Eastern time UTC-5 and the agent is in Los Angeles UTC-8. For this first example, we're not bother wit ...; Created on 07 December 2021
20. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... and attach the file. First Create a CRM connection I'm going to create a Zoho OAuth connection with open scopes just to get a working example; I can then reduce the scopes permissions afterwards ...; Created on 21 October 2021