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.
Solved! Go to Solution.
Definitely a bug. Escalated.
Definitely a bug. Escalated.
IDをテキストにしたらどうですか?
number type change text type
@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.
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.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |