Advanced techniques: Horizontal scaling - AppSheet Help
@Steve Could you ask someone on the development team if this is being worked on?
6 Likes
Could be useful
so… like an INPUT() ???
INPUT() has another selling point, we could update usersettings with any other method
where i was going was a way to update your login.
Mmm, I don’t get this
YES PLEASE
This has been unofficially possible for a while now, but requires some trickery to set up.
https://video.apportunities.ca/conversations/ac027069-e283-513b-be37-d5c2e2a96278
When AppSheet revamped the automation monitor application a long while ago I noticed that some of the on-click UI actions were updating user settings.
1 Like
Gotcha, I think the forced sync after triggering the change is the tricky part and the reason it’s not considered official yet.
Thanks for the video!
Interestingly enough, the force sync isn’t really necessary:
https://video.apportunities.ca/conversations/9ab9fa61-1389-5369-9055-304a3e62a785
I don’t use this in any production apps, but certainly would if AS supported it. Being able to update app values without triggering a sync is a game changer for offline applications.
I was thinking about the usage proposed on the documentation mentioned on the OP.
If you have a usersetting that serves as a way to reduce the data when using security filters, you would need to do a sync after that.
Can you check by using this method with a field that is used on a security filter?
Security filters are not updating without the data sync event; slices are filtering however.
https://www.appsheet.com/start/5f8040ed-7fa5-4d4c-a9c1-bcffe92be0b7
2 Likes
like a quick ‘log in’ you click a button and a pop up appears with the user and password fields. Then it syncs. ending with the change of the user.
I don’t understand. How do you get the _Per User Settings table to be selectable for an action? I tried mimicking the setup in your video, but I’m missing the trickery somewhere.
3 Likes
Speculative statements don’t belong in the help docs specifically because plans change but the docs don’t get updated. I’ve asked @lizlynch to remove that paragraph.
2 Likes
2 Likes
Agreed, I would love to do this but @Jonathon we don’t see that in our behaviors. I tried setting it up like the example but no go so far.
Dang, Nevermind. If you show all in your behavior page at the bottom is other, you can then hit COPY and… there you go, what you see in the video.
please make this happen, we are pretty much limited and blocked in this limitation and cannot proceed further to production unless this is resolved.
1 Like
Why did you tag me here?
1 Like
If you are saying that you cannot deploy your app until there is a capability to update UserSettings through actions, then, I’m sorry, you are not implementing your app correctly!!
That is not how User Settings currently work and you need to implement your app in a manner that fits AppSheet’s intended usage.
If you need the ability to change settings for users through some kind of automation or administrative capability, you will need to build that using normal tables and associated views/bots. And it can be implemented. If you are having trouble understanding how to do that, then please start a separate post asking the questions you have to get the help you need.
5 Likes