Refer to list of keys

AppSheet AppSheet Q&A
,
1

Hey all,

It is a very long shot type of question.

I have 3 tables:

  • Order table: OrderID / DeliveryDate / Received
  • OrderDetails table: OrderDetailsID / OrderID / Product / Qty
  • OrderReport table: StartDate / EndDate / List of OrderID (VC)

I would like to get a report of received orders with their details.

In the “List of OrderID”, i have managed to get all the OrderIDs between StartDate and EndDate. But how could i get the details of these OrderIDs into a template for instance?

Any idea is welcome!

Cheers.

Matt

2

Use Start expressions in templates - AppSheet Help

1 Like
3

Hi Steve,

I know of this. I have already used it multiple times.
In my app, i do not have a Ref column, but a Virtual Column with a list of OrderID. How would you make it work?

4

How does a Start expression not give you what you want?