Administration/Maintenance/Wrench mode

Is it possible to detect this mode? I thought userHasRole("admin") could be used for this, but a user's rights are not the same thing as being in 'Administration' mode or not.…

Another Multiple Choice (Dynamic) question

How can the list of choices be filtered? Sorting the list is straightforward, but I cannot figure a way to filter them. By which I mean e.g. select choices where Id > 2 The idea is that the list of…

• Answered

Table function

By which I mean a function that can be called from any field/column in that Table. I have a function to update a couple of fields based on the values of 2 other fields and really need to call that…

Quick Formula question

When a Formula field is defined in a table (not just a calculated column in a list view) is the result saved to disc or is it only ever held in memory and simply calculated as required?…

Update only some some children

Aplogise for the apparent favouritism, but I need to update the Date field of only those child records whose Date field is either in the future or simply blank/empty and not been able to figure out…

Tooltip functionality (or lack of)

What can be used as value in a Tooltip? Obviously simple text, but is it possible to use other column data, perhaps modified with some string functions? I tried entering another field,…

the chosen one (or not)

I'm trying to access the choices from a Multi Choice (Dynamic) field, named 'colour' in the current table. Before I try more complicated concatenations (well, I tried but they failed),…