No error if Key item is set to Number type and Uniqueid is specified as the initial value.

[takuya_miyai]

There is no error in the configuration, but a user operation produces a puzzling error.
Is this a bug?

 

 

Essentially, I believe that the evaluation of UniqueID should result in an error for column types other than Text.
This is especially confusing for citizen developers.

@Steve 
@Koichi_Tsuji 

[Steve · Accepted solution]

Definitely a bug. Escalated.

[11148]

IDをテキストにしたらどうですか？

number type change text type 

[takuya_miyai]

@11148 
That is correct as far as workarounds go.

I believe the problem is that Expression of type Number is not an error even though the return value of UNIQUEID() is text.

[Steve]

As I think about this, I wonder if Expression Assistant assumes that a Text value could contain a value that could be interpreted as a number, so it chooses to defer making a judgement until the column actually has a value. This would actually be in-line with behavior elsewhere in AppSheet. Maybe not a bug; maybe we're just expecting/wanting stronger data-typing than is actually provided.