Bot editing a specific column in a row, ends up deleting latlong

AppSheet AppSheet Q&A
1

I have a table with a column containing a latlong value, called “Geolocation”, as well as a different column that I use a bot to fill with weather forecasting data, triggered when a new row is input. Whenever the bot does the “set row value” step to fill in the weather forecasting column, it deletes the geolocation column soon after the row is input.

Exorack_0-1687667760401.png
Exorack_0-1687667760401.png313×321 13.5 KB

However, when I set the Geolocation column to “required”, the bot fails to edit the row, recognizing that it does stuff to the column when the bot isn’t supposed to have anything to do with that column to begin with

Exorack_1-1687667876828.png
Exorack_1-1687667876828.png295×635 21.2 KB

2

My assumption is that the bot copies the whole row, edits the referenced column, and then pastes it, but for whatever reason it refuses to do that to the geolocation column, hence deleting it. Is there any way around that?

3

In other words, having any form of latlong data in the table and having a bot edit rows appear to be mutually exclusive