How to Partition data in appsheet on one worksheet

[Mas_Syahdan_Fil]

hi dear

i have 41k row data in one worksheet like this

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

can you help me for this problem?

thanks

[Aurelien]

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

[Mas_Syahdan_Fil]

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

[Aurelien]

---

@Mas_Syahdan_Fil wrote:

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

---

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.

[Mas_Syahdan_Fil]

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?

[Aurelien]

---

@Mas_Syahdan_Fil wrote:

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

---

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 ?

[Mas_Syahdan_Fil]

i build usersettings like this

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?

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."

[Aurelien]

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.