I have a database with an Editable Dialog List field for company name. The code is:
UsedValues := @DbColumn(“” : “”;“”;“COCompany”;1); @Trim(@Unique(“123 Corp”:“ABC Company”:“XYZ Company”:“Your Company”:UsedValues))
The code works on the Client but on the web, the field does not display a dropdown arrow. I can type in the field but the list of company names is not displayed. The user has Author access to the database and there are no Readers fields. There is an Author field with Computed as Composed that is used to insert the Name.
Thank you in advance for any input.
Anita
Subject: RE: @DbColumn field on the web
I think if you disable “allow values not in list” you will get a combobox on the web instead of a regular input field.
The Domino server attempts to match up the controls on the Notes form with field types supported by the web browser. The browser has no field equivalent to a Notes dialog list with “allow values”, which lets people type whatever they want and also gives them choices. Only a regular text field will let people type whatever they want.
Bear in mind that you can have a Notes and a web version of the same form (or subform, or shared field) if you like.
Subject: @DbColumn field on the web
Have you got “allow entry not in list” ticked? This basically prevents Domino from rendering a dropdown list on the web, since there is no HTML equivalent. An annoying but somewhat understandable solution.
Subject: Thank You! - @DbColumn field on the web
Thank you all for the posting about unchecking the ‘Allow values not in list’ option. That was the issue. Unchecking this option displayed the pulldown. I did not know that this option would prevents @DbColumn from working.
Also Thank You to Andre for the detailed explanation. I really appreciate your input.
Have a great day.
Anita
Subject: @DbColumn field on the web
If I recall correctly this is caused by having ‘Allow Values Not in List’ checked. (There is no similar drop-down with edit field control in HTML.)