Read data to make table

Support Forms & Blueprints
,
1

Hello, I would like to ask for your help, as I am completely new to this and I’m a bit lost.

I want to create a dynamic table, meaning that through a form, I enter data that gets saved to the data folder. On another page, I want to display a table that shows this data row by row. Essentially, the data from the form should be added to the table.

For some reason, the table never displays anything; it’s always empty, as if nothing is saved, even though I can see the YAML files in the data folder.

What am I doing wrong, please?

My form page:

---
title: Form
form:
    name: form
    fields:
        - name: name
          label: Name
          type: text
          validate:
            required: true
        - name: date
          label: Date
          type: date
          validate:
            required: true
        - name: description
          label: Description
          type: textarea
          validate:
            required: true
    buttons:
        - type: submit
          value: Submit
    process:
        - save:
            fileprefix: contact-
            dateformat: Ymd-His-u
            extension: yaml
        - message: "Thank you for your submission!"
---

And this is my page with table:

---
title: 'Table'
---
{% set form_data_dir = 'user://data/form/' %}
{% set files = grav.files.find(form_data_dir) %}

{% if files is not empty %}
    <table border="1">
        <thead>
            <tr>
                <th>Name</th>
                <th>Date</th>
                <th>Description</th>
            </tr>
        </thead>
        <tbody>
            {% for file in files %}
                {% set data = file.yaml() %}
                <tr>
                    <td>{{ data.name }}</td>
                    <td>{{ data.date | date("Y-m-d") }}</td>
                    <td>{{ data.description }}</td>
                </tr>
            {% endfor %}
        </tbody>
    </table>
{% else %}
    <p>No form submissions found.</p>
{% endif %}

Thank you so much

2

Do you get No form submissions found.? If not, did you try to debug what you get for data?

3

@meechal, A few things that certainly would make it fail…

  • The page frontmatter does not contain:
    process:
  - twig: true
    But since you are not complaining about plain escaped Twig being in the output, I guess you have forgotten to show it in the snippet…
  • grav.files.find() does not exist. Twig has the nasty habit to fail silently…

You will probably need to create a plugin that loops the files and creates and array with the data. Then pass the array to Twig and make Twig loop through the array.

4

@meechal, Any progress you can share with us?