Search - Joel Lipman .Com

1. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; What? This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found ...; Created on 22 April 2024
2. CSS keeping the footer at the bottom: / Cascading Stylesheets /; Spent enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: ...; Created on 25 April 2011
3. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
4. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... receive and pass to the JS widget. the HTML You may note that I have additional CSS and JS files. I like to keep the copies local (especially if the hosting is included) so the app doesn't suddenly ...; Created on 14 March 2024
5. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... true which will automatically send it and mark it as sent. As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff ...; Created on 07 March 2024
6. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... mine "Extra Confidential" Keep Category=Module, set Page=Detail Page (Standard), set Module=Contacts and set the layout if you want. Under Event Details, set Type=Page Event; Event=onLoad Click on ...; Created on 06 February 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. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... " and it should popup with ...things you can ask me... with one being "Ask ChatGPT" Click on it and then ask away:... Keeping a Conversation So annoyingly, the variable broadcast was unreliab ...; Created on 06 March 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query: "updated_at:>'2023-02-20T00:00:00+0000'") ...; Created on 20 February 2023
10. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... } } The one to rule them all So I've been asked here and on the forums as well for the full query that includes making ChatGPT keep the context of the conversation along with new cliqs: / ...; Created on 13 February 2023
11. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... commands Stealth Mode To keep images private, send these as direct messages to the Midjourney Bot. Just bear in mind that any image in a prompt can be accessed if people work out the link. "Stealth" ...; Created on 11 February 2023
12. ZohoCRM: Import Attachments: / Zoho /; ... "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD b_KeepOpen := false v_RunFolder := A_ScriptDir "\Run_" v_YourDate "_" A_Hour "-" A_Min ; -------------------------------------------------------------------------------------- ; ...; Created on 16 January 2023
13. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows = ZDK.Apps.CRM.Deployment_Rate_Log.fetch(); ...; Created on 09 December 2022
14. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; What? A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the ...; Created on 24 October 2022
15. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Create an entry in our new form: Access this application so you are viewing the front-end of your Creator app and go to your recently created API Integration form (tip: keep this open while you ...; Created on 14 February 2022
16. Zoho CRM: searchRecords with sorted results: / Zoho /; ... listed here, the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep ...; Created on 10 February 2022
17. 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
18. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; What? A quick article to remind me on how to upload a photo using CRM API v2. Yes it's documented and yes it still confuses me now and again. So I'm writing this to remind me and to keep reminding me ...; Created on 27 September 2021
19. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... a spinning icon indicating that the field has triggered an automation/workflow but it keeps spinning and doesn't stop. The app page will ultimately timeout and when reloading the form it simply displays ...; Created on 19 September 2021
20. 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