Hello All.
In table A I have all of my outbound communications listed. In this table there is a field called "Month Sent", this field is used to link table A & table B. Table B contains the aggregations of all the communications sent per month (Month sent, Total sends, Total opens, percentage opens, etc.).
I want to show the metrics for the communications for each format type per month (i.e. email, SMS, etc.). The ideal way of doing this would be to somehow have a single select field for the format in table B which whenever changed automatically causes that record to calculate the number of communications for that format only and update the record accordingly.
I know there is an option in the roll-up to add a condition, but that would mean creating a different view and roll-up condition for each format. In Google sheets, I simply had a table, combo box and if statement that read something along the lines of IF the combo box is equal to the format then add to the count.
Is there a clever way to do this on Airtable too?
I hope I have explained this adequately.