Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Calculating payments and tying that back to a user

Topic Labels: Base design
365 1
Showing results for 
Search instead for 
Did you mean: 

Hi all,

I’m wondering if Airtable is a good fit for managing our student share flat expenses. Currently we use icloud numbers, to enter raw values and show, but it is cumbersome and manual. This is what I have in mind:

  • People Table: All people are stored here and cross referenced. Sometimes people move in and out, or go away for holiday, so don’t need to pay power bill for example.

  • Powerbill Table: Our powerbill is calculated everyday automatically. We have an app which shows how much power was used for each day and input into the airtable. For each day I can enter the $ value of a day. This is then divided into payees of two sorts, heat users, non-hear users, depending on if you use electric blanket that day. The issue I have right now is that I do not know how to tie that back to the person, as an outstanding fee.

Thanks for following through that and hopefully it wasn’t too confusing or abstract. Appreciate any opinions!


1 Reply 1

Hi Nate! This looks like a great setup. Next, I’d try adding a rollups field on the People table that reference the PowerBill Data linked record field > the two formula fields on the PowerBill Data table. The Rollups’ functions should be Sum(values).

This :arrow_up: will make a bit more sense once you’re configuring the Rollup field. A bit more context on this field type here.

Let me know if this helps!