Skip to main content

There are times where I’d like to indicate the expense or cost of any given object in my table with a one-to-five rating using a symbol indicating currency. For example, oftentimes restaurant meals are rating based on cost:€ for inexpensive, but € € € € € for very, very expensive.

Presently, my options are only flags, stars and thumbs-up signs. I’d like at least a $ option, but € and £ and perhaps other popular currency symbols could be used. It could be automatically set based on localization settings.

That would be a fun feature.


In the meantime, you can simulate this behavior by creating a formula field using the REPT function.


In your rating field, choose the number of stars/flags/thumbs, and then in your formula field, you can convert those symbols to the currency symbol that you want like this:


IF({Rating Field},REPT("$", {Rating Field}))

I second this. It’d be a good feature to have.

Reply


Terms & Conditions