Search - Joel Lipman .Com

1. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a ...; Created on 25 March 2024
2. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products ...; Created on 13 December 2023
3. Zoho CRM: Change System Field Length: / Zoho /; What? This is an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead ...; Created on 19 June 2023
4. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; What? A super quick article on how to download an attachment from CRM and upload to a "file upload" field in Creator. Why? My use case here is that we are creating a Creator app that will show ...; Created on 11 March 2022
5. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want ...; Created on 11 November 2021
6. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called Portal_Listing_Report and I have a publish key ...; Created on 17 October 2021
7. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
8. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... have workflows triggered from many deltas/changes. Why? Some clients have referred to this as the "spinning circle of death": they load up a Creator application or change a field and there will be ...; Created on 19 September 2021
9. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... + v_CreatorTime.toString("Z").subString(3); info v_CrmTime; // yields 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard ...; Created on 10 September 2021
10. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; What? A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" ...; Created on 01 September 2021
11. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; What? This is a quick article to help anyone encountering this gotcha: I have an integration field, if someone changes it, I want to save the value to the record immediately. Why? If you try to ...; Created on 27 July 2021
12. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; ... Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, ...; Created on 26 July 2021
13. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; What? A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather ...; Created on 17 June 2021
14. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
15. 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
16. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; What? This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went ...; Created on 02 February 2021
17. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... = Map(); // for each r_Record in l_MyListUnsorted { // field we want to sort by v_SortingKey = ifnull(r_Record.get("date"),""); if(!isNull(v_SortingKey)) { // as this is a date from CRM (atomic ...; Created on 29 January 2021
18. SITS: Export field code and name: / Extensible Markup Language /; ... country of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the exchange fields (or container) to apply this to Select the "Export Format" tab and click on the chevrons ...; Created on 12 August 2014
19. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... for Joomla article selection. How? We have to create a custom form field type. In the following example, I'm going to create a dropdown which selects all projects associated with a particular user. ...; Created on 25 October 2013
20. Inline Labels in Form Fields using Javascript: / JavaScript /; What? This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value ...; Created on 21 August 2012