Table fields question

[astlaurent]

Hi

I am loving the project and thanks so much for your effort. I have a couple questions about tables.

First is there a way to prepopulate any data in the table? I was hoping to have a couple records populated with the most common options for users.

Also is there a way to hide any of the fields in the table form based of dependencies within the form. Such as a table to add router interfaces, a checkbox for vrf, if checked the text box appears on the form for the name of the vrf.

[ansibleguy76]

hi

yes. table field can have an expression source. use 'expression' property. it can also have a query and dbconfig property to grab data from a database.

[astlaurent]

Thanks. My thought is to use a yaml to fill in the table with some predefined items. I saw this example

fn.fnReadYamlFile('/tmp/file.yaml','.[].name')

// fn.fnReadJsonFile(path,jq-expression)
// - path : path to json file
// - jq-expression : an optional jq-expression (https://jsplay.org)

Will this work if I put it in the expression property of the table? I tried and couldn't get it working.

Do you have any other examples?

[astlaurent]

Also want to make sure I understand what I am trying to do. I have a table that will hold switch interfaces that will be processed. In general there will be 3 interfaces that will almost always be process so I wanted those to be in the table from the start and then someone could alter them, remove them if needed as well as add new ones. The expression feature seems to just want to do a lookup to populate the table form fields but not actually pre populate the table itself with data. Hope that makes sense. Thank you again for your time.

[ansibleguy76]

This tablefield example, prepopulates the table with an expression. The expression could of course be reading a file, grabbing rest or use dbConfig and query to query a database

  - type: table
    name: member
    label: Add club members
    required: true
    expression: |
        [{firstname: "ansible",lastname: "foobar", age: 49, food: "veggies", paid: true}]
    tableFields:
      - name: firstname
        label: First Name
        type: text
        required: true
        default: ""
        minLength: 2
        regex:
          expression: ^[a-zA-Z]*$
          description: Must be normal characters
        icon: user
      - name: lastname
        label: Last Name
        type: text
        required: true
        default: ""
        minLength: 5
      - name: age
        label: How old ?
        type: number
        required: true
        default: 12
        minValue: 12
        maxValue: 80
      - type: enum
        name: food
        label: Favorite food
        default: veggies
        values:
          - pasta
          - pizza
          - fries
          - steak
          - veggies
      - name: paid
        label: membership
        placeholder: Paid yet ?
        type: checkbox
        required: true
        default: true

[ansibleguy76]

but the table field itself has no features yet like the main form with dependencies. but one day i hope to have subforms that can be nested.