Re: How to show data (in the interface) of multiple tables

1696 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have an airtable dataset that includes:

  • Customers: all the information about customers
  • Trainings: all the information regarding each training (including the date)
  • Inscriptions: that combine Trainings and Customers and also add extra info (e.g. how much the customer payed for the training)

I want to build a Dashboard Interface where someone could state a “start date” and “end date” and the dashboard would show:

  • All the trainings in those dates: this seems easy, just used a grid of trainings filtered by those date inputs)
  • The total of revenue from those Trainings

In the last bullet, how can I get the SUM of the revenue from all inscriptions in the trainings that are filtered by those dates?

Thanks a lot

1 Reply 1

Hi Antonio, I’ve set something up here for you to check out

interface sum

The idea is to add a rollup field to the Classes table that sums the amount per class. Then, in the interface, we create a Count element that will sum on that rollup, and connect it to the filter we’ve got set up for the grid

(Not too sure if I set up my base to be the same as yours; let me know if you hit any issues)