I am hoping there is a more elegant solution to my app field security question. We publish an app in two flavors, "Sensitive" and "Non-Sensitive" which are mirror images from sheets to load editor. The only difference is there is a variable based on the app name:
LET vSensitive = if(wildmatch(DocumentTitle(), '*- Sensitive*'),1,0);
We then have a simple load statement switch based on that variable to include the sensitive fields or not such as below:
If vSensitive Then
[Table A]
Load [Field A]
,[Field B]
From Source;
Else
[Table A]
Load [Field A]
From Source;
End If
I'm hoping that I could use field tags or some other indiciator to highlight which fields are private/sensitive to ensure they are not loaded into the final application. Something to the affect of "Drop Fields with Tag = 'Private';"
