Donate
Want to use this formula?
+ Either duplicate this page and change the "Pages" and "Pages Read" property names to suit your database. OR
+ Create or temporarily rename two properties in an existing database called "Pages" and "Pages Read", copy and paste formula below into a new formula property, then return the properties to their original names (The formula will automatically update).Slider
Formula
if(prop("Page Read") / prop("Pages") == 1, "┅┅┅┅┅┅┅┅┅⚫" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .9, "┅┅┅┅┅┅┅┅⚫┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .8, "┅┅┅┅┅┅┅⚫┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .7, "┅┅┅┅┅┅⚫┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .6, "┅┅┅┅┅⚫┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .5, "┅┅┅┅⚫┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .4, "┅┅┅⚫┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .3, "┅┅⚫┅┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .2, "┅⚫┅┅┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .1, "⚫┅┅┅┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", "┅┅┅┅┅┅┅┅┅┅ 0%"))))))))))
Simplified
concat(slice("––––––––––––––––––––", 0, 20 * prop("Pages Read") / prop("Total Pages")), "⚫", slice("––––––––––––––––––––", 0, 20 - 20 * prop("Pages Read") / prop("Total Pages")), " ", format(floor(100 * prop("Pages Read") / prop("Total Pages"))), "%")
Customization Example
Colored Slider