Haha, I am just Appsheet geek.
Okey, let me explain the use case.
Now we have dashboard and interact view which is useful to use one of the view which contain the parent table data to filter the rest of view.
However, when the line items is far too long, it is tough to find out the target low out of those dashboard filter, out of table view for instance. And to make the dashboard more dynamic, I wish to toggle show and hide some of the dashboard element (view) using those interactive toggle button. Likewise, if we could have filter in the form of dropdown list, it will be found useful as well.
However, for the moment, there is no feature and function available for now.
So I have been thinking of how to achieve those interactions using the available features.
I posted a feature request in other place to introduce a new feature to place USERSETTING view within Dashboard as one of elements. It will be far more useful to change the value of usersettings within dashboard view without going to usersettings. App user can stay on the dashboard and dynamically change the dashboard in terms of the displaying element, and data themselves.
But the problem stay attached even if we can place usersetting view within dashboard. We need to save the setting.
So i have been thinking of another turnaround.
Now I do have function to generate the custome usersetting. This is simply a table contain the useremail and various usersetting on my own.
When the user log in to the app, the app will filter the table and take only single row out of it.
I m using this table/row as custom usersetting, i would call.
For this row, i generate the detail view, with quick edit. For enum list, I have button and dropdown as well. Then I place this detail view to dashboard, assuming working as “Filter”.
Again, this is detail view with quick edit, so user dont need to take “save” action, but the chang wiil be saved automatically. In this case, toggle the enum value, and change the value in dropdown list.
However, we are not able to trigger workflow/action by change the value in this custom usersetting table value.
This is why the post for this question and feature request is coming from.
Once the value is changed through the detail view/quick edit, I wish to let the actoin activated to do bits and pieces.
Inspired by @Kirk_Masden san`s recent post about the custom font, I justed tested my own idea.
I placed a text (using a technique learned from Kirk) which looks a sort of BUTTON like this and place to the dashboard.
And then good point is this data field is still “text” type where I can attach inline action into it.
For this sample, I attached action to force sync and then go back to the same view after sync.
This is just sample, but when user click the REFRESH VIEW (text), then action is fired and the app start to sync and then return to the same dashboard view.
This is not perfect solution with me, but at least work out.
If we could attach the inline action even to the IMAGE type column, then we can use that image alike a BUTTON.
However, we still do not have workaround for dropdown list to do the same stuffs.