Master: Project Child: Time Sheet Line Item Time Sheet Line Item formula field Total Line Amount (Total_Line_Hours__c * Project_Task_Billing_Rate__c)
I am trying to create a Roll Up Summary field on Project to SUM Total Line Amount field on Time Sheet Line Item, but Total Line Amount is not available in the drop-down (other formula field Total Line Hours is available). What am I doing wrong here?
How can I SUM data returned in a pageBlock, or do I need to use another method to do so? I am trying to create a Billing Report, returning Project data and N line items for Time & Expense, and I need to summarize the Time and Expense sections, then add those subtotals together.
Any approach advice is appreciated as I am brand new to VisualForce.
How do I reference a child custom object from my Projects object, as I get a "is not a valid child relationship name for entity" when I attempt to reference the related object Expense from project via relatedList.
I have created a series of custom objects (projects, project task, expense, timesheet, timesheet line items) and am creating a visualforce page for a billing detail report, and the standardController = SFL5_Projects__c.
A lookup relationship exists on the Projects (SFL5_Projects__c) object to Account via field Client__c, but I cannot reference Account object via standard syntax to pull back the name of the Account (SFL5_Projects__c.Client__c.name errs out, as standard syntax is .Account.name if I were referencing from a standard object like Opportunity.Account.name).
So, my question is how does one reference both standard and custom objects to pull fields (where lookup relationships exist) when the standardController = a custom object?
How can I SUM data returned in a pageBlock, or do I need to use another method to do so? I am trying to create a Billing Report, returning Project data and N line items for Time & Expense, and I need to summarize the Time and Expense sections, then add those subtotals together.
Any approach advice is appreciated as I am brand new to VisualForce.
How do I reference a child custom object from my Projects object, as I get a "is not a valid child relationship name for entity" when I attempt to reference the related object Expense from project via relatedList.
I have created a series of custom objects (projects, project task, expense, timesheet, timesheet line items) and am creating a visualforce page for a billing detail report, and the standardController = SFL5_Projects__c.
A lookup relationship exists on the Projects (SFL5_Projects__c) object to Account via field Client__c, but I cannot reference Account object via standard syntax to pull back the name of the Account (SFL5_Projects__c.Client__c.name errs out, as standard syntax is .Account.name if I were referencing from a standard object like Opportunity.Account.name).
So, my question is how does one reference both standard and custom objects to pull fields (where lookup relationships exist) when the standardController = a custom object?
I have anohter object called: Department which has a Master-Detail field -> Company
My third and last object is Employee and it has 2 Master detail relationships ->Company & ->Department
Now, I have a few companies and a few departments (each of the departments belong to a specific company).
When I open a new Employee I need to choose a company on the company field and a Department on the department field of the Employee.
Problem:
After choosing a company that the employee belongs to, I want the option list for choosing the department to only hold departments that belong to the company I choose.
