Search - Joel Lipman .Com

1. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...; Created on 19 July 2011
2. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... the URL text. In this example, we are using images uploaded in the Zoho Analytics image library but you would need images either uploaded in Analytics or a publicly accessible image without a user wall. ...; Created on 25 July 2024
3. Zoho Projects: Get All Events: / Zoho /; ... the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. ...; Created on 22 July 2024
4. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... = v_Message + "No Datasource Information! Either the data source synchronization has been switched off or there is an error with a connection account between Zoho People and Zoho Analytics. "; } v_Message ...; Created on 02 July 2024
5. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... span.year').text(currentYear); Error(s) Encountered: Error Status 401 Code 1030: Authorization Failure. The access token is either invalid or has expired. Please check your Zoho Accoun ...; Created on 14 March 2024
6. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... so that I get the popup to enable bi-directional rather than via the tickbox. The below code is added to a trigger whenever the ticket form is submitted either on creation or modification. The ...; Created on 26 January 2024
7. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... file permanently. You only need to run either of these as the second one runs both (disassociate and delete): // disassociate as attachment (removes attachment from the Bill but keep in ZohoBooks documents) r_Detach ...; Created on 02 October 2023
8. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include ...; Created on 18 September 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... to not adjust stock level if item has enough quantity then that purchased - Adds tracking number and carrier to shipment record on either creation or modification. - Only creates shipment order ...; Created on 27 April 2023
10. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
11. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets ...; Created on 28 February 2023
12. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... however is that it is connected to the Internet unlike ChatGPT which only has information up to 2021. How? The basics of setting this up would be to setup a bot in ZohoCliq and then to edit either ...; Created on 13 February 2023
13. ZohoCRM: Import Attachments: / Zoho /; ... is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation ...; Created on 16 January 2023
14. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... = r_CreateShipment.get("shipment_order").get("shipment_id"); } } } // // maybe one is either used or created if(v_ShipmentID != "") { v_Url = "https://inventory.zoho.com/api/v1/shipmentorders/" ...; Created on 14 July 2022
15. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... supports it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't work, then I found you need to do an extra step in ...; Created on 12 March 2022
16. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... if your search query string has spaces in it, the above without the small apostrophes (single-quotes) will return either a parsing error or just no data. In the line: v_GraphQl = " product } } } }" Change ...; Created on 14 February 2022
17. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status ...; Created on 11 February 2022
18. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... to change by going to Settings > Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address Format either under "Customers and Vendors" (although this applies ...; Created on 07 October 2021
19. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... Shipping Address... But let's say I don't know how to create a shipping address and retrieve its ID then here's the method I use:Create the sales order in ZohoBooks (either in Zoho Deluge or however you'r ...; Created on 22 September 2021
20. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... The example below is that we are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been simplified and will ...; Created on 30 July 2021