Custom fields table – data entry and view project

Hi George,

That’s exactly what this plugin is meant to do! ??

Welcome! Try to take these steps:
(1) Use the Data Designer to create a table
(2) Create your table (be aware that you need to explicitly create the table)
(3) Create a Data Project
(4) Add roles to your Data Project pages
(5) Give your users the roles they need to use the Data Project pages
At this stage your users will be able to log in to the WordPress dashboard and work with your Data Project.

(6) Use the Data Publisher to create a publication
(7) Add your publication (shortcode) to a web page
At this stage your table is available on your website as well.

For most of the topics you can find documentation and video tutorials here:
https://wpdataaccess.com/docs/documentation/

Just ask if you have any questions! ??

Best regards,
Peter

Hello Peter!
Yes!! I thought so !!!
Thats awesome.I ll give it a try
I think i can also may use it to connect to external database(mysql) and fetch data instead of using wp_remote_get(and custom plugin dev) for some project i am on ..
Thanks a lot!!!

Hello Peter,

I ve started using your plugin(your demo imports), one more question please.
Can i use in a Data Publication a date field with Backword Forward option in order to show for example the “daily” prices?or something similar?
like this https://ft-maritime.com/index.php?market

Is it achievable with data tables?
Thanks again
George

• This reply was modified 4 years, 9 months ago by Jan Dembowski. Reason: Short link expanded, don't use those here

Hi George,

Yes, you can! In your publication you can set the default order by like this:
0,desc|1,asc
See: https://datatables.net/reference/option/

This works for all data types, including date, time and number. Note the you need to set table options (advanced) to { "stateSave":false } in the current version of the plugin. In the next version the plugin will reset this value automatically for you.

Be aware that a user can “overwrite” your default order by settings by clicking on a column header. This will change the order by to the column on which the user clicks.

Hope this helps! ??

Best regards,
Peter

Thanks a lot Peter for your answer!!
I m just searching the possibility of implementing like this: https://ft-maritime.com/index.php?market
with an external date-filter field.
George

• This reply was modified 4 years, 9 months ago by Jan Dembowski. Reason: Short link expanded, don't use those here

What do you mean with: “an external date-filter field” George?

Best regards,
Peter

Hello Peter
I mean just a date field filter as the example link above or similar

Maybe i just need to search more on datatables
i also found this https://next.plnkr.co/edit/8z7cojpJoCSJXRn9prNj?preview
How to approach this (in table design, in advanced settings? etc)

one other thing, i am in local(xampp) server and when loading page i see some “prossesing” message before loading the published data table. I suppose this is the normal process or could that be an ajax call without any delay message.

Thanks a lot again
George

Hi George,

Interesting functionality! ??

Many online DataTables examples (like the one you provided) are using static tables. For these examples you don’t need to perform an ajax request to get the data. You already have it in your HTML.

There are two solutions:

(1) This is different in the plugin. The idea of the plugin is that you store your data in a database table (instead of a HTML table) and perform an ajax request to fetch the data from your database, which allows you to use this functionality with small, medium sized and large tables. When you add or change your search criteria, the plugin needs to send a new ajax request to the server. If you want to use date fields in your query, you need to process these your date fields in your where clause.

To add your own search logic to the plugin back-end you can use filter wpda_construct_where_clause. There is an example written by Charles Godwin which you can find here: https://github.com/CharlesGodwin/wpda-cwg-extensions

(2) If you prefer to keep thing simple there might be an alternative… You can force the plugin to fetch all table data on startup by adding json string {"serverSide":false} to column “Table options (advanced)”. After that you can add your own javascript like the example you provided. Be careful though! You can do this with a small table, but you need the first approach for large tables.

Let me know if this helps!

Best regards,
Peter

Thanks again Peter for your help!! ??

I will give a try on your suggestions !!!
Thanks again
George