New Bug Encountered: MAXROW() VC not returning a dereference value-auto generating lists in other tables

AppSheet AppSheet Q&A
1

Hi, I just want to make sure that I am not hitting my head against a wall due to a bug.

I am trying to return a value from a VC MAXROW(). Link to post detailing my use-case.

According to thisSample App. Once I make the VC I should be able to dereference it to get a value.

I then realized the list in the corresponds to the VC ref is being generated in another table parent table automatically. Where as the Sample app has the list in the same table. I tred to construct the list myself but it yielded nothing. Is this expected behavior?

2

When you use the MAXROW() expression, the result is a key value from one record depending on your filter. I mean it’s not a list of values. If the column type is a Ref, you can call another column’s value with the Deref expression. You can use it in the same table or another table.

Check first that your MAXROW has a value and then check if it brings you value with the Deref.