Forum Discussion

TylerParker's avatar
TylerParker
Qrew Assistant Captain
6 years ago

Need the total of one field to show as a value in another field

I'm trying to have the totals from the Hard Acceleration/Hard Braking/Speeding/Idling fields show up as the value in separate fields in the same table. I started with the Hard Acceleration Total field...
APIs and custom code
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
You would need to have a parent record for the event in a relationship where 1 Event has Many employees.  Then on that relationship it will let you make a summary field.  Then look up that summary event total back down to the child records.
JengWata's avatar
JengWata
Qrew Trainee
3 years ago