Assuming person is required, the following 35 results were found.
-
and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as to generate meaningful reports. The first dataset should be just the profit per item based on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type =...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time by low-level tape monkeys and techies is 30 minutes...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
using a for loop. What I have: {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} What I want: First Name Last Name ID Joel Lipman 1 Another Person 2 How? This is a bit of a dirty solution and as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
within ZohoCreator, requesting for an invoice in ZohoBooks to be sent. How? So the key here is that there were no contact persons on the customer record. Instead, when building the invoice, this had to be added (don't ever remember having to do this) as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
If you're not an IT person, you may want to avoid reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
show you the domain and username of this accountname in Active Directory. I know the AD domain and username, show me the person! http:///Person.aspx?accountname=MYDOMAIN\myusername (where "" can be domain\username or just username. Master of the...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
- Type: Article
- Category: Static Items
- Language: *
-
The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
' || UPPER(b.p_surname) || ' (' || INITCAP(To_char(b.p_dob, 'DD-MON-YYYY')) || ')' "p_STUDENT_DETAILS", NVL(a.student_id, b.person_id) "p_STUDENT_REF" FROM student_accounts a INNER JOIN student_details b ON a.student_id = b.person_id WHERE a.student_id...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames = '') AND...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Report Specification 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......
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
- Flaming harms the nice atmosphere of TEU. It also causes thread's to go off topic, and most importantly, it hurts the person being flamed. The victom may defend themselves against any accusations made to them, but may not make any additional...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
by reading the weather data from api.openweathermap.org and the flight restriction details from api.joellipman.com (my own personal website). This allows me to continually add data to the api of my own website without needing to redistribute or update...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
= { "name": "My Happy Project", "flag": "internal", "milestone_id": 98765432109876540, "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1", "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
An article so that I don't spend so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{ v_Email = ifnull(r_User.get("email"),""); v_LastName = ifnull(r_User.get("last_name"),""); // // single out this person (can be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
server uses the US datacenter but has it's server timezone set to "US/Eastern" or "America/New_York" (-05:00). Our sales person is on the west coast in the timezone "America/Los_Angeles" (-08:00). And our customer is in "Europe/Luxembourg" (+01:00). We...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *