Airtable Count all Records in a table

2018-10-07 21:55:13

I am making a roster for an online guild and I want to be able to have a metric called "trial participation" for each member, which would be represented as a percentage (x/y, where x=trials member has participated in, and y=count of all trials).

I have one table for members, and another table for trials. I have already figured out how to get x, but can't seem to figure out how to get y (just the total number of records in the trials table)

Does anyone know a function that would allow me to do this? In excel I would use count() or countIf() but can't seem to get them to work in a similar way here