Security filter for columns

[ehnz]

Hello, I have a spreadsheet that had sensitive information in certain columns in Smartsheet, is there a way to only allow certain columns to be used from a Smartsheet table, rather than use the Hide/Show

[Darmund]

This is a pretty interesting question! It sounds like you’d like to use the same table that has the sensitive information in AppSheet, but you don’t want AppSheet to see the data from a specific column.

One thing you could do is enable the PII feature for that column and create a slice of that table in AppSheet so that the column is not included in any views that use that slice.

help.appsheet.com

Sensitive "Personally Identifiable Information" (PII) Data Policy

Learn how to deal with personally identifiable information in your AppSheet app

An even more extreme solution might be to create a second table in your SmartSheet that uses all of the columns except the sensitive one and map a relationship between the two tables.

Who do you want to keep the sensitive information away from? Who do you want to have access to the sensitive information? If your sensitive information will never be used in your AppSheet app you probably should find a solution in your SmartSheet data source.

[ehnz]

Correct, so only 3 or so columns are needed for the app, but I don’t want to create a duplicate sheet with just the 3 columns in smartsheet as it gets too messy when adding and deleting rows, any ideas would be appreciated

[Koichi_Tsuji]

As Steve advised, it is not possible to read the cetain columns only. AppSheet always read whole column.

Only solution is you move the data source to Cloud SQL then create view with column only you need and read View as table for AppSheet.

[Steve]

ehnz:

is there a way to only allow certain columns to be used from a Smartsheet table, rather than use the Hide/Show

Nope.