Error when i'm doing INDEX of another table

Hi Team,
why this expresion “index([tercerPlatList], [_rownumber]-1)” runs properly,
but not “index(llistes[tercerPlatList], [_rownumber]-1)” in other table (llistes)?

thks in advance.

@J_jvs The syntax TableName[MyColumn] will return the entire list of values in the column. It looks like [tercerPlatList] is already a list column, so llistes[tercerPlatList] returns a list-of-lists, which is probably not what you wanted.

I don’t know the full details of your scenario, but it looks like you’re trying to keep the data in two tables aligned via row numbers. That can get tricky, because the orders of your rows can change and you can end up writing complex formulas that are hard to maintain. You might want to take a look at creating references between tables. If you use references, then the system will take care of creating the appropriate “related rows” formulas for you.

Here are some pointers to get started:
Data essentials
References between tables
Example app: https://www.appsheet.com/samples/A-basic-demo-of-table-references?appGuidString=6ffad040-b04a-4325-aa73-ace5df8ba1b5

4 Likes