How to add various currency units

Hi all,
I would like to allow my app users to set their preferred in-app currency and have the chosen currency set as the units for that user in the number column. How can I achieve that?
In a nutshell, I would like the currency chosen by each user to be specific to that user rather than setting one default currency for all users, as my users are from different countries.
PLEASE HELP

1 Like

You can have the currency selected by the user as a column of the users. Then all your products have to be uploaded with all currencies you are supporting in differents columns.

When you have that workarround working you can force the user to select a currency in their profile and then create an if-then-else column in your products table to see if the user currency selected is euros then ‘euros-column’ if it’s dollars then ‘dollars-column’ and so on for all the currencies.

Then you have to display that if-then-else column and when a user selects euros they will see all in euros and when a user selects another currency then all will be updated for that user automatically.

Hi Adriasoce,

Thanks for your reply, seems like a perfect solution if I was selling products.
But I’m not selling products, it’s a personal finance app, there are a few columns in different sheets that require currency, and there are other columns that are dependent on these columns, and so it would not be possible to create various columns as it would break the flow of functions on the App.

If it was possible for the units section to reflect various currencies or display data from a choice component.

You can. Setting to user row a column of the preferred currency you then can add a template column with the value that you want to show and something to substitute by user->currency.

For someone with euros will display like 2.34 € and for someone with dollars will be displayed as 2.34 $ (with their own values).

In this option:

image

2 Likes

You could, in theory, have a default “value” currency.

Let’s say USD.

Once someone has chosen their currency you could have a Google sheet pick up the current exchange rates from USD, and convert it on the fly. This maybe utterly irrelevant, but thought I would throw it out there as an idea.

It would be a simple lookup and a maths column to convert from USD to their local currency.

It should also work alongside any columns you already have.

Perfect solution! Thank you so much!!

Hi @adriasoce, have you actually tried this? I just tried it now and it does not work. The if-then-else column does not allow multiple units (currencies). Please let me know if you found a workaround.

Are you just wanting each user to have their own currency symbol, or do you also need amounts to be converted to their preferred currency?

The first is relatively easy, the second is somewhat more complicated.

Hi @Darren_Murphy, I want each user to have their own currency symbol. I do not want to convert any amounts. Then I want to append each symbol to various calculations including charts. Charts don’t accept the symbols appended to numbers in a template, so I am unable to use the idea marked as the solution above. I hope this makes sense.

You may need to create several math columns that take in and return the numeric value without any additional math. Each math column will allow you to append a different currency symbol. Then you should be able to use an IF column to return the appropriate math column based on the user’s preference.

Hi @Jeff_Hager, thanks. That’s what I did initially, but the if-then-else column does not retain the symbols/units/currencies from the math columns. It can only take one symbol at a time.

So the IF columns drops off the currency symbol? Are you sure that all returnable values in the IF column are numeric? If even one of them is text, then the entire IF column returns the raw number instead of the formatted number. I actually use this trick whenever I need a raw number where I need to see more than 4 decimals.

Sorry, I don’t think you understand me. The IF column drops off the currency symbol only when I introduce a second IF statement. The IF column is pulling data from the math columns, so all the values are numerical. If you have a minute, please try it out yourself. Just try two currency symbols (e.g. $ and £) in two different math columns, then use the IF column to select each one based on a user preference and see what happens. The IF column also drops the currency symbols when you have two IF-Statements with the same symbol.

Yes, I understand what you are saying now. I’ve never encountered a situation like this before. It’s hard to say if this is a bug or not. The way that I understand the IF column, is that whenever each type of resulting value is the same, then the IF column assumes the same type (text, number, boolean, etc). When you introduce opposing types then I believe that the column assumes a text value for all resulting values. Like you mentioned, when you even have two IF statements resulting in the same column value, then it still loses all formatting, so that part seems buggy for sure. The part I’m not sure about is what should happen if the resulting value comes from multiple other different values. I’m thinking that there might be some sort of fail-safe taking place in case each value has a different precision or unit set. I’m thinking that possibly an IF column can’t reliably assume a data type and formatting when it’s fed multiple different data types and formats with different units and precision, so it assumes that it can only reliably return a raw number or text value. Of course, this is just all speculating.

My best idea right now would be to skip the IF column altogether and instead create multiple charts for each currency and then conditionally show each one based on the user preference. Another thought would maybe involve writing some javascript, but I’m not sure how that would work.

You can always submit a bug report to glide support.
https://glide-help.zendesk.com/hc/en-us/requests/new

image

3 Likes

This sounds like the same issue that I reported a while back…

I’d consider it a bug.

2 Likes

Messy, but brilliant! Thanks for the tip.

1 Like