Km / mi ... How to choose?

Hello,

I am using the DISTANCE() equation in my app.
From what I’ve read it’s only in km?
Can I not give the user a choice to choose between km & mi in the USERSETTINGS() area?
For example, ENUM (km), (mi), which would then dictate a km or mi expression?
Is there any way to control which one is being used in the app?

EDIT:
If AppSheet is default km for ANY user, regardless of USERLOCALE() that would be awesome.
If so, I can make a user setting option km / mi, and if the user chooses mi I can add an IF formula for km * 0.621371 or another virtual column with that equation alone.

Can I know…

  1. Does AppSheet have a default metric unit for all users, regardless of user locale settings?
  2. If not, is there an expression to detect user locale for metric settings?

Thank you.

0 2 378
2 REPLIES 2

It seems DISTANCE() is km regardless, so I created a virtual column for km & mi (with km * x = mi) formula. Used USERSETTINGS() to dictate which virtual column to use.

Yes that’s correct, distance is always as km.

Top Labels in this Space