Forum Discussion
MCFNeil
8 years agoQrew Captain
Most of the time, it is best to create and connect all these records through a code page, rather than a really long formula url field. Especially if you want those child records to have grandchildren
But that takes some coding, or some help.
But that takes some coding, or some help.
- ClaytonRountree8 years agoQrew CadetHi Matthew, thanks for the comment. Estimate Details are grandchildren if you consider Projects the parent and Estimates the children, but Estimate Details won't have any children. What is your suggestion on this issue then, I'm not sure what you were suggesting as a solution?
- MCFNeil8 years agoQrew CaptainIf you want to press a button on the 'Project' table, and have it make an estimate, and a bunch of details lines, you will need a javascript code page to do this.
Is the estimate and details a standard list that you could make via a template? What types of variations do you need to the detail lines. - ClaytonRountree8 years agoQrew CadetHi, so the projects to estimates works just fine, no issues there. When on an estimates record, I want to click a button that creates 34 children on the estimate details table. These 34 records should auto-populate with the details from the estimate record they were created from. The difference between each of the 34 is which team they are assigned to (pre-set list of 34 teams). This way we can track which of the 34 teams haven't responded to an estimate request. Then there will be fields on each of the 34 that each team will manually fill. Does that make sense?
So for Project 1234, we may create a planning phase estimate. The planning phase estimate will need to know how each of the 34 teams will be impacted by the project. Each team will assess their impact on a estimate details record for project 1234 for the planning phase estimate. Later during the execution phase a change request might go out for project 1234. This is a different type of estimate, so the 34 teams will need to respond with their impacts again. Hopefully this paints the picture for you?