Consolidated Count from Another Table by Date & 'Shift' Field

Do you need to put the totals in another table, or can you just use the summary bar?

It would be best if I could pull the totals into another table, just not sure how to make that happen.

You could link your records across tables to use rollup fields to summarize your totals.

Otherwise, you would need to use an automation or a custom JavaScript or an external automation tool like Integromat to do that.

Question: do you want [Table 2] to have one record per date with a count field for each type of shift (my recommendation), or one record per date/shift pair?

Oh, I hadn’t even thought about having one record per date with a count field for each shift. I was thinking of having one record per date per shift. Either should work for what I need :slightly_smiling_face:

In that case your absolute simplest solution would be to copy the {Date} field’s value into a Link to another record-type field and use Rollups to total up each shift.

[Table 1] would look like this:

and [Table 2] would look like this:

You could automate the copying of the {Date} => Link field by using a simple Automation: trigger when the {date} field in [Table 1] is updated, add an Update Record step that inserts the {Date} field’s value into the Link field. No script or external tool required.