I have a set up where a line items portal is displayed on a parent layout.
I have a summary field on the parent layout that totals up a calculation field in line items, in this case it is adding up RSVP's when yes boxes are checked in the portal.
It doesn't update properly unless you click or sometimes hover over the summary field on the layout at the bottom. Like the records are not committed until you click it. I understand this is because portals are what they are - you are sort of "in" another layout (or table) when using them.
Previously I had a modify script trigger on the checkboxes in the portal that acted by going to the layout you are on (the parent one) and commiting records. Works fine when using the database locally but when hosting it and you have lot of records in the portal that trigger means you have to wait quite a long time for it to update when you click the box every time. Painful when going through a list to update rsvps..
Is there another way to do this?
thanks so much.