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.
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
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?
In other words, having any form of latlong data in the table and having a bot edit rows appear to be mutually exclusive
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |