Something must have been changed recently on the way AppSheet handles “Key” values and the way they work with virtual/compute values.
I have a compute key that spits out a reference name, and is set as the “Key” value so that the contents can be referenced by other worksheets. Previously, I was able to edit the original data value (if compute value = original value, I can still change the original value and the compute key will also change). Now, however, the original value is not directly editable via AppSheet and I must now change this information via back-end processes. (the field is grey’ed out)
As soon as I disable the key for the virtual column, the field is again editable but I lose my references functionality.
Am I missing something here?
Any help appreciated!