I have multiple users running different test cases and entering test results (pass, fail, incomplete) in a spreadsheet.

There are several test categories and numerous test cases under each one. I need to capture pass/fail/incomplete at the test case level.

I would also like to capture the user/company conducting the test as well as which device they are testing.

Multiple user/companies can test the same device.

I would like to capture all of this information into airtable database to aggregate the results and enable consolidated reporting.

I would also like to setup notification triggers (email or chat) when a test is completed and data is entered.

Is this Possible in Airtable and if yes Please help me.