Hi Neil, First of all thanks for purchasing this code.

var etConfig = {
  base_path: 'path/to/ezEditTable/`, // relative to this HTML page
  ....
};

Let me know if this helps you.

Cheers

Hi there, I don’t have the icons for the months and year and when I try to select a date the picker won’t go away. When I click else ware the cell has an ‘undefined’ message in it… Can I get all the supporting files please?

Also, the samples in the download don’t include any of the PHP AJAX demos. Can I get access to that as well please. Thanks for your help.

Hi there,

The pre-requisite for this script is to provide a HTML table. Given a HTML table no matter how this is generated, the script will work on it.

Cheers

Maybe all of this could be avoided by installing tablefilter.js as a module, since my database is in a node/express environment. I originally tried to do it that way, but kept getting a

ReferenceError: window is not defined at Object.<anonymous> (...\node_modules\tablefilter\dist\tablefilter\tablefilter.js:1:319) at Module._compile (module.js:653:30) at Object.Module._extensions..js (module.js:664:10) at Module.load (module.js:566:32) at tryModuleLoad (module.js:506:12) at Function.Module._load (module.js:498:3) at Module.require (module.js:597:17) at require (internal/module.js:11:18) at Object.<anonymous> (...\node_modules\tablefilter\index.js:3:18) at Module._compile (module.js:653:30)

So if you could provide some assistance on how to get tablefilter.js working modularly, that would probably be a better solution. Thanks!

hi @tsalm0n, could you please raise 2 tickets on TableFilter’s github project as those are TableFilter issues. TableFilter integrates with ezEditTable, ezEditTable is unaware of TableFilters existence.

cheers

Hi Peter,

You simply need to hook into custom editor callbacks. Most of the demos feature a third party date picker, if you check this demo for example, you are interested in the following callbacks:

- open_custom_editor => implement your custom logic to initialise or open third party component when ezedittable cell turns into editable component

- close_custom_editor => implement your custom logic to manage third party component when ezedittable cell turns into non-editable component

- get_custom_editor_value => implement your custom logic to retrieve third party component contents and return it as string to ezedittable (when cell becomes non-editable)

- set_custom_editor_value => implement your custom logic to set ezedittable’s cell value to third party component when cell becomes editable.

The arguments passed to those callbacks should be clear enough apart from o which is the ezEditTable instance.

In the cell_editors section of the config, don’t forget to define custom editor type.

I hope this will help you and btw that’s a nice utilization of this plugin.

Cheers

Hi @Atrilas,

please search comments with ’’hidden field” term. Find johartma question which seems to be relevant and look at my reply.

Cheers

@sergio57,

please note the polyfill messages you are seeing are part of TableFilter, a completely different component.

The messages simply suggest to import the mentionned packages in your page, if you intend to support older browsers like IE. Refer to this codepen: https://codepen.io/koalyptus/pen/XYeMVW and inspect the imported packages in Settings > Javascript tab .

Cheers

Thanks for the reply, I was aware that TabFilter is another component … but I do not have an account in GitHub to insert an issue in this regard. However it was just to indicate that it is not on my page where the messages appear but on this page: http://www.tablefilter.com/0-configuration.html, and where the additional javascript components are present

sure, that page and many others on the TableFilter’s website are telling you that since you are using IE you should add the aforementioned polyfills in your page when using TableFilter. Modern browsers like Chrome or Edge are not prompted with above message. It is a friendly reminder for the developer. It is not an issue. Maybe the message is not clear enough.

Hi @Antrilas,

there is no limitation on the number of columns a table can have, whether there is a actions column or not. Something else may come into play…

- make sure your HTML table structure is valid

- double check any CSS rule that may interfere with the columns display.

For the moment those are my suggestions.

Cheers

Hi @dmilleville,

Happy to see you worked it through up to this point. What do you mean by what to check to get the PHP code to display? You probably want to have a look to those demos: http://edittable.free.fr/demos.php, pick the Simple demo. There are some php snippets that should give you an idea on how to setup the endoints the js plugin submits to (ie insert and update).

I based my solution on the simple demo. My PHP endpoint uses the CodeIgniter framework. I can see that the PHP endpoint receives the data from the JS plugin submit. That PHP endpoint then uses echo to provide feedback to the user. I can see the results of the PHP echo in the Chrome debugger console but the PHP echo does not display the text in the existing table window or in a new window. I tried having the PHP endpoint open a new window but it will not display the text. I thought this might be a caching or buffering problem, so I tried a few recommendations that I found while searching but nothing helped. Again, I realize your plugin is not oriented to a PHP endpoint but any guidance (or pointing me in a direction) is greatly appreciated. I have tried searching but I’m not even sure what terms to search for.

ok from what I understand you’d like to achieve something similar to this demo: http://edittable.free.fr/custom-actions-ajax.php

However, I advise to not follow that particular demo as it focuses on how to implement a custom delegate function for insert and update operations.

The same result in terms of UI could be achieved by:

1. basing your solution on the AJAX demo: http://edittable.free.fr/ajax.php . Once the AJAX based solution works for you, at least, the insert and update operations with no user feedback UI then:

2. leveraging the process_response callback (refer documentation ‘Actions callback events’) to implement a feedback UI similar to what you see in http://edittable.free.fr/custom-actions-ajax.php

Tell me how it goes.

You are probably referring to the TableFilter plugin, please use appropriate channel: https://github.com/koalyptus/TableFilter/issues

Hi,

et.Selection.Remove(); // up to you
et.Editable.Remove();

et.Selection.Set();
et.Editable.Set();

Refer to the documentation EditTable Class > Selection Public Methods and Editable Public Methods sections.

Cheers

That worked. Thanks!

Just tried that, no change in the behavior

Ok, in that case I advise to manually import the ezEditTableTable plugin in your page. I just published this working example you can refer to: http://www.tablefilter.com/advanced-grid-editable-x2.html.

Note there is no longer need for filename and vendor_path settings as the plugin is already loaded.

That did it, it’s working! Thank you!!

Please note this is not a server-side solution, as stated in the product description this is a pure javascript library therefore does not come with any DB connection details or PHP files:

” Important note

The aim of this code is to enhance the HTML tables capabilities, and provide a generic or custom way to send data to server for DB operations no matter what server technology you use. The examples featured on the script’s website use PHP and MySql and are meant to show how to configure the script in order to send data to the server. This is not a PHP / MySql based solution, you could use this script with other server side technologies. “

Cheers

Cheers

Hi @PaulVerbeek, this is purely a javascript solution, there is no authentication/authorization around it. You will need to implement the authorization layer and instantiate ezEditTable with or without editing capabilities based on your user permissions. Cheers

Dear koalyptus,

It is still not working.

Thanks

Dear koalyptus,

Do you have a working example for “process_response” feature for me to refer?

Thanks

There are no examples/demos featuring the “process_response” callback. However the http://edittable.free.fr/ajax.php demo and the examples in the documentation should give you an idea on how to set it up. Please provide more context… what is not working? Have you managed to activate the ajax mode?

Hi Loïc,

My advice is to use your server to query the DB to get the `dynamic` list of values and then inject them into the client-side. You would then use custom_slc_options to populate the inline drop-down cell editor as you are doing for the boolean.

Cheers

Hi, most of the online demos feature a plus button adding a new row, eg: http://edittable.free.fr/demo1.php

Hi, it is not possible, you can create your custom cell editors that could appear in a bootstrap modal for example, but only on a individual basis. Cheers