Creating a progress bar within a table

Hello!

I have a small tutoring company and I use Airtable to manage my students. In my base, I have a main overview table with all my student’s information and a separate table for each student where I track individual progress. On these individual progress tables, each cell is a checkbox where I can click once a student has completed a given task. Is there a way to add a progress bar (represented by a percentage or fraction) into my overview table that updates as more checkboxes are clicked on the individual progress tables? I want to be able to have a big picture view of each students progress.

Here’s one you can try.

2 Likes

That’s a good one. Here’s one that’s much simpler, it assumes you have a separate field called “Progress” that calculates the percent progress.

CONCATENATE(
  REPT("█",({Progress}*10)-MOD({Progress}*10,10)),
  REPT("░",10-(({Progress}*10)-MOD({Progress}*10,10)))
)