Iโve been trying to tick the HIDDEN attribute for a column but when I save or save & verify the tick disappears. Any suggestions why this might be?
The TYPE is number, the other boxes ticked are KEY and REQUIRED and I canโt seen anything else unusual.
I had the same problem earlier and got round it by making a new sheet from scratch with the same data and hid the Key column straight away which was working but I donโt know what I did to make it want to appear all the time again.
I think itโs because I didnโt have a UniqueID() formula to set an initial value for a key field.
If you donโt have anything in the initial valueโฆ like formula for example, you canโt hide it because then you are not able to enter the key value. Thatโs why it doesnโt let you hide it.
Should show you a warning each time also
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |