AppSheet interpreting a virtual field to be part of a key when it is not.

After an AppSheet consistency check, two Virtual Columns of an app are being interpreted as being part of a computed key. They are not  and I have not changed anything in the app.

This is requiring the user to enter values to these Virtual Cols and the form breaks catastrophically.

The Computed key is the concat of columns [DateTimeStamp] and [Ripaq_Id] (Type "text")

One of the virtual columns that appsheet  "thinks" is part of the key is a formula of Ripaq_Id 

SWITCH(Left([Ripaq_Id],1),
"E","Ripa",
"P","Panel",
"2","Tacho","")

The other one is a select of values from another table.

Any hint?

pbalerio_0-1745603542262.png

 

I asked Gemini and says "AppSheet's consistency checks can sometimes lead to unexpected interpretations of column roles, and you've encountered a frustrating issue..."
Gives some clues to solve it but nothing has worked...

 

 

0 3 83
3 REPLIES 3
Top Labels in this Space