@dbLookup in a dialog list
I have a formula for @dbLookup, or @dbColumn, that results in a list that is too large, how can I word the formula to filter the list so that the results only contain MOMHP as the first 5 letters or the word- can I use it within the @dblookup formula? Thanks!
Software/Hardware used:
Software/Hardware used:
ASKED:
August 23, 2004 9:36 AM
UPDATED:
August 23, 2004 6:37 PM
Answer Wiki:
You can make a different view to access. One that is setup the way up the way you want it. Pull the data from that instead.
To see all answers submitted to the Answer Wiki: View Answer History.
To limit what is received, you must either limit the number of columns or rows, to a total of 64K. Alternatively you can use @Picklist with a view containing a single column with the value you need. The big advantage of @Picklist is that you avoid the 64K limitation. If you want to retrieve multiple values, put them into the specified column with a delimiter. For cosmetic purposes you will want to hide the retrieval column from view. The rest is a matter of formatting and sorting the visible part of the view so it presents the information you want.
THis solution assumes you are using the Notes client. FOr Web you can format a view with the rows as checkboxes or radio buttons, depending on your needs, and then embed this view in whatever form you want to access the information from.