Solved: How do I get the main tables view to update when a... - Page 2

anthropaulogy · 07-07-2023 09:44 PM

Hi all,

I have spent a lot of time trying to figure out how to get my main table to update when its sub table or other tables changes/ updates information that relates to it. In my case, I have a main table that has child elements that are quantities of items. I would like to be able to have a field that I use on the main table's View to show the percentage fulfilled. So far, I have only been able to get it to work if I open the main table's form and save it. I have tried using an action on child element that will trigger an action on the main table in attempt to get it to refresh. I have tried using a virtual column, but that doesn't seem to work, and actually when I get it to work once I edit the main table, it reverts back to 0. Currently I have a non-virtual column, but cannot seem to get it update on the main view. Any idea how to get the main view to be able to refresh with the correct percentage?

anthropaulogy

Figured it out. I created 2 decimal columns on the Task Table that hold the sum of the Qty Purchased and Quantity Required. I also made a 3rd column that holds the percentage. When Task Items are updated, it triggers a bot that calls an action on the Task table that fills in the 3 columns with the formulas. For some reason, if I try to calculate the percentage from the table and not the action, it does not work. Anyways, this solves the problem for me.

View solution in original post

How do I get the main tables view to update when a change occurs on the child element?