Solved: Auto-generate Transaction No with security filters - Page 2

Rome18 · 03-13-2022 12:49 AM

Hi There

I have a normal Expense Table with a Transaction Number Column.

I give this [Transaction No.] a formula to auto compute it with a very simple formula like [_rownumber]-1 (and some formating using concatenate).

What I am asking is, it seems if I add security filters to the table to only show their own user's data, this formula does not work, the formula calculates individually for every user (even though the first data of Users B is on row 20 the result of the formula is still 1. It supposedly generate number 19).

Is there a way to auto-generate this [Transaction No] as a whole data? not as individual data.

Thank you in advance

I am still new in this Appsheet environment 😄

Suvrutt_Gurjar

Hi @Rome18 ,

Hope you were able to take a look at the article shared and the section below.

I am sorry that I have no further inputs in this regard.

Please evaluate Google sheet based approach shared by another AppSheet expert @Koichi_Tsuji

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Auto-sequential-numbers-using-Googlesheet-formul...

Someone else may have solution for your requirement of non repeating serial numbers in multi user environment with AppSheet expressions.

View solution in original post