Let's say I have three tables, or three databases: Families, Services and Report. The Families table has a key called Family ID, and has virtual columns with initial month of service, initial year of service, final month of service and final year of service. The Service table also has its Service ID key, but it also has a column called Family ID that references which family or row in the Families table it is linked to, and also has two virtual columns with month and year of service. The Report table has the IDRAF key that concatenates month and year from two columns called month and year. When I fill in a new line in the Report table, one of the columns needs to have an appsheet formula that calculates: Number of Families with 1 or 2 Services according to the month and year indicated in the Report.
LinkedIn
Twitter
