Hello…
Today i have create report on my apps.
In myapps editor, number sort from smalles to large ( 1…3 )
But when i create report, the number is random…
the formula is
how to make report with number not random ( same with apps editor )
thank you
Deddy
Please try expression as under No column in the template as
<<Start: ORDERBY([Related ta_ass_detils], [ta_detil_line], FALSE)>><<[ta_detil_line]>>
For reference:
Hello…
Thank you for your help
And i will try it
Hello @Yayasan_TL_BP how have you managed to insert numbering in your report, I think there are many of us who are looking for this and we have not achieved it yet, could you explain the steps to follow? Thank you so much.
Manual or
[Serial Numbers, If You Must](https://community.appsheet.com/t/serial-numbers-if-you-must/19325) Tips & Tricks ?
Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …
Hi @wsaico ,
If you are dealing with a related table and if your key column length is fixed, then you could use the following expression to generate the serial numbers in the template.
The following example ( divides the result of FIND() by 11) works for a key column created with UNIQUEID() - 8 characters in the child table.
<<Start:[Related Table IDs]>>
<<(FLOOR(FIND([Related Table Key],[Related Table IDs])/11)+1)>>
The above expression needs to be in the first column. An example highlighted in RED from a sample app below. In this template “Order Details” is the child table of “Orders” table.
@Aleksi has another wonderful approach
[Running serial number report](https://community.appsheet.com/t/running-serial-number-report/26120) Questions
Hello, In PDF report, has table of records. In that I need to have running serial number for each row. Pls help me, how to add that? [image] Thanks, Senthil
Thank you very much for your help, I saw that this trick also works
[Numerical order column in pdf](https://community.appsheet.com/t/numerical-order-column-in-pdf/53030) Tips & Tricks ?
Numerical order column in pdf [Học AppSheet/ Automation/ Đánh số thứ tự cho bảng ở bản in PDF - YouTube]