How to add serial numbers in the filter and type list columns
and formula in "rincian hasil pencarian"
filter("laundry",
IF(
AND(ISBLANK([dari_tanggal_masuk]),ISBLANK([sampai_tanggal_masuk]),ISBLANK([pilih_nama]))
,false,
AND(
IF(ISBLANK([dari_tanggal_masuk]),true,[tanggal_masuk]>=[dari_tanggal_masuk]),
IF(ISBLANK([sampai_tanggal_masuk]),true,[tanggal_masuk]<=[sampai_tanggal_masuk]),
IF(ISBLANK([pilih_nama]),true,contains([nama],[pilih_nama]))
)
)
)
There is no AppSheet provided sequential numbering and in a distributed system such as AppSheet, it is not advised.
You would have to implement your own applied numbering to dedicated columns in the table. Sequentially numbering Filtered rows is very implementation heavy and if you have more than one user adding rows and/or viewing the filtered rows, it is next to impossible to keep them properly numbered.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |