I have a number of uses of SN that would greatly benefit from being able to do smarter parent/child functions than the current system allows, and a suggestion on how these could be enabled.
As an example, A stock note logging grid. Imagine a grid listing each stock I invest in, and notes indented underneath with all the progressive comments & actions. Across the gird of course we would have date, price, recommendation, target, etc. All the numerics. Now for each of these columns, we would want to update the parent line (stock) with the LAST entry below (by date).
Current situation: As a mediocre workaround, I have written a SN function Last(), which returns the last value in the array that gets passed to parent/child functions i.e. retval=array(ubound(array)). Most of the time this works, as inherently, one enters rows in the db in date order. However, this is obviously logically & practially floored.
Suggested Solution: If parent/child equations could be re-written to (optionally) take fields as parameters e.g. Last(Recommend, Date), then SN generated a 2-dimensional array instead of the current fixed 1-d one, the user functions could be written to provide almost any logic required. I think this would be an unprecedented feature for SN.
Granted, its a bit of an advanced topic for some, but I suspect that majority of SN users are fairly advanced anyway. What do you think?