Search code examples
lotus-noteslotus-domino

show input list on Notes web page with options taken from a view


I need to have a combobox on my Lotus Notes Page that I open in WEB...

  <input list="myList" name="myList">
  <datalist id="myList">
    <option value="item 1">
    <option value="item 2">
    <option value="item 3">
    <option value="item 4">
    <option value="item 5">
  </datalist>
  <input type="submit">

as option values (list of items) I want to pull data from some Notes view. Any ideas? Thanks


Solution

  • Here is how you can do it (just one way)

    <input list="myList" name="myList">
      <datalist id="myList">
        <computed text>  
      </datalist>
    <input type="submit">
    

    And computed text must have a formula (with @DbColumn) that generate options. This code just an example. You will need to define view_name, column_number and possible database (if the view is in another database).

    _col := @DbColumn(""; ""; "All"; 2);
    _options := "<option value=\""+_col+"\">";
    @Implode(_options; @NewLine)
    

    enter image description here

    Here is a result (my view has only 2 values, 'index' and 'test'):

    enter image description here

    Also keep in mind that there is a limit (64Kb if I remember correctly) for result of @dbcolumn.