Data collection from fill-up form to a table

  • Resolved aaamelishko

    (@aaamelishko)


    2 years, 1 month ago

    Hello,
    I’m creating a website. On it I need to create a form for entering data (date, name, etc.).
    The user enters data, clicks the “Save” button, and the data is saved in the database.
    Then I need to create a table from this data so that it can be displayed on another page of the site.
    The table columns need to display only the entered data with the ability to sort and filter.
    I tried to figure it out (read the documentation, watched the video) but didn’t understand. Help me please…

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    2 years, 1 month ago

    Hi @aaamelishko,

    We received your message regarding your question and have responded to it. Kindly check. 😊

    For your convenience, this was our response:

    Hi Alexandra,

    Thanks for reaching out.

    I’ll do my best to guide you on how to create your table. 😊

    I need to create a form for entering data (date, name, etc.)

    Before you create a form, you need to create the database table for it first. If the table already exists in the database, you can move on to create a form for it in WP Data Access > Form Builder.

    Helpful Links:

    1. Designing and creating a database table: https://wpdataaccess.com/docs/data-designer/basic-mode/
    2. Creating forms: https://wpdataaccess.com/docs/data-apps/projects-and-templates/

    Then I need to create a table from this data so that it can be displayed on another page of the site.

    Once the table exists in the database, it can be displayed using Data Tables. We have a guide for that here: https://wpdataaccess.com/docs/data-tables/creating-data-tables/

    The table columns need to display only the entered data with the ability to sort and filter.

    These are all available settings when you create your data table. For filters, you can read more about the available filters here: https://wpdataaccess.com/docs/data-tables-interactive-filters/

    Hope this helps! Let us know if you have more questions.

    Thread Starter aaamelishko

    (@aaamelishko)

    2 years, 1 month ago

    Thank you, I looked through everything and figured it out.
    I still have the following question (I’m attaching print screens just in case).

    1. On the first web page, the user enters data into the fields (see figure 1).
    2. The data is saved in a database (I already understood how to create a database).
    3. Data is taken from the database and shown in a table on the second web page (this is also understandable) (see second figure).

    Is it possible to somehow create a form (similar to the one shown in the first picture), or connect existing ones (there are many plugins in WordPress that offer the creation of forms) with a database so that data is entered through the form (into the fields on page 1)?

    https://photos.app.goo.gl/xnFis91mTeJcBbDh8
    https://photos.app.goo.gl/waX2pVp65Z66zvyr7

    Perhaps I can link some external contact form to your table, can’t I?
    For example, as far as I see, in your tables I can use data from “contact form 7” and “calculated field form” plugins, but the data entered through their forms isn’t shown in a proper table view (the entered data forms only 1 inseparable column). So, can you please help me to understand, what contact forms (or plugins) are better to use?

    • This reply was modified 2 years, 1 month ago by aaamelishko.
    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 1 month ago

    Hi @aaamelishko,

    You can create forms directly connected to your tables using our plugin.

    Here’s a demo I made using an existing table in my database: https://share.zight.com/YEuJbqDb

    The steps are as follows:

    1. Create a project
    2. Add a new page to the project for the table
    3. Allow insert and edit
    4. Add shortcode to any page

    Hope that helps! Let us know if you have other questions.

    Thread Starter aaamelishko

    (@aaamelishko)

    2 years, 1 month ago

    Wow, cool!! You made my day) Thanks a lot! Love you!))

    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 1 month ago

    Hi @aaamelishko,

    You’re welcome! 😊

    I’ll mark this thread as solved now. Feel free to create a new one if you have new questions.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Data collection from fill-up form to a table’ is closed to new replies.