Solved: A key problem - Page 2

APJG_Kuroishi · 03-23-2020 11:05 PM

Greetings, aesthetically pleasant fellow of the homo sapiens-sapiens evolutionary branch,
i am presently in a kerfuffle with keys:
I have a sheet and i made an application using that appsheet tool. The system is asking a key column from me, i hereby propose the number of the row column wich the system seem not too keen to accept because it can be misplaced oif whatever.
Thus i propose my barcode column wich, being a coded line concatenating brand - color ID - model, is indeed unique. But i am refused to use it on the pretext that a column containing an algorithm isn’t eligible.
Also tryed with uniqueID() but it is also refused.

What can i do?

APJG_Kuroishi

If you ever find yourself in such a position, here is what i came up with after some researches:

Rule N 1: You cannot setup a column with a spreadsheet formula as a key column.
Rule n 2: You cannot setup a column with a app formula as a key column

So just respect the rules and put your formula (whatever it is) in the Column -> Edit -> Auto Compute -> Initial Value field.
The initial value of your column is now the formula you wanted, and the system accept it.

View solution in original post