Dear all expert,
I have a question regarding the field type dialog list. Everytime when user input the New keyword, It will only appear in the keywords selection for the first time. When the user go back to the field again, the keywords list become blank again, How can I store the new keyword in the dialog list field so that user can always input new keyword and selectable for others time?
Kindly please advice.
Thank You.
Subject: Dialog list does not store keyword
Create a hidden 1-column view that shows the documents in which the keywords have been entered. Then use something like this for a formula to look up your keywords:
k_words := @DbColumn(“”:“”; “(keyword_view)”; 1);
@If(@IsError(k_words); “Error”; k_words).
If you have keywords already defined then just concatenate them to k_words like this (with @unique added to remove duplicates):
tmp := @DbColumn(“”:“”; “(keyword_view)”; 1);
k_words := @If(@IsError(tmp); “Error”; tmp);
@Unique(“Keyword1”:“Keyword2”:k_words)
Hope this helps,
Phil