Converting Feet to Meters or Meters to Feet

expressions
(George Joseph) #1

New Community looks awesome!!

I have 2 columns, one feet and one meters, how can I have either one calculated once information is entered into the other?

(Aleksi Alkio) #2

If you have a metric column, just calculate it like [Meter]*3.2808399

(George Joseph) #3

Hi Aleksi,

I want it to be bi-directional. So it the users enter feet in the feet column the Meter column is updated and if the user enters meters in the meters column the feet column is updated. I’m thinking I may have to create virtual columns for data entry and have the actual columns calculate the data.

(Aleksi Alkio) #4

You can’t entry data for the virtual column manually, they are meant for calculation only.

(George Joseph) #5

Slapping my head! Where did that thought come from…

(Levent Kulacoglu) #6

@gpjoseph
You can’t do it bi-directional as it will invoke a circular dependency error. But you can do it like this. Click on your name in the home screen…

(Aleksi Alkio) #7

No worries… it happens sometimes :smiley: