Search - Joel Lipman .Com

41. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; What? So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. ...; Created on 11 February 2022
42. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... yields 12 Additional Note(s): You might ask why not use the built-in round() function? Well I admit that round() needs to be used for currencies. The issue is that round() only rounds up decimals ...; Created on 08 February 2022
43. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
44. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one ...; Created on 10 January 2022
45. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; What? A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both ...; Created on 16 December 2021
46. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use ...; Created on 07 December 2021
47. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... 01-Nov-21 // Tuesday 02-Nov-21 Note that Sunday is day 1 of the week. Saturday is day 7 of the week. Here's the English ordinal bit I used: m_Ordinals = ; v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); ...; Created on 02 November 2021
48. Zoho Creator: Change Radio into Tabs: / Zoho /; ... Deluge Script: // assuming my sections are called "Tab_Section_1", and so on ... [these can be named as you want, the names I've used here are for demo purposes] hide Tab_Section_1; hide Tab_Section_2; hide ...; Created on 22 October 2021
49. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
50. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey + "/" + v_Filename; URL Syntax #4 The following won't work for the example below as it doesn't have the publish/public key, but it can be used internally: // DOESN'T WORK ...; Created on 17 October 2021
51. Homepage (default): Created on 10 January 2018
52. Header (Flex): Created on 30 December 2017
53. Header (Adspace): Created on 17 April 2017
54. Feature Box: Created on 08 October 2015
55. Form Builder: Created on 30 November -0001
56. Image Layouts: Created on 30 November -0001