Pull specific data from database into a page

  • Resolved ivyking3

    (@ivyking3)


    6 years, 1 month ago

    Hello. I have a test site I am building. We have one page that allows employees to input data about customers. This uses Caldera forms to collect the data.

    The second page will be for customers to log in and see just their information.
    Is there a way to pull this information out one by one?

    For example:
    Customer Name:
    Customer Street:
    Customer City:

    This way I can arrange the data as I need on the page.

    Is that possible?

    Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Hi,

    Not sure if I understand your question correctly… If you store data entered with Caldera forms in a table, you can access that table with WP Data Access and use it in the Data Publisher for example. There is no interface for Caldera forms.

    Does this answer your question?

    Best regards,
    Peter

    Thread Starter ivyking3

    (@ivyking3)

    6 years, 1 month ago

    Sort of. But I don’t want to insert the whole table. I want to arrange the data as I need it for a report.

    Currently, if I insert with a shortcode, it’s one row of 30 columns.

    I was thinking of presenting it as individual pieces of information. So I would pull row 1 column 1 and place the data here. Then row 1 column 4 somewhere else on the page. Instead of presenting it as one long row.

    I am only showing the data for one row in the database per customer rather than showing them everything.

    I hope that makes sense.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Thank you for clarifying, that makes sense! 🙂

    There are two ways to achieve your goal. You can use the Data Publisher to create a publication or you can create a Data Project. Since you want to create a report (read-only I guess?) I would advice to use the Data Publisher.

    Please follow the steps in the video below to create a publication:
    https://wpdataaccess.com/docs/documentation/data-publisher/roadmap/

    You already have a table, so you can skip that part. Please use button “Select” in the Data Publisher to specify which columns should be shown in your output.

    Let me know if you have additional questions.

    Best regards,
    Peter

    Thread Starter ivyking3

    (@ivyking3)

    6 years ago

    Thank you for the response. That is getting closer to what I am looking for.

    However, I don’t wish to display the data to the customer in a table format. What was seeking was something like this:

    Customer Name: (data is pulled from row 1, column 1 for the first client)

    Customer Street Address: (data is pulled from row 1, column 2 for the first client)

    Customer City: (data is pulled from row 1, column 3 for the first client)

    The idea would be a user-friendly way to see a lot of information about that client only. The client would log in to see their data and it would be laid out vertically rather than horizontally in a table.

    I hope I didn’t misunderstand your instructions and if I did, I apologize.

    Thank you again for your help.

    EDIT – Actually looking at it more, I think I could create a table and style it so it doesn’t actually look like a table and only present the data I need. Or maybe my newbie mind to this just doesn’t get it all yet haha.

    • This reply was modified 6 years ago by ivyking3.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years ago

    Hi,

    That feature will be available in the Report Builder, which is planned as a future add-on.

    Unfortunately the Report Builder is still under development. Hope it’s going to be available in the summer. You cannot do this with the current plugin features. 🙈

    Sorry…

    Best regards,
    Peter

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

The topic ‘Pull specific data from database into a page’ is closed to new replies.