Column grouping inline view on form display

Hi Guys and Gals,

I have a very basic order form where I display an inline view to view previous sales of the specific customer I select. I've done this by using a slice function.

Rodney_Reid_0-1716185074785.png

Rodney_Reid_1-1716185117004.png

Rodney_Reid_2-1716185164024.png

I used a ref view to display the information more clearly, by sorting and grouping the data. The issue that I'm sitting with is that my product column, although set to group in the reference view, does not group and only gets sorted. 

Rodney_Reid_3-1716185209311.png

If I remove the row number data field from the Group By then I have blank lines between the Product line, but then the product field groups correct.

Rodney_Reid_4-1716185982405.png

Any idea where I can start looking or ideas on how to correct this?

 

Tx,

R

 

 

 

 

1 3 109
3 REPLIES 3

Try the option 'Select All'  into the FORM_ORDER_HISTORY slice

Unfortunately has no effect. 

You could use the default group by option to group by products from the table view that you have already implemented.

Then you could use the sort option within the table view and ask users to sort by product whenever necessary. The image below shows sorting by the [Order Total] column in the table view, highlighted in yellow, On the left is grouping by Customer Name followed by the order status, highlighted in red.

Suvrutt_Gurjar_0-1716269069994.png

The group by options in the table are as follows in the example above.

Suvrutt_Gurjar_1-1716269206932.png

Additionally, if the users do not need to sort the table view elsewhere in the app, you could simply disable the table sort option for the users and set a default sort by product in the table view.

Suvrutt_Gurjar_2-1716269296951.png

 

Top Labels in this Space