Assuming name is required, the following 269 results were found.
-
) String Length LENGTH(string) BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now())...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType CodeType 1 Joe Manager 0011 2 John Tape-Monkey 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
ComObjCreate UserFolder:="C:" -- to return file count in a folder ItemCount := ComObjCreate("Shell.Application").NameSpace(UserFolder).Items.Count FileCount := ComObjCreate("Scripting.FileSystemObject").GetFolder(UserFolder).Files.Count FolderCount :=...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Select HKEY_USERS Go to the menu File and select Load Hive Navigate to that user's profile folder, usually C:\users\username in this case Users > Guest Enter NTUSER.DAT in the File name box. (This file is a system-hidden file, so it won't show up in the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
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 database level can save some time....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com to dev1.myexample.com where `option_name`='home' change...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
// // build up tax options l_TaxOptions = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","VAT"); m_TaxOption1.put("value",v_TotalTax); l_TaxOptions.add(m_TaxOption1); m_TaxOption2 = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
font-size: 20pt; margin-left: 14px; } .main-content1 .sub-content{ margin-left: 14px; } Photo View List View Product Name #1 Product SKU #1 Product Description #1 Product Price #1 Product Name #2 Product SKU #2 Product Description #2 Product Price #2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without the double-quotes and no funny characters). It will initialize a project in a folder called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each r_Workspace in l_Workspaces { if(!isnull(r_Workspace.get("id"))) { v_WorkspaceName = r_Workspace.get("name"); } } Get the services: // // get services r_ServiceResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
workflow of a call/meeting Login to ZohoCRM > Setup > Automation > Workflow Rules > Create Rule Module is "Calls" Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, eg. "fn_Validation_LeadStatusChange", a display name, eg. "Fn - Validation - Lead Status Change", and a description... You...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
//info r_CandidateDetails; if(!isNull(r_CandidateDetails.get("Which School do you go to?"))) { v_SchoolName = r_CandidateDetails.get("Which School do you go to?"); v_SchoolID = r_CandidateDetails.get("Which School do you go to?_ID"); b_SchoolPaid =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
just for quick reference. How? Note that for the below, I recently updated this article (2024-05-21) due to the API domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho DataCenter)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
with a separate workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get transferred...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the relevant workspace and click on "Next" Select "Custom Query" in step 2 and paste your Zoho SQL query in here. Give it a name, set the schedule and then wait for it to finish building the table. If you want the Zoho SQL (Ansi-SQL?) used to link the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
connection:"my_workdrive_connection" ]; //info r_TeamFolderInfo; // // ====================== // get list of subfolders by name (creates a timestamped duplicate if exists so need to check if it exists first) //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
word "Incoming" is the operative word as the response cannot be configured in ZohoBooks like we need to in this solution; namely the webhook response needs to have a header and a body. The 2nd caveat is a concern around security. It is difficult to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF