Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my freelance website development process. It may look clean, clear, obvious... it's just an outline...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Google Event Ilustrations aka Flairshttps://www.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 new year, new year's, new years oilchange: oil change, car service pingpong: ping pong, table tennis, ping-pong, pingpong planmyday: plan week, plan quarter, plan day, plan vacation, week planning, vacation planning pride: dyke march, christopher street...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: *

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 and running with the latest technologies. You are welcome to find and use your own website hosts with their own support plans and I can help you configure these for the source files (as per my base rate). Note that my servers are based in Houston,...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 return m_Response; Error(s) Encountered: Exceeded Quote Limit: Try generating a new API key (aka Secret). If you need a paid plan, then you can access this by logging into OpenAI and browsing to https://platform.openai.com/account/billing/overview. At...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 in Zoho Creator was hitting statement execution limits and rather than proposing an upgrade or add-on to the subscription plan; we wanted some proof using code. How? We're going to use a quick snippet of some code. So create a function in the Zoho App...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Some milestones for a website projecthttps://www.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 code and basic prototypes that describe the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the concept and presented to potential publishers....

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 2008 Test/Sample MySQL Database to connect to (server and username + password). Admin Access to the reporting server if you plan on deploying the report to it. Scenario: We want to report on a MySQL database MySQL login information is a user who exists...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several databases: DROP TABLE #CountRecordsPerTablePerCol or equally IF...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the cars. Keep as much space as possible between our marshall. Not...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 on a per-app basis so I wanted a standard way of doing it and I'll update this article as I improve on the code. How? So the plan is: Declare the functions. Authenticate on page load by checking timestamp in token file: If token is required, redirect...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found and stop adding when...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater is required - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 - Creating or Updating Resources with the POST Method Twilio Docs - Error 21211 Twilio Docs - E.164 (Telephone numbering plan)

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 in a prompt can be accessed if people work out the link. "Stealth" mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 on Reuse Test on keeping conversation context: Still to do: Need to train it on ZohoCRM data with statistics and datasets. Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 use of any third-party APIs. How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the list of unique ones from the "all" list...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 SVG. ZohoCRM signatures seem to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible image URL to/from...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *