Search - Joel Lipman .Com

1. 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
2. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
3. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without ...; Created on 25 January 2016
4. Two icons created on Android: / AndroidOS /; What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. ...; Created on 20 October 2014
5. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013
6. Create Read-Only Database User in SQL Server: / Databases /; The following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security ...; Created on 09 November 2010
7. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: ...; Created on 22 January 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: m_Payload = crmAPIRequest; // change ...; Created on 10 January 2022
9. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... off a scheduled workflow of a call/meeting Login to ZohoCRM > Setup > Automation > Workflow Rules > Create Rule Module is "Calls" Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS ...; Created on 16 December 2021
10. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Additional: Daylight Savings Time Just to cover all aspects of this, I create a Zoho Creator form with the timezone names, their offset and their DST offset as well as a boolean to say whether ...; Created on 07 December 2021
11. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging ...; Created on 02 December 2021
12. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... = zoho.crm.createRecord("Calls", m_ScheduleCall); info r_ScheduleCall; Error(s) Encountered: ,"message":"invalid data","status":"error"} correct Call_Start_Time to CRM format of yyyy-MM-ddTHH:mm:ss-05:00 ...; Created on 18 November 2021
13. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... The form I have looks something like the following: and displays as something like this: The code I create a workflow that when the decision box "Copy Monday to the Other Days" is clicked it ...; Created on 17 November 2021
14. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... "expected_data_type": "datetime", "api_name": "Check_Date_Time" }, "message": "invalid data", "status": "error" } How? We're going to parse the created date and time parts as well as the ...; Created on 11 November 2021
15. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; What? A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next ...; Created on 02 November 2021
16. Zoho Creator: Change Radio into Tabs: / Zoho /; ... > Form Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is Created or Edited (Form Event) When to trigger ...; Created on 22 October 2021
17. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... How? As per our use-case above, we are going to create a button off the contact record which when the user clicks on it will generate a PDF of the merged template and attach it to the CRM contact ...; Created on 21 October 2021
18. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... "product_id": 9876543210987, "created_at": "2021-10-17T21:45:56+01:00", "updated_at": "2021-10-17T21:45:56+01:00", "src": "https://cdn.shopify.com/s/files/1/2345/6789/1234/products/aaaabbbbccccddddeeeeffff11112222.jpg?v=1234567890", ...; Created on 17 October 2021
19. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...; Created on 13 October 2021
20. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons ...; Created on 22 September 2021