Search - Joel Lipman .Com

1. Report Builder 2.0 - Hide Series1: / SQL Server Reporting Services /; ... Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident ...; Created on 06 May 2010
2. If Then Else in Report Builder 2.0 Expressions: / SQL Server Reporting Services /; Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm ...; Created on 06 May 2010
3. SSRS Report Builder 2.0 - Error during processing: / SQL Server Reporting Services /; The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred ...; Created on 06 May 2010
4. Uninstalling AEC Central and installing Community Builder: / Joomla /; ... but Community Builder provides more options for your website members. If Joomlapolis ever complete the CB Subscription component then there is no need for AEC anymore. For this we're basically going to ...; Created on 20 January 2010
5. Community Builder in Joomla Vulnerability: / Joomla /; ... that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder (v1.2) and Joomla (v1.0.14) then you're vulnerable to a hack. Watch for users signing ...; Created on 10 November 2009
6. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetItemTransactions Documentation: https://developer.ebay.com/devzone/xml/docs/Reference/eBay/GetItemTransactions.html ...; Created on 22 January 2022
7. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an order ...; Created on 21 January 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... if(v_CrmContactID != 0) { // parse and build up CRM record update here } else { // parse and build up CRM record creation here } } } } } els ...; Created on 10 January 2022
9. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... = "This is a test text"; // // build up the endpoint (see https://www.twilio.com/docs/usage/requests-to-twilio#http-methods for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token ...; Created on 16 December 2021
10. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. ...; Created on 15 December 2021
11. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = ...; Created on 02 December 2021
12. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... build map to schedule a call m_ScheduleCall = Map(); m_ScheduleCall.put("$se_module","Leads"); m_ScheduleCall.put("Owner",v_LeadOwnerID); m_ScheduleCall.put("What_Id",v_LeadID); m_ScheduleCall.put("Subject","Scheduled ...; Created on 18 November 2021
13. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... :v_ImageSrc type :GET ]; r_DownloadPhoto.setParamName("file"); v_EncodedImg = zoho.encryption.base64Encode(r_DownloadPhoto); // // build shopify request m_Params = Map(); m_SubParams ...; Created on 17 October 2021
14. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html ...; Created on 13 October 2021
15. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build ...; Created on 08 October 2021
16. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = zoho.crm.getRecordById("Sales_Orders", 012345678901234567); // build up your map to send to ZohoBooks to create the Sales Order m_BooksCreateSO.put("date",zoho.currentdate); // // push to ZohoBooks r_CreateSO ...; Created on 22 September 2021
17. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... - Initial release More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetNotificationPreferences ...; Created on 20 September 2021
18. 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
19. Zoho Creator: Add a subform while creating a record: / Zoho /; What? This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create ...; Created on 14 July 2021
20. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // // build up product details JSON to send m_LineItemProduct = Map(); m_LineItemProduct.put("id",v_CrmProductID); m_LineItem ...; Created on 17 May 2021