Automations - Add record to a totals table
I have a list of deliveries in a delivery table. I created a totals table, where if I manually add records to the record in the totals table, I am able to calculate on time delivery. But the proces...
Forum Discussion
Master Table: Totals Table
Has summary Fields for Total Lines, and Calculates OTD through a formula field
Details Table: Deliveries
Has date fields, and and date 1 day in the past is "Late".
So what I have to do, is associate each record in the deliveries table by opening/editing the record, by adding the record number of the associated record in the totals table. I was trying to figure out a way to accomplish this through Automations or Form rules, but nothing seems to be working.
Has summary Fields for Total Lines, and Calculates OTD through a formula field
Details Table: Deliveries
Has date fields, and and date 1 day in the past is "Late".
So what I have to do, is associate each record in the deliveries table by opening/editing the record, by adding the record number of the associated record in the totals table. I was trying to figure out a way to accomplish this through Automations or Form rules, but nothing seems to be working.