when to use . and [ ] in select statement

AppSheet AppSheet Q&A
1

Hi all, I am a newbie to appsheets and struggling with the basic syntax of select expression. I have not been able to find documentation which guides when to use and “.”

example …

[Customer].[Region] , Customer[Region] , Customer.[Region] , Customer.Region

Which ones produce a list and which one gives a specific reference ?

Thanks for your support

2

TableName[ColumnName] generates a list and [RefColumn].[Column] reads the column’s value from the parent record.

1 Like