Jun 19, 2021 05:15 AM
I am new to Airtable. I am building a tool to collect behavior incidents in the school where I am Principal. After testing multiple tool, I came to the conclusion that I need to create my own application and Airtable expends the possibilities.
Here is what I am trying to achieve:
how can I do that ?
Jun 20, 2021 12:39 AM
You need to bring all the numbers you want to add together into the same table using lookup fields, which look up those numbers from the records you’ve linked to in the other tables. Then use SUM({Number 1}, {Number2}, {Number 3}) as your formula. Could you share some screenshots/a blank template?
Jun 21, 2021 03:22 AM
Here are some screenshots, I am new at Airtable so I am not sure how to do what you are describing. Thanks you so much for your help. The possibility are endless with this database system.
This tab is the incident report tab where we select the incident type and it adds the “points”
In this type we are listing all types of incidents including the weight they have (point)
In this one we have all the information about our students which is used when you work on reporting an incident, I would like after the list of the incident on the right to add the total point they have.