LinkedIn
Twitter
1 ACCEPTED SOLUTION
Hi @gm6379
"Is this possible or is there another approach that would be more appropriate? For example could we obfuscate or hide the email address when being viewed in the google sheet."
It's not possible.
But you can use a Google Sheets with an IMPORTRANGE() expression to retrieve specifics columns if you need to expose a partial information from your Sheets.
IMPORTRANGE - Google Docs Editors Help
"we do not wish to store their username or email address in any tables for privacy reasons, but we do still want to be able to identify which user has entered data into the table."
As app users are identified through their email when connecting to the app, the USEREMAIL() expression is the only way to know who's who.
You may want to use a temp file, where a uniqueID is attached to each UserEmail, but that can be tricky.
If so, you will want to use an expression such as:
LOOKUP(USEREMAIL(), "tableMatch", "Email", "UNIQUEID")
Either way, you will necessarily use the user email somewhere.
"for privacy reasons"
That attracts my attention. If you have a concern for any reason, you can check this option that will prevent AppSheet from storing any PII in their logs:
Also available in the Security>Options panel for enabling this option on every column.
For reference:
Sensitive Personally Identifiable Information (PII) data policy - AppSheet Help
Security: The Essentials - AppSheet Help
Hi @gm6379
"Is this possible or is there another approach that would be more appropriate? For example could we obfuscate or hide the email address when being viewed in the google sheet."
It's not possible.
But you can use a Google Sheets with an IMPORTRANGE() expression to retrieve specifics columns if you need to expose a partial information from your Sheets.
IMPORTRANGE - Google Docs Editors Help
"we do not wish to store their username or email address in any tables for privacy reasons, but we do still want to be able to identify which user has entered data into the table."
As app users are identified through their email when connecting to the app, the USEREMAIL() expression is the only way to know who's who.
You may want to use a temp file, where a uniqueID is attached to each UserEmail, but that can be tricky.
If so, you will want to use an expression such as:
LOOKUP(USEREMAIL(), "tableMatch", "Email", "UNIQUEID")
Either way, you will necessarily use the user email somewhere.
"for privacy reasons"
That attracts my attention. If you have a concern for any reason, you can check this option that will prevent AppSheet from storing any PII in their logs:
Also available in the Security>Options panel for enabling this option on every column.
For reference:
Sensitive Personally Identifiable Information (PII) data policy - AppSheet Help
Security: The Essentials - AppSheet Help
