Search - Joel Lipman .Com

1. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...; Created on 02 December 2021
2. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; What? A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho ...; Created on 21 September 2021
3. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex ...; Created on 04 May 2020
4. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
5. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...; Created on 27 April 2012
6. T-SQL DateTimestamps: / Transact-SQL /; ... CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 10/11/11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 11.10.11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 11/10/11 CONVERT(CHAR(8), ...; Created on 23 March 2011
7. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... a timestamped duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home//teams//ws//folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url :"https://www.zohoapis.com/workdrive/api/v1/teamfolders//folders?page%5Blimit%5D=50&page%5Boffset%5D=0" type ...; Created on 11 September 2024
8. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... = Map(); // sometimes parameters need to be a string... but this is working m_Config.put("CONFIG",m_Params); v_Endpoint = "https://analyticsapi.zoho.eu/restapi/v2/workspaces/" + v_ZA_WorkspaceID + "/views/" ...; Created on 09 July 2024
9. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets ...; Created on 22 April 2024
10. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... pages, so including the above plus some calculation to work out how many times to loop should retrieve every thing: // // initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts ...; Created on 15 April 2024
11. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...; Created on 13 December 2023
12. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = Map(); l_DaysCorrectOrder = m_OrgDetails.get("business_days"); for each v_Day in l_DaysCorrectOrder { m_ShiftBuildUp.put(v_Day, m_ShiftRow); } // // ok let's get the opening times if(m_OrgDetails.get("custom_timing" ...; Created on 28 March 2023
13. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename ...; Created on 01 March 2023
14. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
15. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than ...; Created on 20 February 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; What? So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct ...; Created on 11 February 2023
17. ZohoCRM: Import Attachments: / Zoho /; ... the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately will display a notification saying your migration is ...; Created on 16 January 2023
18. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... you may want to use the out-of-the-box modules instead: Sometimes, a salesperson or user might be generating an invoice on behalf of the account manager (person who manages the customer's account), so ...; Created on 03 November 2022
19. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string ...; Created on 21 October 2022
20. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers needed to know what card they had paid with (if paid by card). The customer wanted payment method ...; Created on 17 August 2022