Assuming filter is required, the following 27 results were found.
-
an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of each entry as a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
and wanted to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next snippet of code, I am getting the Zoho CRM record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Map(); /* r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); v_CRMOwnerID = r_SoDetails.get("Owner").get("id"); v_Filter = "crm_reference_id=" + v_OwnerID; */ // set v_Filter to blank to retrieve all sales persons v_Filter = "";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
*' . ' FROM #__weblinks' . ' WHERE catid = '. (int) $this->_id. ' AND published = 1' . ' AND archived = 0'; $query.=($filter_order!="ordering")?' ORDER BY '. $filter_order .' '. $filter_order_dir .', ordering':' ORDER BY title ASC'; To sort by another...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Intrinsic Details Photo-realistic Precise Details Cameras...captured using a... Canon EOS R Camera Nikon D850 Type of Filter/Lens...with a... 16mm Lens 35mm Lens 50mm Lens 85mm Lens 200mm Lens Macro Lens Neutral Density Filter Nikon AF-s Nikkor...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
'[[::]]')"; } else { $scorepartstring = implode(' + ', $scoreparts); } // Generate the SQL query for your search engine $filter_sql = " SELECT t.PageID, t.PageTitle, t.PageContent, t.Source, ".$scorepartstring." AS Score FROM (".$live_sub_query.") AS t...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
against a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Maximum Date; then I want to "Group By" the image column, here labeled "Status Image": Then on the 2nd tab, I'm going to filter by my dataSource, which I've selected here to be my "CRM Accounts": Click on the 3rd tab "Settings" and the preview should...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
interface: Save failed with the following error: Invalid parent ID. Asset ID is incorrect... Categories > Clear Filter Options > Show All > Tick to select all > Rebuild [does not work] Using the administrator panel, go into each category and hit save...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
*/ background: rgb(255, 255, 255); /* RGBa with 0.6 opacity */ background: rgba(255, 255, 255, 0.6); /* For IE 5.5 - 7*/ filter:progid:DXImageTransform.Microsoft.gradient(startColorstr=#ff000000, endColorstr=#ff000000); /* For IE 8*/ -ms-filter:...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed) ac3filter.cpl Outlook Express msimn Paint pbrush Password Properties password.cpl Performance Monitor perfmon.msc...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But because the next time this happens, I would have to repeat this, I would...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
by other users who access the same computer (this is irrespective of whether you have logged out of the CMS). Add an IP filter To include this method, ensure you have a static IP address (most home broadband users are now assigned these by ISPs so that...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
return v_Output; } Additional Notes: As this was for a client who arranged outdoor activities for kids, I need to add a filter which blocks out swear words and the such. Experimental - DO NOT USE: string generateRetrievalCode() { //... refer to above...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if( a_ThisFileName[A_Index] != "EDIT" && v_FoundUnderScore...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
by "Modified_Time", loop through and update each iterated record. (see sample code below). Go to the list view in CRM and filter by "Processed" is "Selected", check after each run of the function that the number has incremented. Once all records are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: Type FTP in the filter field in the top right and there should be a single FTP option displayed to you: Step 1 of 2: Give the datasource the table...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF