Assuming true is required, the following 88 results were found.
-
// // initialize v_CrmAccountID = ""; v_CrmContactID = ""; v_CrmPhone = ""; v_CrmMobile = ""; b_CreateAccount = true; b_CreateContact = true; // // set date/time of account last sync'd to Xero (100 years ago by default - so that it will be oldest)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // initialize v_CrmAccountID = ""; v_CrmContactID = ""; v_CrmPhone = ""; v_CrmMobile = ""; b_CreateAccount = true; b_CreateContact = true; // // set date/time of account last sync'd to Xero (100 years ago by default - so that it will be oldest)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)), '.$sql_keyword.',\'\')))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
{ // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->update($db->quoteName('#__extensions')); $defaults = '{"param1":"value1","param2":"value2"}'; // JSON format for...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
LatLng(0, 0)).title("Marker").snippet("Snippet")); // Enable MyLocation Layer of Google Map mMap.setMyLocationEnabled(true); // Get LocationManager object from System Service LOCATION_SERVICE LocationManager locationManager = (LocationManager)...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
number datepart) DATEADD(datepart, number, date) DATESUB(datepart, number, date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
together (must be the same size) and return the total of these results. -- is a 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...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Click on the "static" row that is the header of the tablix (the data of the tablix is "details"). Set "FixedData" to "True" if you want the headers to scroll with the report when viewed on the Reporting Server or within your IDE. Set "RepeatOnNewPage"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
[ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
ifEqual, hover, 1, return 1 if (msg = WM_MOUSEMOVE) { MouseGetPos, ,,,c If j := InStr(ctrls, "`n" c "=") { hover := true, j += 2+StrLen(c) j := SubStr(ctrls, j, InStr(ctrls, "`n", 0, j)-j+1) DllCall("SetCursor", "uint",j) } else DllCall("SetCursor",...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
use contains but check for word for each v_BadWord in l_BadWords { if(v_Output.indexOf( v_BadWord ) >= 0) { b_BadWordFound = true; } } // if not found if(!b_BadWordFound) { break; } } // output return v_Output; } Source(s): Zoho Creator - Community...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into Product [ Product_Name=v_Name...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
get a {"code":1001,"message":"Item \"...\" already exists."}. Documentation advises that the payload is empty which is not true in my case. This is my invokeUrl: v_DataEndpoint = "https://inventory.zoho.com/api/v1/items?organization_id=123456789";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= zoho.crm.attachFile("CustomModule5004",v_CrmSoID,r_Attachment.Upload_File); } } } r_Record.Attached_Files_in_CRM=true; } Other timewasting activities but good code Putting this code here on this article as it was the path I initially went down. Send...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"id": "123456789000000005" }, { "Currency": "USD", "id": "123456789000000006" } ], "info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// replace any commas in the value (for list conversion later on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone; l_TimeZones.add(v_TimeZone); } //info l_TimeZones; Yields something like: (GMT-10:00) Hawaii Time (GMT-8:00) Alaska...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ v_SalesOrderID); l_UrlParams.add("package_ids=" + v_PackageID); l_UrlParams.add("is_delivered=true"); l_UrlParams.add("organization_id=" + v_BooksOrgID); v_Url = "https://inventory.zoho.com/api/v1/shipmentorders?" + l_UrlParams.toString("&");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
of print however, I can't get a formula field to retrieve a field from another CRM record. // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // get the ID from the lookup field called "Vendor Contact" var v_VendorContactID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *