Search - Joel Lipman .Com

1. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This ...; Created on 11 February 2023
2. XML Schema Reference: / Extensible Markup Language /; XSD Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for ...; Created on 13 August 2014
3. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under ...; Created on 03 June 2014
4. DBMS Random Reference: / Oracle PL/SQL /; What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...; Created on 21 August 2012
5. MySQL Data Type Reference Table: / MySQL /; A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...; Created on 15 February 2010
6. $_SERVER['http_referer'] returns blank in Internet Explore: / Microsoft /; Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. ...; Created on 19 October 2009
7. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... Search ZohoBooks estimates for the quote reference and validate by the contact Zoho ID if(v_QuoteRef != "-") { r_SearchResults = zoho.books.getRecords("estimates",v_OrgId,"estimate_number=" + v_QuoteRef,"my_books_connection"); if(r_SearchResults.get("code") ...; Created on 04 November 2024
8. Zoho Creator: Input Color Picker: / Zoho /; ... users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click ...; Created on 14 October 2024
9. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
10. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... t = v_SignType; // // Specify template ID // check URL https://sign.zoho.com/zs#/template/viewer/ v_TemplateID = "abcdefghijklmnopqrstuvwxyz01234567890"; // // get merge field names (for referen ...; Created on 06 August 2024
11. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... workspace you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select ...; Created on 25 July 2024
12. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is also referred to as the pricelist... ...; Created on 23 May 2024
13. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... + v_ConditionDisp + " "; // // unique item reference if(c_Quote.Quote_Reference.contains("Q-")) { v_ItemDescDisp = v_ItemDescDisp + "Ref. " + c_Quote.Quote_Reference + " "; } %> ...; Created on 07 May 2024
14. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... > REST API (link under the tabs) Click on the Add key button Give it a description, assign a user that it will run as (preferably of the admin or account that will never leave the business), and permissions ...; Created on 15 April 2024
15. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... parts but otherwise it is intended to be all in the same function as there are references to some variables in earlier snippets of code on this page. Error(s): 2945: UPLOAD_RULE_NOT_CONFIGURED Was ...; Created on 25 March 2024
16. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... (aka the Quote Builder) will need to post a new quote to the system as well as show previous orders. How? We're going to use the Zoho Extension SDK. You should refer to my previous linked article ...; Created on 14 March 2024
17. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... of ticket or attachment webhook, will push some of the details of the ticket and all/any attachments to a Zoho Creator form. The ticket form has the ticket reference, product information, factory/supplier, ...; Created on 26 January 2024
18. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
19. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... an invoice. Please refer to the Zoho Books API documentation for what fields are required to complete a request within your system. m_InvoiceDetails = Map(); m_InvoiceDetails.put("customer_id",m_BooksSO.get("customer_id")); m_InvoiceDetails.put("payment_terms",-3); // ...; Created on 06 July 2023
20. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... I'm storing this here as a reference and taking the bits that I need for the various clients that request an eBay integration. This is a comprehensive snippet which does the whole lot. How? Using ...; Created on 27 April 2023