List Related Order Details inline in Orders inline view

[Ryan_Hagler]

I'm trying to do something I'm sure is simple but I can't figure it out.

In an Order Capture app I'd like to show the Related Order Details inline in the Orders inline view. All I need is the Product Name and Quantity to show. I've tried concatenate formulas and list formulas but nothing accomplishes my objective. Concatenate will show the Product ID (but not the name) and Quantities but it will only list ALL Product IDs comma separated followed by ALL quantities comma separated. See concatenate formula below:

CONCATENATE(

[Related Order Details][Product ID],"- ",[Related order details][Quantity],", "

)

I've also tried to deref to get to Product Name but that does not work:

CONCATENATE(

Related Order Details[Product ID].[Product Name],"- ",[Related order details][Quantity],", "

)

Thanks for any help.

Mahalo,

Ryan

[Fael]

Please post a screenshot of your AppSheet database, we cannot figure out which tables and columns are related without the data structure.

Giving it a shoot... I would guess the "Related Order Details" is a VC with only one ref. And it's referred to as an ID which is a ref to another table...?

In this case, all you need is:

CONCATENATE(

[Related Order Details].[Product ID].[Product Name], " - ", [Related order details].[Quantity]

)

However, if "Related Order Details" is a list of products, then concatenate won't work the way you want. Indeed, it would be a lot easier to use a select to list the items in a table list format.

[Ryan_Hagler]

Here's the data sets. Similar to Order Capture sample app. I tried the suggestion above and it does not validate.

Order Detail

The above expression works but returns the below (see "Order Details" column):

Something like that would work (if the Product Names showed instead of Product IDs) but the ideal view for the Order Details column would be: [Product Name] - [Quantity], [Product Name] - [Quantity], [Product Name] - [Quantity], etc.

[Fael · Accepted solution]

My bad. I didn't realize you were talking about the Order Capture sample app.

Pretty simple. Create a new Virtual Column in the Order Details table with the format you want. For example, I created a "Label for Details Inline" with the below code:

CONCATENATE([Product Id].[Product Name], " - ", [Quantity])

Now back to the Orders table, you just need to list the VC you just created, like that:

[Related Order Details][Label for Details Inline]

The final result will look like you want: 

[Ryan_Hagler]

Your amazing !

Just a little note for anyone looking at this in the future. The Virtual Column in Orders table must be Text type, not List. It won't work with List type.

Thanks again Fael!