UKenGB
-
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),…
-
stumped
Failing to set up a simple calculation for a column. As an example:- if fasst.Id then let reg := "yes";else let reg := "no";endreg This fails with "End expected: reg at line 6,…
-
Case statement
I'm sure I have somewhere seen mention of this NX functionality, but I can now find no reference to it in either the manual or this forum. Is there such a thing and if so,…