Dereference refuses to find everything above column Nr. 93. Is there a limit?

[stefanasks]

I have a Table with 45 regular columns and 53 virtual columns. However, on the first attempts to dereference to this large table, AppSheet refused to find one particular column near the end of the columns. After a while of trying and testing I figured out that AppSheet refused to find ANY column of any type above column Nr. 93.

Is there a limit?

[WillowMobileSys]

No, no limit.  I have tables with 150 "normal" columns plus Virtual columns and they work just fine when dereferenced.

Make sure you have properly regenerated the table.  if you have then please, show us your expression, the referenced table and the actual error message you are getting.

[stefanasks]

Parent table "Table_Contract" has an auto-generated column "Related Table_Reports" in AppSheet editor position 45. And a virtual column "_lastVisitedReports" in position 96 with type List, element type Ref and Referenced table name "Table_Report" with this expression:

select([Related Table_Reports][ID], and([is_active], [date] = max([Related Table_Reports][Date])))

Child table "Table_Report" has an action to set "the values of some columns in this row" with this simple test expression:

// works for column nr. 45
count([Table_Contract].[Related Table_Reports])

// does not work for column nr. 96
count([Table_Contract].[_lastVisitedReports])

Error messages:
Error in expression '[Table_Contract].[_lastVisitedReports]' : Unable to find column '_lastVisitedReports'

Data action 'New Action' uses an invalid new column value expression '=count([Table_Contract].[_lastVisitedReports])'. 
Error in expression '[Table_Contract].[_lastVisitedReports]' : Unable to find column '_lastVisitedReports'

Moved the expression into to the "Table_Report" directly, but did not work either. Changed column "_lastVisitedReports" to type Text, but same error. Renamed the column, no change. Regenerated both tables with no success.

Tried other columns with no problems, -except- every column above column nr. 93. No matter the type. So that I came to the conclusion that there must be some sort of a limit.

[Steve · Accepted solution]

Is Table_Contract a Ref to a slice? Does the slice include the _lastVisitedReports column?

[stefanasks]

Table_Contract and Table_Report are the main tables.

[stefanasks]

Steve, your were right. The column Table_Contract in table Table_Report was indeed a ref to a slice. Problem solved!

[stefanasks]

I made a copy of the app. If a staff member is interested to have look into the issue, let me know and I will share it.

In the meanwhile I continue with a workaround.