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 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // your creator details v_ListingPublishKey = "AAAAABBBBBCCCCDDDDEEEFFFGGGGHHHIIIJJJKKLLLMMMNNOOOPPPQQWRRRSSTTUUVVWWXXYYZZ122345567890"; ...; Created on 17 October 2021
15. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho ...; Created on 13 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion ...; Created on 12 October 2021
17. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... US DC v_Endpoint = "https://books.zoho.eu/api/v3/salesorders/"+v_SalesOrderID+"/address/shipping?organization_id=" + v_BooksOrgID; // saw this in the documentation example so will hopefully do what ...; Created on 22 September 2021
18. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes field. We would rather only have to update the code for 1 workflow rather than 20 workflows ...; Created on 19 September 2021
19. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subString(0,3) + ":" ...; Created on 10 September 2021
20. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... and updates the Opportunity/Deal/Potential record. In this example, the custom field is called "Division": // // init v_DealID = ifnull(p_DealID,0); r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID); // // ...; Created on 01 September 2021