How to sum "link to table field" in current year?

How to
#1

Hello, I have two tables - “lidé” and “zakázky” - I’ve set link to table, desired field to sum and in advanced settings I’ve set current year
screenshot of settings:

Snímek obrazovky 2023-10-22 v 12.09.55
Snímek obrazovky 2023-10-22 v 12.09.551630×1193 118 KB

When I’m editing row in “lidé” table, in linked table are items from current year, but sum in table column is calculated without “current year” filter.

Is there a way to aply filter to value in table column?

#2

Hi,
currently it is not possible, the filter you choose in Fixed condition for loading linked table data is only for those records that are in the linked table, it does not add them anymore. The solution may be using WF where you write a script to update the values from the linked records.

With regards, Filip