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

[robbertzalm]

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.

[Suvrutt_Gurjar · Accepted solution]

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

[robbertzalm]

My oh my.

It was that easy. Thank you very much