Insert current location which should be not edit. EDIT_IF not possible when using AppFormula: HERE()

AppSheet AppSheet Q&A
1

Hey All,

I am building a simple inventory WebApp.

When entering a new record (or row) I would like to insert also the current location.

To do so I have created a column in my google sheet named “Location”…set the Type to “LatLong” and used the AppFormula: HERE().

So far so good.

Now when I want to edit my entry later I want my “Location” to be unchanged.

For this I have tried to use a EDITABLE_IF statement but I am receiving a warning this option cannot be used in combination with a AppFormula: HERE()

Is there a way to circumvent this…or is there another way to enter the current map location besides using AppFormula:HERE()

Your help would be very much appreciated.

2

Please use the expression HERE() in the :initial value" setting of the column. Please also ensure " Reset on edit" setting is set to off.

3

My oh my.

It was that easy. Thank you very much

1 Like