Jump to content

How to set constant values for every user ?


This topic is 5420 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi !

How would it be possible to set "constant values" for every user ?

I mean I want to set come "constants" (for example values for alarms) that are same for every user regardless they are using FM Client or IWP.

If I change a value of a global field from "15" to "5", next time I log in it is again "15". It seems that these Global fields are per session, not "real constants".

Link to comment
Share on other sites

You can create a custom function?

In terms of global they are session based and the default is based on what was set when the file was last used as single user - not hosted.

But if you want a user to change their values independently you would need to create a user preferences table. And use that to store their prefs.

Link to comment
Share on other sites

Thank you, Ocean West !

Is the custom function the best way to solve this ? I would like to create a "Preferences layout", where these constants can be changed by the admin if needed. So these values are same for every user and privilege set.

Link to comment
Share on other sites

The best way perhaps in this case is to have a table that has one record for "universal" preferences, and allow an admin to navigate to layout and change the values - then in a startup script, transfer the data from the stored values in the table to $$variables or into a table of global fields. Each user who logs in would get the values in the global/variable.

If you use $$variables you can set it all in one script step using let.


Set $var = 



Let ([



$$var1  = prefs::yourfield1;

$$var2 = prefs::yourfield2;

$$var3 = prefs::yourfield3



];

""  // no result



)

This would allow you not to have an non-database person mess with the schema (custom function / define fields )

Of course values would only be propagated to users on their next log in or unless you have some maintenance routine they perform often that would run the script during their current session.

Edited by Guest
Link to comment
Share on other sites

This topic is 5420 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.