I have developed a database which tracks members and instruments of a music club. Now I need to build a synced base for the treasurer to use which records membership subscriptions. I have synced the list of members into the first column and their contact details in other columns. To the right, I have one column per month to record subscriptions paid. The treasurer will insert a floor or amnesty date in a column, before which subs will not be charged. In a column after the Months, I want calculate the number of months owing after the floor. Struggling to get my head round it. Any ideas? I would be grateful for suggestions.I suspect I ned a spreadsheet for this really, but would love it all to work alongside the membership database in Airtable.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.