topic Re: How to lock data in set analysis in App Development

How to lock data in set analysis

Antimo92 — Thu, 20 Apr 2023 11:20:56 GMT

Hi everyone,

I would like to edit a sheet so that when you open it, a filter is automatically applied.
To do this I added an action in the sheet with the following set analysis:

=if(GetSelectedCount ([Country]) = 0,'Italy',GetFieldSelections([Country],';',999))

Stakeholders would like a padlock to appear when the filter is applied and I would like to do so by inserting this command in the previous set analysis.
Do you know if there is a command that allows you to apply the padlock?

Re: How to lock data in set analysis

PrashantSangle — Thu, 20 Apr 2023 11:40:48 GMT

use bookmark.

or add button in the sheet and use action as per need.

Re: How to lock data in set analysis

Antimo92 — Thu, 20 Apr 2023 12:37:33 GMT

Hi,

I did it. I added the action "Select values in a filed" with the formule I wrote and "Lock a specific field".

The problem is when you open the sheet the filter and padlock work, then when you change the selection and get back to the sheet the selection doesn't change but appers the padlock.
I would like the padlock to appear only at the beginning, if you then remove it it must not return.