Updating a reference table without going into it.
I have two related tables. Trips and Bookings. A trip can have many bookings, but the booking can only have 1 trip.
Example: Miami trip May 2018
Booking 1, Mr Smith (reservation for 5)
Booking 2, Ms Jones
(reservation for 2)
- Booking 3, John doe
(reservation for 1)
On the Trips table, I have an app formula that sums headcount based on a field in the bookings table (in this example, total of 5+2+1 = 8 persons).
From what I understand, the app formula will only recompute the value, if I go into the trip open and save it.
So my workflow would be: 1. Create booking 2. Go into to the trip, open and save.
I want to create a behavior that will trigger step two, when I save the booking. Possible?
Thanks in advance.