issue with the start expression example from the docs

AppSheet AppSheet Q&A
,
1

Hi, I’m new to appsheet, right now I’m making a template, however, when I try to do my start expression like google did in the example from this doc it fails

start expression from appsheet docs
start expression from appsheet docs1367×466 33.5 KB

that doesn’t work for me, is [Order Details] the name of the table?

the way it works for me is if I apply a filter to the expression like this(from my own dataset):
<<Start: FILTER(“quote_detail”,[quote_ID] = [_THISROW].[quote_ID] )>>

in the end I’m able to achieve what I want for this case, however, I’m trying to do a “group by” and the one example I find is using the start expression without the select as well so it’s not working for me.

Please any advice or guidance will be appreciated.

2

For grouping you would need to wrap the existing Start & End with another Start & End and one way to do it is to have it outside of your existing table.

3

It’s the name of a column that has a list of ref values from a table. In this case, the order items or detail. You can compare it to the “Related something” virtual columns that are created when you create a reference to another table

1 Like