Search - Joel Lipman .Com

1. 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
2. Zoho Books: System Values Maps: / Zoho /; ... Map fn_GetSystemValues() Trigger: Snippet to be used at beginning of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: ...; Created on 07 November 2023
3. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... in the hopes that your browser will just begin downloading it (failing this it will open up in the browser and staff member will need to be instructed on how to 'File > Save As...'): // // if successful if(r_Attachment.get("code") ...; Created on 02 October 2023
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Midjourney Bot on Discord YouTube: Glibatree: Mastering Midjourney in 2023 | The Ultimate Guide YouTube: Olivio Sarikas: MidJourney AI - Best Prompt Ticks - Beginners Guide - Beginners - MJ Explained ...; Created on 11 February 2023
5. ZohoCRM: Import Attachments: / Zoho /; ... ".",, -1)-1) v_DisplayName := A_LoopFileName ; if file names begin with exclamation mark (for saleslogix) if(InStr(v_NewFile, "!")>0) { v_NewFilePt1 := SubStr(v_NewFile, InStr(v_NewFile, ...; Created on 16 January 2023
6. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... All you need to do is send the PDF file to your Kindle email id. It is here that things might begin to seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle ...; Created on 29 June 2022
7. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... be searched for with the "State" field on the Lead record. // // ************************************************ // determine customer timezone: BEGIN // v_CustomerTimeZone = ""; // // build ...; Created on 15 December 2021
8. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... it's usage: // somewhere in the beginning l_ShopifyPictures = List(); v_ListingPublishKey = "AAAAABBBBBCCCCDDDDEEEFFFGGGGHHHIIIJJJKKLLLMMMNNOOOPPPQQWRRRSSTTUUVVWWXXYYZZ122345567890"; if(!isnull(input.Main_Photo)) { v_Filename ...; Created on 17 October 2021
9. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales Order to Zoho Books. Or leave as 2 calls at the beginning of your function ...; Created on 24 September 2021
10. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Quote". Within your function you can use the following as a reference. In theory, you could loop through each submitted quote but I do a call at the beginning of each iteration of the loo ...; Created on 06 December 2020
11. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; ...; Created on 06 May 2019
12. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
13. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; ... // get rid of all picklist options clear Time_field; // begin populating options thisStartHour = thisServiceRecord.Opening_Time.toString("HH"); thisClosingHour = thisServiceRecord.Closing_Time.toString("HH"); hourString ...; Created on 30 November 2018
14. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET ...; Created on 31 October 2018
15. MySQL Transactions in PHP: / MySQL /; ... changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ...; Created on 14 December 2016
16. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your Joomla v2.5.x database and website ...; Created on 12 September 2015
17. Android OS: Add GoogleMap as fragment: / AndroidOS /; ... private void addMapFragment() { FragmentManager manager = getSupportFragmentManager(); FragmentTransaction transaction = manager.beginTransaction(); MapFragment fragment ...; Created on 25 November 2014
18. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the beginning, so TEST it! ...; Created on 10 October 2014
19. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... Rows : One row per space separated string value ** Return Values : None *********************************************************************************/ BEGIN DECLARE @StringValue ...; Created on 20 August 2014
20. Convert to Proper Case in T-SQL: / Transact-SQL /; ... words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN -- declare some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); ...; Created on 04 June 2014