Percent Progressive bar

Ask the community
1

Hi mates:

As you know, there was a new feature in Airtable about progressive bar. Is there any way to show it in Softr`s fields? because it changes just to the number…

Captura de Pantalla 2023-08-09 a las 17.11.34
Captura de Pantalla 2023-08-09 a las 17.11.341345×207 53 KB

Could be a new feature request… Thanks

1 Like
2

I don’t believe so, but I’m not on the Softr plan with graphs and could be incorrect (please correct me if this isn’t right).

As a work around, you could use a formula field to display emojis to create a sort of process bar that could be displayed in Sofr as a process bar using a text field:

:green_square::green_square::green_square::green_square: (100%)
:green_square::green_square::green_square: (75%)
:green_square: (25%)
:green_square::green_square: (50%)
:green_square: (25%)

3

Thanks @rrthegefsrht for your answer… could you share your workaround to get the result, that I think I can use it in Airtable?? Have you done it with an IF statement??

4 
IF(
	AND(
		{Value}>=0,
		{Value}<25
	),
	"🟩",
	IF(
		AND(
			{Value}>=25,
			{Value}<50
		),
		"🟩🟩",
		IF(
			AND(
				{Value}>=25,
				{Value}<50
			),
			"🟩🟩🟩",
			IF(
				AND(
					{Value}>=25,
					{Value}<50
				),
				"🟩🟩🟩🟩"
			)
		)
	)
)
1 Like
5

Thank you for your help, it worked for what I was looking for. In my case, the values weren’t numerical but depended on a status column, so I adapted the formula and I’m sharing it here in case it helps someone.

REPT(‘:green_square:’, ROUND((IF({Value1} = ‘Done’, 1, 0) + IF({Value1} = ‘Done’, 1, 0) + IF({Value2} = ‘Done’, 1, 0) + IF({Value2} = ‘Done’, 1, 0)) * 25 / 25, 0)) & ’ ’ & ROUND((IF({Value3} = ‘Done’, 1, 0) + IF({Value3} = 'Done, 1, 0) + IF({Value4} = ‘Done’, 1, 0) + IF({Value4} = ‘Done’, 1, 0)) * 25, 0) & ‘%’

1 Like
6

This is how it looks

progress

1 Like
7

We will be adding few more types including progress bar but most probably early next year…

For a quick fix perhaps some formula based html could work ?

1 Like
8

I am a piano teacher and I want to create a dashboard for each student to see their progress for each exercise, + a few other metrics relating to the status of their repertoire. Wondering whether Softr would be a good fit and whether I should wait for progress bars etc to be developed, or whether I should look for a different tool for the job?

9

Early Q1 we will be adding new field types including progress bar

1 Like
10

I just created a progress ring thru HTML and CSS, you just need to map it to a rich-text field in Softr, this is how it looks and here is the airtable formula field i used:

Screenshot 2025-01-16 at 16.57.33
Screenshot 2025-01-16 at 16.57.33632×506 12.7 KB

"<div style='position:relative;width:150px;height:150px;'>" &
  "<svg width='150' height='150' viewBox='0 0 150 150'>" &
  "<circle cx='75' cy='75' r='65' fill='none' stroke='#FFF' stroke-width='10'/>" &
  "<circle cx='75' cy='75' r='65' fill='none' stroke='#4A5568' stroke-width='10' stroke-dasharray='" & 
  (2 * 3.14159 * 65) & 
  "' stroke-dashoffset='" & 
  (2 * 3.14159 * 65 * (1 - {your input field} / 100)) & 
  "' transform='rotate(-90 75 75)'/>" &
  "</svg>" &
  "<div style='position:absolute;top:50%;left:50%;transform:translate(-50%, -50%);font-size:36px;     font-weight:600;color:#4A5568;font-family:Inter, -apple-system, system-ui, sans-serif;display:flex; align-items:center;justify-content:center;width:100%;text-align:center;'>" &
  ROUND({your input field}, 0) & "<span style='margin-left:4px;'>%</span>" &
  "</div>" &
  "</div>"

BTW you can easily create this kind of stuff with the help of any LLM of your preference.

PS: input field must be a number