Assuming values is required, the following 106 results were found.
-
a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed document attached to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
string concatenation, converted into a map This builds a JSON string over several lines, then converts it into a map so values can be accessed by key. v_InputData = "{" + "\"ID\":\"TEST-1001\"," + "\"FirstName\":\"John\"," + "\"LastName\":\"Doe\"" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the most recent mySQL version -- installed. These are NOT the same as apostrophes used in SQL to define -- non-numerical values. -- ----------------------------------------------------------------------------- -- -- 1. replace all database names in the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
anyway otherwise it will look a bit like a staircase of bricks). 4. Design the Matrix: In other words, put where all the values are going to go. [Time] into "Columns", [Room] into "Rows", and [Status] into "Details". 5. Save and close the report wizard...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
compiles without warnings in SQL Developer (or SQL*Plus, etc.) Hardcode your parameters in the SSRS report with actual values that would have been submitted. Create the most basic report you can with the data you're working with just so you can get used...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = DATALENGTH(@OrigVal); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = ''; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
-- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = LEN(CAST(@OrigVal AS VARCHAR(max))); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = '';...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
IS NULL THEN v_returnedval := NULL; ELSIF p_original_datatype='INT' THEN -- Check Parameters and assign proper default values IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10, (LENGTH(p_original_value)-1)); -- should yield eg. 100000 ELSE...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
ie. A sql authenticated user with read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
= 10 Const OBJ_EXTPEN = 11 Const OBJ_ENHMETADC = 12 Const OBJ_ENHMETAFILE = 13 ;#End Region ;#Region WM_MENUCHAR Return values Const MNC_IGNORE = 0 Const MNC_CLOSE = 1 Const MNC_EXECUTE = 2 Const MNC_SELECT = 3 ;#End Region ;#Region Background Mode...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
--- Fix Included in file release version (link to version file ID) - Added Admin Section: Dropdown Options --- Priority Values (immediate, high, medium, low) --- Progress Status Indicators (red, green, orange) --- Progress Status Types (received,...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
(or "JSM"). Other Areas: One of the parameters is entitled "Search Area". This is the component to search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a subform: // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // insert the row into the collection .insert( ); // insert the collection...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
needing to use your creator knowledge. I haven't been using this because I edit the content based on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report: Click on the plus...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
record and generate a link for the customer portal user to click on: // accessing zoho.eu (not zoho.com) so adapt the 2 values v_CreatorBaseUrl = "https://creator.zoho.eu"; v_ZohoApisDC = "https://www.zohoapis.eu"; // // get field from CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
} } // // check list of IDs if(l_ApprovalUsers.size() > 0) { // // reset multi-user lookup field (clear out values) v_SearchCriteria = "(userlookup221_2:equals:" + p_QuoteID + ")"; l_SearchResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *