New Response
Cancel
Copy to Archive
Move to Archive
Document Library
Main Topic
Kurt Tomicich
2005/02/15
Procedure
Reference
Subject:
Dialog list based on existing values in a specific view column
Category:
Tips\ Notes\ Programming
Version:
Revision Date:
2005/02/15
Modified:
2005/03/07
Reviewers
Originator
Previous
Current
Future
Kurt Tomicich
Kurt Tomicich/KRT
None
None
I initially used this feature in the Small Biotech Accounts database
This is an example where the values in the Account Name field are to be displayed.
The field MUST be set to allow values not in the list
The below example is color coded as follows:
RED
denotes a variable you make up
BLUE
denotes a second variable you make up
PINK
denotes the View Alias for the view to take the values from
GOLD
denotes the column # (counting from Left to Right) to take the values from
The following is the field calculation value in Field Properties:
--------------------------------- Example ---------------------------------
tmp
AcctNameList
:= @DbColumn("" : "NoCache"; ""; "
vwAccount
";
1
);
acctNameList
:= @If(@IsError(tmp
AcctNameList
) | @Elements(@Trim(tmp
AcctNameList
)) = 0; ""; @Trim(@Unique(tmp
AcctNameList
)));
acctNameList
--------------------------------- Example ---------------------------------
The Categories field of the MS Document Library template has this as code. I tested and it works just as well.
REM {In the case of reading an existing document, it is not necessary to do the @DbColumn because we don't support the use of Keyword Synonyms in this application, and thus translation doesn't need to be done.};
@If(!@IsNewDoc & @IsDocBeingLoaded; @Unavailable; @DbColumn("":"NoCache"; ""; "By Category"; 1))
Submitted for review on 2/15/2005
Review completed by Kurt Tomicich on 3/7/2005
All Documents
By Author
By Category
By Alternate Name
Review Status
Help
Document Library
Main Topic
