Assuming return is required, the following 174 results were found.
-
of code to work this out: // calculate percentage v_Percentage = (v_TotalClashes / v_TotalDeptEmployees * 100).round(0); Return an error if overbooked, no error if not: To return an error (I know we set the function to return "Map" and are using a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Gui, Add, Edit, x45 y40 w520 r1 vSearchTextInput Limit70, Search... Gui, Show OnMessage(0x200, "WM_MOUSEMOVE") Return ; FUNCTION TO HANDLE BOTH TOOLTIP AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
$term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term); $term = preg_replace("/,/", "{COMMA}", $term); return $term; } function search_split_terms($terms){ $terms = preg_replace("/\"(.*?)\"/e", "search_transform_term('\$1')", $terms);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
of code or screenshots below are made up. the Attachments.csv A data backup or export of the Attachments from ZohoCRM will return to you a CSV of attachments. View it to see what is expected of the reverse process, the import file. The import file I got...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java (readFeed) and replace with private List...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained within. How? So I'll be putting this program...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
. 'S')); if ($current_time->getTimestamp() >= $expire_date->getTimestamp()) { $credentials = null; unlink($path); } return $credentials; } // store new credentials in file function storeCredentials($path, $credentials) { $credentials['created'] = (new...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
get prompted for the Mac/Admin password which you type in the terminal (will not display, just type away and press the Return key). The response will be something like “added 98 packages from 60 contributors in 3.043s”. Check the CLI installation by...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ( StringValue VARCHAR(10) ) AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+Grid x0 y50, Old Name|New Name Gui, Font, s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
{ ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ; Deinit static variable xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist( sFile:=A_LoopFileLongPath ) { Return...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
== v_XeroSignature) { v_ResponseCode = 200; } m_Response.put("status_code",v_ResponseCode); // // return return {"crmAPIResponse":m_Response}; Save this and return to the list of functions Hover over the function you just created, click on the 3...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords in a "Search the web..." task. ChatGPT by OpenAI is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. Getting to the development-side Login to ZohoCRM as a super-admin Go to Setup (cog icon in the top right)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF