Assuming filter is required, the following 29 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 Books
- 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 Books
- Language: *
-
to work in the first place. When did the connection last work? Within ZohoBooks > Banking > Active Accounts > Account > Filter by "Matched Transactions" Bank Issue: Check with client which bank they use, type in the "Search" when connecting a bank on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- 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: *
-
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 Analytics
- 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 Analytics
- 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
-
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 Deluge
- Language: en-GB
-
Monitor Cable KabelDirekt - DisplayPort to DVI adapter cable 2m dual link 1 £9.89 Additional iYueshare 120mm Magentic Mesh Filter Cover Grill (2 pack) 1 £8.90 Additional Power Supply Sleeved Cable (White) 1 £19.99 Build & Cost Breakdown Initial Build...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
if( a_ThisFileName[A_Index] != "EDIT" && v_FoundUnderScore...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
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 Deluge
- 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 Deluge
- 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 CRM
- 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 Analytics
- Language: *
-
where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
own map... // in this case, my table exactly matches the keys so this isn't really necessary but just in case I wanted to filter some fields out... for each v_Field in m_ThisGoal.keys() { m_OutputRecord.put(v_Field,m_ThisGoal.get(v_Field).toString());...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *