Why can't I change the label field?

[RedVox]

What is it that might be preventing me from changing the label designation on a table?  I have a members table.  The currrent label is a field called name, but I have another column in the table called invitation_names and would like that column to be the label.   Both name and invitiation_names seem to have identical characteristics both within Appsheet and within the underlying mysql table, so I don't understand what stops me from changing the label.  The table is currently set to allow updates only.   

[Markus_Malessa]

You have to check the label box for invitation_names, then uncheck the label box for name column.

[RedVox]

Yes, and when I do, the preview shows as I expect.  However, after pressing Save, name once again shows as checked for the label field and invitation_names shows and unchecked for label and the preview now shows name again where I want it to show invitation names.  No errors appear.  No warnings or info boxes appear to indicate why the system has reverted to name as label.

[Markus_Malessa]

I can't get it to replicate. All I know is you can't have more than one column marked as label. If you do it will retain the last saved column marked as label when you save. Do you go into the column edit feature or do you use the table under 'Data' and check/uncheck in that designer view?

[RedVox]

I’ve tried it both ways. Same result.

[RedVox]

Weirdly, if I make a vc that has an automation to eqaul [invitation_names], I can set the new vc to be the label with no problem.

[Markus_Malessa]

Interesting. I failed to note that in my specific case my label column is a VC rather than an actual column. That still doesn't make sense though that it doesn't let you change it even with real columns.

[Marc_Dillon · Accepted solution]

Label column has to be visible.

[RedVox]

Bingo!  I wasn't actually using the column directly in any view of this table, so I didn't even notice.  AppSheet is usually so verbose about any issues it's flagged, I'm surprised it's radio silent on this one.  Thanks very much!