Very interesting task I have a table “Client Pack” with fields: Client,Seminar,“Quantity of Participants” and some other like “New client” checkbox, payment sum etc. “Quantity of Participants” is FlowField: Count(Participants WHERE (Client=FIELD(Client),Seminar=FIELD(Seminar)) “Participants” is table consists of three fields: Client,Seminar and Name I have a form with table “Client Pack”. I can define any filters (such as “New client” etc) and I want to get sum of participants (sum of “Quantity of Participants” column) with my defined criterias. How could I do that? Usage of SumIndexField would be very refined solution, but i can’t use SIFT over FlowFields (
I find it a little confusing to fully understand your problem, but here goes: The logical way to do this would be using FlowFilters in the “Client Pack” table on which you could set filters. The FlowFilters would then be used on the Calculation formula of the “Quantity of Participants” FlowField. For this to work, the table “Participants” would have to be expanded with the extra fields on which you want to perform filtering. Look, for example, at the standard table 27 Item, field 68 Inventory. This is a FlowField whose value depends on several FlowFilters. I hope this points you in the right direction and doesn’t make a bigger confusion [:)]