Assuming values is required, the following 107 results were found.
-
set initial hidden date field input.Selected_Date = zoho.currentdate; input.Starting_Date = zoho.currentdate; // // set the values for the calendar select field clear Calendar_Day_Select; input.Calendar_Day_Select:ui.add("<"); for each index...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
load of the page when creating an invoice) then I'll just put the client script I used to map over all the applicable field values from the quote to the invoice within ZohoCRM. Set up the Client Script Login to ZohoCRM > Setup (cog icon next to profile...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Backup the database in LIVE environment Clear the database in DEV 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...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
List Box to your form Right-click it and select "Drop-down List Box Properties" Under "List box entries" select Look up values from an external data source Next to "Data source" click on Add Select "Create a new connection to" and then Receive Data...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
1, Line 1 Conversion failed when converting the varchar value 'B110' to data type int. I'm not using any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND n.number...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
even for REST API v2.0 would have been something like the following: // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // // build up product details JSON to send m_LineItemProduct = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // split values by commas l_FieldValues = r_Data.toList(","); if(l_FieldValues.size()>0) { m_Record.put("EmployeeID",l_FieldValues.get(0)); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
following: Source(s): Zoho Creator/Deluge: Insert rows in Subform Quick refresher: // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // declaring another row (declare as many rows as required) = .(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in r_Response.get("fields") { if(r_Field.get("api_name") == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
manages their domain, then they can give the following instructions to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this article, this is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
key is mandatory when you include Who_id and What_Id. FREQ (String): Defines the frequency of the reminder. The possible values are DAILY, WEEKLY, MONTHLY, YEARLY, NONE. If you specify, NONE, the system sets a one-time reminder and TRIGGER becomes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *