Assuming time is required, the following 230 results were found.
-
TrainerCentralSite.com. How? OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date // selectable date time // selectable time android:imeOptions normal actionUnspecified...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
pages on the ReportingServer, ie. affects all reports on that server). Method #3 Use ASP instead of SSRS. Method #4 Use a TimeInterval refreshing the page after a certain time. Conclusion In the end, this came down to a design decision. Time spent on...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated in Xero. Why? I used to use ZohoCRM schedules to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
is subject to change without notice. Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
query, change and suggest other actions or route to take. My pricing structure: Easy, my 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....
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Setup a scheduled task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties involved, plus the documentation online was in parts and requires going to several pages...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy hh:mm a"); // // future...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
My use-case here is that I have built an eBay integration between Zoho Inventory and... eBay. Out-of-the-box, and at-time-of-print, Zoho Inventory only syncs eBay one way, in other words, listings on eBay get downloaded to Zoho Inventory but not...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
*/ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = {1}; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex = (v_Page - 1) * v_PerPage; v_ToIndex =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
to Siri or Ask Google where it includes the keywords in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
executed in ZIA chat when "Ask ChatGPT" button is clicked Purpose: This will query the OpenAI ChatGPT API but at the same time retain the context of ZohoCRM Inputs: string userInput Outputs: map m_Response Date Created: 2023-02-08 (Joel Lipman) -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
= ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *