i would like to hide my key field (random set...

(Jacob Danniel) #1

i would like to hide my key field (random set of numbers) from showing in my slice.

i keep getting an error when saving. appsheet says that the key field is required in the slice view.

how do i hide this field from detail view?

(Praveen Seshadri (AppSheet)) #2

If your key has an initial value (eg: UNIQUEID()) then it can be hidden. Are you expecting the app end-user to fill in the key value when adding a new record? It sounded like you were planning to have an automatic key value assignment.

(Jacob Danniel) #3

I have auto key assignment. The user doesn’t need to enter or edit it or see it.

Ill try to hide in the table view again. Ill send u screenshot of error i get

(Jacob Danniel) #4

contains Primary Key ‘ID’ which was ‘Hidden’ but does not have an Initial Value. Resetting the ‘Hidden’ attribute for ‘ID’ because tables using this schema allow new rows to be added.

(Praveen Seshadri (AppSheet)) #5

Ah … note that it says it does not have an Initial Value. So it looks like you may not have set p the automatic value assignment correctly.

In the column definition, you need to assign an expression to InitialValue

(Jacob Danniel) #6

@praveen OK whats the expression look like how do i do that?


(Praveen Seshadri (AppSheet)) #7

Please see help.appsheet.com - App Formulas and Initial Values to understand the meaning of an InitialValue. Use UNIQUEID() to generate unique key values. Also see https://help.appsheet.com/app-design/spreadsheet-design/manually-generating-uniqueid-key-values for alternatives App Formulas and Initial Values help.appsheet.com