I have been trying to develop an interactive dashboard and need help to understand how the interactive updates are managed. In other words, what fields are interactive and which ones need to be synced.
My table has a Parent Orders table, a Child DaySheets table and grandchild Materials Used table.
From a list view of the Orders table, the user selects the Order he wants to process.
As soon as one is selected the related Daysheets appear in a second List View.
The user then clicks an inline button that initiates an action to mark the required Daysheets by updating a value in the Select field.
As soon as they do another table view form in the dashboard displays the materials used on that Day sheet, including the quantity, and that shows correctly.
I also need to make provision for Daysheets to be selected but the quantity to be zero so I have created a second field in my Daysheets table called Exclude. Then it’s a simple case of having a VC called Included Quantity with a formula set to If([Exclude]=“Yes”,0,[Qty]).
However, what happens is that the VC doesn’t update until I sync, which basically means the interactive nature isn’t working with the VC.
Is this normal? Do VC’s only update on sync?