Row order of a child table is messed up!

[Jin_Tan]

Hi,

I have a parent table and a child table where the child table is a part of parent table. The data which is chosen to enter into child data is based on a third table.

This is the problem:

When i enter my data into child table according to the row order i want. When i click save and check the row order, it shows different row order.

Does anybody know why is this happening?

[Mike_A]

Have you checked how the sort order is set up in the View for your child table?

[Stefan_QREW]

You might check the sort on the Inline Table View for the cloud table. Sort by rownumber or time-stamp if you have one. This is a system generated view and may be hidden until you press the “show system views” text in the UX >> Views tab.

[Steve]

The order the rows are displayed within AppSheet is controlled by the configuration of the view displaying the rows. The order or the rows in the spreadsheet has no effect on the display order unless you tell AppSheet to keep that order.

[Jin_Tan]

It has no issue in my UX. I have issue in my report as it does not print according to the row order i want.

[Stefan_QREW]

In your report, you will likely need to specify row order through an Orderby() expression inside the Start: expression in your report template.

There is some documentation on this if you search start: expressions on help.appsheet.com

[Aleksi]

May I ask what SELECT expression are you using with your Start: expression?

[Jin_Tan]

Hi Aleksi,

I am using <<Start:[Matching Items]>> …<>

The formula to calculate [Matching Items] is this:
SELECT(
D.O.Invoice[D.O.],
AND(
[Supplier]=[_ThisRow].[Supplier],
[Date]>=[Date Start],
[Date]<=[Date End]
)
)

[Aleksi]

As Stefan proposed, you could use ORDERBY expression before the SELECT. Something like…
ORDERBY(SELECT(D.O.Invoice[D.O.],AND(…)),[Timestamp],FALSE)