New Bug Encountered: Reference Error?

[Kevin_Chan]

Hello,

My column STUDENT[Grade] won’t reference the text value but it references the numeric value. In column STUDENT[Grade], it has grade 1-12, PK, and K. My reference column has app formula of [Student ID].[Grade], and it managed to reference all grade 1-12 but not “PK” and “K”. It shows “NaN” for grade “PK” and “K”. Please advise. Thank you.

[Steve]

The Grade column must be type Text or Enum with a base type of Text.

[Kevin_Chan]

@Steve

The Grade column is set to type Text and I can’t use Enum because the grade is based on selected [Student ID]. Please advise. Thank you.

[Steve]

What is the Grade column type in the table referenced by Student ID?

[Kevin_Chan · Accepted solution]

@Steve

It was type Number. I changed it to type Text and it is working now. Thank you very much for your help.

[Lynn]

For those that dont know NaN = “Not a Number”