Data masking after entry

AppSheet AppSheet Q&A
, , , ,
1

Hi there!
I am looking for assistance on data masking.

what i mean is that, i have a form for users to fill out, however when the user fills it out and it sends back to my google spreadsheet, instead of “A1234567B”, i would like it to be “*****567B” and reflects as such both in app and the spreadsheet.

thank you!

2

AppSheet provides no way to mask input or display.

2 Likes
3

Yes, rightly to say, it is impossible with Appsheet.

1 Like
4

Hi!
thank you for your and @Koichi_Tsuji ‘s prompt reply and sorry for my late reply..

Noted on the above. In that case, would there be a way if the app then just registers the last 4 characters of the user’s input into the form, regardless of their length of input?

eg.
User inputs “abcdefghlmn” into form, appsheet registers/takes in only “hlmn”

or

User inputs “1234567890” into form, appsheet registers/takes in only “7890”

thanks once again for your replies!

5

Both, masking or trimming of user input can only probably be achieved by:

  1. Saving user input in a column.n
  2. A form saved action saving the calculated masked/trimmed value in another column, then blanking out user’s input from the original column
  3. In all of your views, other than the form, show the calculated column instead of the now-blanked user’s input column.
1 Like