Hello,
By selecting a date range in the parent table’s detail view with quick edit a certain selection of items are created and shown in a related child table (child 1) in the parent detail view.
This parent table is also related to another child table (child 2) of which another related table view are shown in the parent detail view.
Depending on the date range selection made in the parent view, certain totals need to be calculated for each related item in child 2. To do this I created a back reference in child 2 for the parent table pulling in the ref list virtual column with the selection of items from child 1. Using an IN formula I can now generate the totals in child 2.
My problem - There is a delay in the back reference of the child one selection to child two causing a delay of about 30s to 1m for the totals to adapt in the parent detail view in the child two table. The delay does not appear to come from making the selection or calculating the totals.
Any way around this delay?
Thanks
Just curious… is there any reason you don’t calculate those totals in parent record?
Hi Aleksi,
Yes, the reason is because they need to be calculated per related and relevant child table item. In parent view I only have a list of those child items. I cant see how I can perform a conditional sum select on a list. Let know if I am making a thought error.
Thanks
I may have misunderstood but if there is only criteria (i.e., date range set in the Parent), can you not keep those sums in VCs in the child1 table and pull them into VCs in child2 table using SELECT formula taking advantage of the common parent row key value? Then you can access both child VCs in the parent.
@Hyman_van_Zyl You can calculate the sum in the parent table like…
SUM([Related Child Records][Price]).It will calculate all values from the Price column (or what ever column type that is) that are related to your parent record. If you need to filter that virtual list, you can do that as well. The the syntax could be something like this…
SELECT([Related Child Records][Price],[Date]<TODAY())
Hi guys, thanks for the feedback.
I think I am struggling to explain. If you still interested, here is some more details.
I have a Project, Budget, Financial Category and Transaction table.
In the Budget table each project receives many budget items with amounts and a financial category.
In the Transaction table each project receives many transaction items with an amount and financial category.
In a project report I can show without problem the transaction balance, total transactions in and total out, all related transactions, total budget, all related budget items as well as a category budget report displaying a unique list of categories for that project with their summed budget items and a category transaction report based on the budget table displaying a unique list of categories for that project with their summed transaction items.
What I am struggling with is the following. I want to enable my users to filter the above reports by a start and end date. So the report only display transactions and totals of transactions for that period. So in the detail view of the project a user can quick edit the start and end date and all the affected sums and lists will update accordingly. To filter the transactions list according to category for that specific period I back reference the transactions list generated by the period, or even the start and end date themselves, to the budget table and then apply that to the category transaction sum selection. This works fine but takes about 1 minute to update in the project report. Based on Aleksi’s advice of checking the analysis detail it looks like the app syncs in the background each time I change the period and that is causing the delay. I tested this by syncing the app immediately after making a change and that does update the totals.
I was just wondering if there is a way around that delay or having to sync the app.
I hope this makes sense?
Thanks lots,
Hyman