Tip -
Adding manual entries to @DBLookup/@DBColumn Lookups
I use this tip a lot for my lookup lists -
it allows me to add things like blank entries,
None, Not Applicable etc to my lookups.
The following adds 'All' to a list that has
been retrieved from the first column of the
'NotesView' (which exists on the current Server
and in the current Database).
The Formula
@Explode("All;"+
@Implode(
@DbColumn("":"NoCache";"":"";"NotesView";1)
;";")
;";")
Of course there is also a simpler way of
doing this - as pointed out by half the planet
to
me!! - You know when you do things a certain
way for years - they work and so you never
question yourself? - aha!!!
