Search - Joel Lipman .Com

1. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; What? A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have ...; Created on 09 July 2024
2. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
3. Delete related records from multiple tables: / MySQL /; ... another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE ...; Created on 11 January 2013
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ssage :v_DebugMessage ] } return ""; Related List for Custom Module Just for good measure (and because it took me an hour to write this), here's the code to generate a related list on a custom ...; Created on 06 August 2024
5. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... tasks that were transferred from the lead record relating to reminding staff to convert the lead. // l_RelatedTasks = zoho.crm.getRelatedRecords("Tasks", "Contacts", p_ContactID); for each m_RelatedTask ...; Created on 14 May 2024
6. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... setup involves creating the TXT records on the DNS. Ideally, we would not want access to the DNS as Zoho Support as we could be blamed for any website / mail server issues not related to any of this setup ...; Created on 04 May 2023
7. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... v_RateCard = ZDK.Page.getField('Which_rate_card_is_this_based_off').getValue(); // get opportunity lookup (related deal) of this record let r_DealLookup = ZDK.Page.getField('Opportunity_Name').getValue(); ...; Created on 09 December 2022
8. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... the Device Summary Under Device Summary, you will be shown a host of information related to your device, which includes the email address associated to your Kindle. Copy and save the email at your desired ...; Created on 29 June 2022
9. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = zoho.crm.getRelatedRecords("Attachments","Contacts",v_CrmContactID,1,200,m_SortCriteria); for each r_Attachment in l_Attachments { if(r_Attachment.get("id") != null) { v_AttachmentEndpoint = "https://www.zohoapis.com/crm/v2/Contacts/" ...; Created on 11 March 2022
10. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... day meeting m_ScheduleMeeting.put("All_day",false); // // meeting owner/host ID (can see any record related to this meeting) m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what ...; Created on 02 March 2022
11. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the ...; Created on 29 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 Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... = r_Workspace.get("name"); } } Get the services: // // get services r_ServiceResults = zoho.bookings.getRelatedRecords("Services","Workspaces",v_WorkspaceID,"joels_connector"); l_Services = ...; Created on 23 June 2021
14. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... can be workflow, approval, or blueprint. If trigger is not mentioned, the workflows, approvals, and blueprints related to the API will get executed. Enter the trigger value as [] to not execute the workflows. ...; Created on 16 June 2021
15. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... to all related systems such as Zoho Projects and the originating app (in this example, Zoho Creator). 1. Setup up Zoho Oauth Connection: Go to connections (in creator this is icon in top-left > Setup ...; Created on 30 April 2021
16. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... "delete_Url": "/crm/org12345678901/deleteattachment.do?attachmentid=234567890123456789&module=CustomModule1&id=125878000002717078&creatorId=987654321098765432&fromFileUploadField=true&nextStep=relatedlist&isajax=true&fieldId=123456789012345678&fromPage=edit", ...; Created on 02 February 2021
17. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
18. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: multipart/related; boundary=joes_awesome_divider', ...; Created on 29 October 2018
19. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... 2.0.1 - Code Overhaul: Use J16 core Mootools - Code Overhaul: Removed all CSS Popup related parameters - Parameter: Hits Prefix Text in popup - Parameter: Date Prefix Text in popup - Parameter: ...; Created on 07 September 2015
20. Android: Keytool and Google Maps displaying grey: / AndroidOS /; ... just that downloading from the Play store was unrelated to the above. Additional: If you forget your key (like I did) and which keystore file you used, then you'll have probably tried this: Upload ...; Created on 31 October 2014