How to Partition data in appsheet on one worksheet

AppSheet AppSheet Q&A
, ,
1

hi dear

i have 41k row data in one worksheet like this

Mas_Syahdan_Fil_0-1664851331584.png
Mas_Syahdan_Fil_0-1664851331584.png1709×297 31.2 KB

i want to use partition for fast loading, but i want to filter by useremail in colomn email_user

Mas_Syahdan_Fil_1-1664851478307.png
Mas_Syahdan_Fil_1-1664851478307.png1741×166 16.9 KB

can you help me for this problem?

thanks

2

Hi @Mas_Syahdan_Fil

If your issue is about improving speed, I don’t think you need partitioning, but rather using Security filter. Did you try it ?

That will limit the amount of data loaded on device, and increasing app speed too.

You would use this expression:

[email_user]=USEREMAIL()

For reference:

Security filters: The Essentials - AppSheet Help

3 Likes
3

okay thanks, but its possible when i limit row display data in apsheet?

4

I’m not sure what you mean here. However, it’s possible in any case you want.

I suggest you give it a try and let us know if you encounter any issue on the implementation.

It’s in Security > Security Filter > and you apply your Yes/No expression to the table to which you wish to restrict data loading.

1 Like
5

i have 1000 data, and i set 10 data in usersettings()

i want to make with user settings and security filter

its possible to only display only 10 data from 1000 data?

6

I still don’t get it, sorry.

If you mean 10 rows over a dataset of 10k rows, yes it’s possible provided your criteria in the security filter match.

Did you actually try the security filter ?

1 Like
7

i build usersettings like this

Mas_Syahdan_Fil_1-1664873739603.png
Mas_Syahdan_Fil_1-1664873739603.png481×662 17 KB

can be seen there written the amount of data

i have 1000 data, how to limit display data max row only 100 as written in the amount of data column in user settings?

Mas_Syahdan_Fil_2-1664873914012.png
Mas_Syahdan_Fil_2-1664873914012.png1438×757 120 KB

i build like this, but its display error

“Unable to fetch app definition. Error: Data table ‘dbo.View_Report_RekamMedis’ is not accessible due to: The _RowNumber column is not a valid key column as it does not exist in the database.”

8

OK, I think you are trying to implement this:

Advanced techniques: Horizontal scaling - AppSheet Help

I never tried using the row number though, and I don’t know if it’s feasible.

Rather than this, what about using a timestamp instead ?

Let’s say “timestamp” is your row timestamp, you could use:

[timestamp]>NOW()-30

for the last 30 days records in your AND() expression.

2 Likes