Updating a reference table without going into...

[Emma_Nixon]

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.