Substitute plain text password to asterisk in appsheet

[Ining]

Dearest and very good afternoon to you sir. Here I am humbly seeking your help sequel to this appsheet workflow. This app for your kind info needs User credentials to log in prior using the app. Now regard to this the credential are stored in “DATA.gsheet” comprising credential details for respective users.

Now following that I have successfully created the LOGIN and LOGOUT for the app via “User Setting” and here below are the details vide “_Per User Setting”

Row 1 : Name default as “Options Heading”, Type as “Show” and content for show formula as

“IF(

  ISBLANK(LOOKUP(USEREMAIL(), "DATA", "EMAIL", "PHOTO_URL")),

  "<URL Removed by Staff>",

  LOOKUP(USEREMAIL(), "DATA", "EMAIL", "PHOTO_URL")

)”.

Row 2 : Name as “UserName” of TEXT type,

Show_If formula: “ISBLANK(lookup(usersettings(UserName),"_Per User Settings","UserName","Name"))”

Valid_If formula :

“AND(

ISNOTBLANK([UserName]),

IN([_thisrow_after].[UserName],DATA[USER]),

ISNOTBLANK([Password]))”

Invalid value error formula: “IFS(

NOT(IN([_thisrow_after].[UserName],DATA[USER])),"UserName Not Found",

ISBLANK([Password])," ")”.

Row 3 : Name as “Password” of TEXT type,

Show_If formula: “AND(ISBLANK(lookup(Usersettings(UserName),"_Per User Settings","UserName","Name")),[Password]=<>lookup([UserName],"DATA","USER","PASSWORD"))”.

Valid_If formula:

“[Password]=Lookup([UserName],"DATA","USER","PASSWORD")”

Invalid value error formula: "Wrong Password Please Try Again"

Required_If formula: “IN([_thisrow_after].[UserName],DATA[USER])”.

Row 4 : Name as “Name” of NAME type,

App Formula = “Lookup([UserName],"DATA","USER","NAME")”

Row 5 : Name as “Level” of TEXT type,

App Formula = “Lookup([UserName],"DATA","USER","LEVEL")”.

Row 6 : Name as “Role” of NUMBER type,

App Formula = “Lookup([UserName], "DATA", "USER", "ROLE")”

Row 7 : Name default as “Option 6” of Show type,

Show_If formula = “ISNOTBLANK(Lookup(Usersettings(UserName),"_Per User Settings","UserName","Name"))”

Row 8 : Name as “UserPosition” of TEXT type,

App formula = “Lookup(USERSETTINGS("UserName"), "DATA", "USER", "POSITION")”

Row 9 : Name as “UserReporterEmail” of EMAIL type,

App Formula = “Lookup(USERSETTINGS("UserName"), "DATA", "USER", "EMAIL")”

Row 10 (which is the last row) : Name default as “Option 9” (is vacant).

Now the issue is the “Password” column is showing the exact text or number based on the assigned password given to the respective users. Is it possible to show those password values in asterisk instead. Please help me how to accomplish this. Thank you so much sir.