Virtual Column mismatch between UI and server?

AppSheet AppSheet Q&A
1

I have a test Virtual Column in the UI that uses the expression:

UNIQUE([ReportTask_Fields_Included][Entity])

The column “ReportTask_Fields_Included” is assign by a user in an EnumList/Ref column. The VC is showing the expected values in an Inline table like this:

Screen Shot 2022-06-03 at 11.42.09 AM.png
Screen Shot 2022-06-03 at 11.42.09 AM.png345×343 20.9 KB

However, in testing an API call on the server (see image below), I am finding that this same VC column on the data submitted to the API call is blank while a second (below this one in the image) DOES reflect a value using same expression. The only difference between these two is that the first one is using a “normal” EnumList/Ref column while the second is based on a “Related” VC column (a different table).

Edits are being applied to the server as I have EditDateTime column which reflects updated info. I have had made sure there is nothing clearing the data.

This seems to be a bug or am I missing something?

Screen Shot 2022-06-03 at 11.43.36 AM.png
Screen Shot 2022-06-03 at 11.43.36 AM.png372×356 28 KB

2 Likes
2

Not sure but could this be related to when you’re using the API or scheduled bots, UserEmail() is blank? Only asking as this stumped me a few times and I’ve had to adapted a lot of formulas to allow for where ISBLANK(UserEmail())