-
Trigger on Update not triggering
I want to automatically create some child records in 2 child tables. In the parent table, Trigger on Create successfully creates the required child records in one child table (actually it duplicates…
-
Hosed table
I needed to change a field from Choice to Dynamic Choice. So I created the new DC field and set up the correct data. Deleted the original static Choice and renamed the new DC one to the same name as…
-
Select from array
I want a choice type field, constructed from some of the values in another table. Ah, use a Dynamic Choice Field and filter that I hear you say, but the trouble is that the original table has many…
-
Free text
Anyone figured a way to make this line up with a regular field? Fields align vertically at their top. So a data field with label positioned above does not line up with any 'Free text' placed on the…
-
Table context
Let's say I have a child table with 2 parent tables. When acessing the child table through either of the parents (as opposed to directly from the table list on the LHS) in order to e.g.…
-
Dynamic Choice misbehaviour
I have a table of Vehicles which uses a Dynamic Choice type field from which to select the Tax Class. However, here is a snippett from the main table view: So there are 3 vehicles,…
-
slicing and dicing of an array
How can one 'slice' an array from a specified item to the last item? The 'end' parameter can be a negative number to count from the last item. So slice(array,1,…