Assuming returns is required, the following 90 results were found.
-
type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to eBay's Picture Services successfully, Shopify would not accept any links I gave it. Why not use the links that eBay returns? Well eBay returns URLs to images that have been resized to 400x400 (even with tweak to return 800x800). I wanted a way to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
tab out of the tab strip and into an existing window. Opens the tab in the existing window. Press Esc while dragging a tab. Returns the tab to its orginal position. Ctrl+1 through Ctrl+8 Switches to the tab at the specified position number on the tab...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle error usually returns in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
of your search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname parameters are not populated. In addition, we also need a second...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(formats, defaults and vulnerability) Technical Review Examine all functions: what goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a boolean. Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( v_Url ); Returns something like: { "ipAddress": "147.188.254.175", "continentCode": "EU", "continentName": "Europe", "countryCode": "GB",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
1, 2) ThisDate=%ThisDate% val=%ThisDate%%ThisTime% } FormatTime, val, %val%, ddd dd-MMM-yyyy HH:mm:ss Return val } // returns format Sat 01-Jan-2011 01:00:00 The next function usually accompanies the above one. It will basically convert seconds into...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
, "System.Video.VerticalAspectRatio" ) MsgBox % a_MediaObject["System.Media.Duration"] // note this returns in 100ns units (= 100 nanoseconds) as per Microsoft Docs. 100ns Units So the following snippet of code will convert your 100ns units to a...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which populates as: 08:00, 08:30, 09:00, 09:30... 19:30, 20:00. //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
long way (and cos the regex for this isn't working) v_FormattedString = v_MyString.replaceAll("\r","",false); // carriage returns v_FormattedString = v_MyString.replaceAll("\n","",false); // line feeds v_FormattedString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: 2020-03-17 */ // get all field names for the Invoices module via API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
clean --force. I didn't bother resolving this other than having a terminal with the command zet pack ready every time which returns me the ZIP file to upload by editing the widget in ZohoCreator. I'd preview it in Zoho Creator rather than the site that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
map/collection Date Created: 2020-10-27 (Joel Lipman) - Initial release - Workflow to calculate 80% dept workforce - Returns response as popup - Cancels submit with error popup if over 80%, else success...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
I couldn't be asked). Then publish the report of this form (eg. "Download File Report") and get the long publish key it returns you. eg. https://creatorapp.zohopublic.eu + zoho.appuri +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *