Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer and the problem...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 to get an item into the country. Don’t pay these fees. You’ll most likely never get the product and will lose any money you paid. Always remember, «CompanyName» is designed for meeting up to deal with people in your neighbourhood face to face. Work from...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 v_EndTime = ifnull(input.End_Time.toTime(),zoho.currenttime.addHour(1)); v_Billable = if(input.Billing == "Paid", "Billable", "Non Billable"); v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // //...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://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....

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 this might be obvious to some but these are self-proclaimed highly qualified web-gurus in the marketing department. They'd paid around £150,000 for a template designed by a 3rd-party company. Received the zip and uploaded it to their homepage. The...

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

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 all I could find were people selling third party products... they don't get it. If you are reading this, it's likely you've paid for a commercial version of a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 Professional What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 you can only have 1 aircraft; but the next version of this app is expected to hold a lot more. Hangar Tip: Both the free and paid version of this app are being developed to write to a mounted external SD card so they can share data but for the time...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 enough for my clients. Why am I giving it away for free? Could be malicious or could be that I made this for a website, got paid, and I've used it again and again since. I learnt how to do this because someone else taught me for free. Enjoy!...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Display Feeds to major Social Networkshttps://joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Zoho Books API v3 Limits 2019: Free Organization - 1000 API calls/day and 100 API calls/minute Paid Organization - 2500 API calls/day and 100 API calls/minute Zoho CRM API v2 Limits 2019: Free Edition: 5000 API calls/day Standard/Starter Edition: 5000 +...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 whenever an invoice or contact gets updated in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one that runs on...

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

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 School do you go to?"); v_SchoolID = r_CandidateDetails.get("Which School do you go to?_ID"); b_SchoolPaid = if(r_CandidateDetails.get("Paid School") == "true",true,false); // v_CandidatePlacedCount = 0; v_CandidateGraduatingCount = 0;...

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

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

06 March 2023 to continue a conversation Done 2023-03-11 Update November 2024 Code to get this working with GPT 4o Mini: // requires a paid account: https://platform.openai.com/api-keys v_ChatGPT_ServiceAccount_Key = "sk-XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 and payroll gets run with these discrepancies, then they will have a fair few disgruntled employees who may have been paid incorrectly. As such this system has to be reliable and the system managers need to be notified in advance of any errors with the...

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