Design Label-Fields

[stevie.at]

I want users to be able to change labels of certain fields by a script (There are several fields with a ckeckbox set and they are used temporarily. Whenever a certain period of usage is over, the tags can be claered and used for another purpose and therefore have to be re-labeled). I did this with global fields what worked fine in the first point, but

- In a hosted DB environment global fields can't do the job anymore as the react individually for every user - means the new name just appears on this user's screen who did the change. And whenever the database is closed and opened again the global fields are set empty.

- So plan b was to use text fields and replace the new label-text in all records... an action that takes way too long in a database with about 6500 records!!!

- The last thing I can think of is to use plain text-fields (the one right from the toolbar) and let the user just click into it to change the content. I assume there's no way to trigger these fields by any means...

The plan was to guide the user through this without switching into layout mode or allow to click into the field etc...but by now I can't come up with another way...

Any other ideas to do this???

[-Queue-]

Use a separate file which contains one table and only one record. Put all your 'prefs' fields in this file as normal (non-global) fields. Then create a File Reference for this file and a Cartesian (X) relationship to this table in the main file. You can then access the same prefs data for all records, the data will be retained for all users and between sessions, and you can clone the main file without destroying all values in the prefs file.