Assuming else is required, the following 120 results were found.
-
FileSelectFolder, vSelectedFolder, 3, , Select a folder if vSelectedFolder = MsgBox, You didn't select a folder. else { vSelectedFolder := RegExReplace(vSelectedFolder, "\\$") ; Removes the trailing backslash, if present. GuiControl, , MyBaseDir,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
$diff = $expiry_time - time(); $api['jwt']['token']['minutes'] = floor($diff/60); } 6a. Use existing Access Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
and specifying the quantity for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario: Counting total products: // // count...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
< 12) { input.Morning:ui.add(r_AvailableSlot); v_CountMorning = v_CountMorning + 1; v_CountTotal = v_CountTotal + 1; } else if(v_HourCheck >= 12 && v_HourCheck...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ ""; v_RelatedListXML = v_RelatedListXML + ""; v_Index = v_Index + 1; } v_RelatedListXML = v_RelatedListXML + ""; } else { // display "no records found" v_RelatedListXML = ""; v_RelatedListXML = v_RelatedListXML + "No records found"; v_RelatedListXML =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_ZohoModule = "Contacts"; } } // if(v_CrmContactID != 0) { // parse and build up CRM record update here } else { // parse and build up CRM record creation here } } } } } else if(r_Event.get("eventCategory").containsIgnoreCase("INVOICE")) { // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
agents would have a lead record with the status "New Lead". The client wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(v_KeepID == 0) { v_KeepID = m_Result.get("id").toLong(); l_DebugNotes.add("Will keep ID: " + m_Result.get("id")); } else { l_DebugNotes.add("Will delete ID: " + m_Result.get("id")); m_Delete = Map(); m_Delete.put("module","Products");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
'Macintosh') THEN 'Mac' WHEN INSTR(a.VisitorUAgent, 'X11') THEN 'Linux' WHEN INSTR(a.VisitorUAgent, 'Linux') THEN 'Linux' ELSE 'Other' END VisitorOS, COUNT(a.VisitorUAgent) 'Total' FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, DATE(s.DateTimeCreated) AS ActivityDate, MIN(s.DateTimeCreated) AS DataFrom,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
CASE WHEN emp.ContributionValue=1 THEN 5010 WHEN emp.ContributionValue=2 THEN 5011 WHEN emp.ContributionValue=3 THEN 5012 ELSE 9999 END FROM [dbo].[DMExtractEmployeeTable] emp INNER JOIN [dbo].[DMExtractReferenceTable] ref ON RIGHT(emp.[PayCode],3) =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
How? The following code is using AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value to...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
which accesses a Google Drive using a Service Account (unattended). Why? This is a big cop-out as I simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion and...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
{ v_LeftMost:= v_x1 a_MyArray[0,0] := v_x1 a_MyArray[0,1] := v_y1 a_MyArray[0,2] := v_x2 a_MyArray[0,3] := v_y2 } else if(v_x1 > v_RightMost) { v_RightMost:= v_x1 a_MyArray[2,0] := v_x1 a_MyArray[2,1] := v_y1 a_MyArray[2,2] := v_x2 a_MyArray[2,3] :=...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
b_FileExists || b_InColumn) && (!b_IsOriginal) { v_NewNameWithExt := Trim( v_NewName ) " (" v_Increment ")." A_LoopFileExt } else { break } } ; add to the list view LV_Add("", A_LoopFileName, v_NewNameWithExt ) ; update for the status bar v_RowCount++...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
- Workflow to calculate 80% dept workforce - Returns response as popup - Cancels submit with error popup if over 80%, else success ******************************************************************************* */ // // declare v_TotalClashes = 0;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required fields:\n" + l_Errors.toString("\n"); } else { //... code to submit form/save to record here } Then save the data by adding the record or updating the existing record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox Mode"; } else { r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; //info "Production Mode"; } if(r_Api.count() > 0) { //info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
as there are the chevrons / less-than greater-than signs options to program into. For this simply append the following: else if(input.Calendar_Day_Select == "<") { // // set selected date field value input.Selected_Date =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF