Forum Discussion

JoshWeeman's avatar
JoshWeeman
Qrew Assistant Captain
8 years ago

Call a specific field from a specific child record from a Formula field in parent record?

I have a parent table, PROJECTS, in a one-to-many r'ship with its child table, BUILDINGS.  (Each Project typically has 5 to 10 Buildings.) Within the Project, I am doing many calculations on data r...
APIs and custom code
Ask about Quickbase functionality
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
If it's numeric fields you are trying to float up, then I would just a make a Summary Maximum (or min or average since you will only flag 1 child perm project as special building 1) where the building is flagged as special building 1.  

If you also need to float up text values, too up to the Parent Project,  I would keep it native and use a reverse relationship.