Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming tasks is required, the following 19 results were found.

  1. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    the specified user (full name of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get transferred to the contact record. Step 1: Workflow on Create and function to create task: Create a workflow...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    == "Paid", "Billable", "Non Billable"); v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // // eval v_HoursDecimal = (v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 / 60; v_TimeHour =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  3. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING: -- Assuming...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    base rate is £20/hour. I use my own timesheet system, so if you have a 5 minute job, this will only be added to subsequent tasks until these add up to 1 hour. Housing the production and 2 development websites and email system as permanent host is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  5. Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    "None", "custom_fields": m_Custom.toString() }; r_CreateResponse = zoho.projects.create("joelsprojects",45678901234567890,"tasks",m_Params );

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  6. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    In the above code, you would change the model value to one of the following code-davinci-002 (optimized for code-completion tasks) text-davinci-002 text-davinci-003 gpt-3.5-turbo (optimized for chat at 1/10th the cost of text-davinci-003) gpt-4...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  7. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    In the above code, you would change the model value to one of the following code-davinci-002 (optimized for code-completion tasks) text-davinci-002 text-davinci-003 gpt-3.5-turbo (optimized for chat at 1/10th the cost of text-davinci-003) gpt-4...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-error-code-2945-extra_key_found_in_json.html

    Application Development Zoho Deluge / Integrations > Pre-defined integrations with Zoho services > Zoho Creator Integration Tasks > Get Record by ID

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    to work this out. Put simply, "Closed" are events in the past and "Open" are events in the future. The "is_open" in tasks is misleading and cannot be used in the request for events. There are hardly any parameters you can send to. Here's some code to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  10. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    FROM "Meetings" mtg ) AS t4 LEFT JOIN "Joels Image Library" img4 ON t4."Status" = img4."Status Value" UNION ALL SELECT 'CRM Tasks' AS "DataSource", date(t5."ModifiedTime") AS "Date", t5."RecordID" AS "Record ID", t5."RecordName" AS "Record Name",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  11. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options for your website members. If Joomlapolis ever complete the CB...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    SQL Server\100\DTS) Right-click on the Application folder and add the sub-folder you need to put your sample in (ie. Tasks, PipelineComponents, Connections) Right-click on the new folder, and add "Project Output" to the folder to place binaries from...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    Storage Operator Requests ntmsoprq.msc Resultant Set of Policy (XP Prof) rsop.msc Scanners and Cameras sticpl.cpl Scheduled Tasks control schedtasks Security Center wscui.cpl Services services.msc Shared Folders fsmgmt.msc Shuts Down Windows shutdown...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  14. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Pictures ms-settings:privacy-pictures Radios ms-settings:privacy-radios Speech ms-settings:privacy-speech Tasks ms-settings:privacy-tasks Videos ms-settings:privacy-videos Voice activation ms-settings:privacy-voiceactivation Surface Hub Accounts...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    To change the property and close all other connections, click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  16. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    will be the earliest someone starts work that day. EndTime will be the latest someone works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  17. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    prevent Close-Out Meeting Project Closure Review original project initiation document (project mandate) Review milestones (tasks) as set in the project management system Review original deliverables and success criteria Satisfied? Can be quoted?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  18. Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    // WORKS! Returns a hexadecimal 32 character string Arguably, I'm using Creator 5 and the documentation for the encryption tasks are for Creator v4. However search md5 in zoho creator v5 help documentation and it's never heard of md5 (absolutely no...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  19. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 1 - 19 of 19