Assuming name is required, the following 277 results were found.
-
Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following: Action: - Give the action name a memorable name (eg. "Print Directory Contents To File") Application: - Type the following c:\windows\system32\cmd.exe /c...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
** ** ** ** Parameters : ** ** - Value: the value you want to match on (eg. Customer_ID) ** ** - Column: the column name which will contain this value. ** ** ** ** Return Values : Table of three columns: ** ** - myValue: value specified in parameter 1...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
file equivalent. How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- 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
-
// // 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 Deluge
- 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 Creator
- 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 Creator
- 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 Deluge
- 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 CRM
- 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 Deluge
- 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 CRM
- 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 Recruit
- 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 Books
- 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 CRM
- 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 Books
- 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 Workdrive
- 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 Books
- Language: *
-
pipeline Login as a ZohoCRM Administrator and go to Setup > Developer Hub > Functions > New Function Give it a function name, display name, description, and set category to "Standalone": I'm calling mine "fn_Deals_RetrievePipeline" Give it the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
you supply a client key in the request. You do not need to pre-create those. Secure Access via GET All calls must include: name — the output file name without the extension url — the source image URL auth — your daily MD5 API key client — your lowercase...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *