103 comments found.
Looks like a great script! I would like to know is their any way to have custom order to the data? If I add a position field to the database? I notice that creating new rows adds blank rows to the top of the table. If I want a new row to be positioned below a certain row when I press the add button can this be done?
Thanks chrispg21. At the moment, it is not possible by default to define the position of a newly added row, but by playing with the startRow property it could be done, I think.
The work and time you have put in the documentation and examples is awesome 
Bought the script and going to find out how I can make use of it.
Thanks a lot mate!
What a great component! It has taken me a while to “get it”, but now I am finding it really easy to use. Kudos on some great coding.
Thanks mate!
Have you tried to use it with the HTML Table Filter Generator script (free open source)? The combination of both scripts gives you an advanced grid component.
If you like the ezEditTable code don’t forget to rate !
Cheers
Hi again, I’m having trouble mixing it with the table filter generator. I tried the explamples but they do not work as expected. They are filtered or editable, but not at the same time.
Could you provide a downloadable working example? I would appeciate it very much. Regards
There is no downloadable example at the moment. Make sure you have placed the ezEditTable folder inside the TableFilter one, the TF script will then import automatically the ezEditTable extension if placed at expected location. Please have a look at the demos using the ezEditTable extension http://tablefilter.free.fr/demos.php?1=ezEditTable to see how to configure both scripts. Cheers, Max
Hi, Looks promissing so far!
I have one question. Is it possible to add pagination to the table?
Regards
Hi, yes, you can add pagination if you use the ezEditTable as an extension of the HTML Table Filter Generator script. Please have a look to these demos to see how both scripts work together: http://tablefilter.free.fr/demos.php?1=ezEditTable||paging. Cheers, Max
Sorry to trouble you. In the table 9 example you show a drop down with the continents: where is that defined? I want to see how to add items to drop downs. Also do you support item id, item value where the id and the value may be different? For example: statusid = 1, statusvalue=’open’, etc.
Thanks, Huambo
Hi Huambo, the drop-down options are defined automatically from the column values. You can also define your own options by using the custom_slc_options property and specify different values with the custom_slc_values property. You can find those properties in the documentation provided in the purchased package, more specifically in the ‘Cell editors’ section. Give me a sign if you need further assistance. Cheers
Another question: do you have a code sample for asp.net/c#? I want to call a web service to save my data in ms sql server. Thanks, Huambo
No I have no .Net/C# examples available, the script focuses on the client side only. You can set up your web service in .Net and then use the script’s delegates to submit data to the web service.
Greetings, is there a simple way ti export the data contents to the server using a simple ’ export to json’? thanks huambo
Hi Huambo, there is not such a feature at the moment. This can be a feature candidate for next release actually.
Hi, I’m using the Checkbox Selection Grid demo in my tables, but when I select all the checks in a table with 3000 rows takes too long and sometimes hangs, can you help me with this please, is there a property to make the selection faster the checks?
Hi, unfortunately there is no property to make the selection faster. The script iterates every row of the table and fires the on_after_selected_row callback that is charge of ticking the checkbox. This operation is done 3000 times and that’s why it may be long. We are hitting here the limits of the client/browser. What I suggest is to split the data in different pages, put a pagination feature in place.
Hi, thanks for replying, my table is paged, 1000 records per page, but when I select the header check mark all checks me the 3 pages, there is a property to mark the checks only the active page?. I’m using Tablefilter with ezEditTable. I’m using the Checkbox Selection Grid demo in my tables. please your help, thanks.
Unfortunately there is not such a property. The check all feature checks all the validated rows. As this is more a HTML Table Filter Generator issue I suggest to place a support request at this URL: http://tablefilter.free.fr/support.php. Cheers
Thanks, I will write to the email you indicate, but another query, you can select a group of checks with the mouse and the shift key pressed?, as the style of gmail?
Hi, the shift key gmail like feature is not available but I think it can be implemented by taking advantage of the many callbacks. Give me a sign if you are interested on this feature.
If I’m interested, but the selection with shift and mouse should be applied only to the filtered records, because as I said use the ezEditTable tablefilter along with, for example if filter 3000 records and I want to select only 500 will be done with the shift and mouse. please tell me how it would delay implementation?
Hi jvirtoore, Let’s move to a private conversation, send me a request via the script’s contact page: http://edittable.free.fr/contact.php so we can start an email thread. Cheers, Max
ok, since you wrote the email you provided
hello I wrote a few days to mail http://edittable.free.fr/contact.php, to discuss the selection of checks, but there is no answer, please check if you get, and if possible make the application thanks
Hi, I haven’t received any email from you on the edittable mailbox. Did you attach any js file to your email? I know my ISP mail server blocks incoming emails with any js and I suspect also .html files attachments.
Hi, I just sent another email in Case says “select checks with shift and mouse using ezEditTable with tableFilter” and the security code is 35461. Please forward to your response
As a matter of fact, I am not receiving emails from the script’s support page. Could you please send me your email via the message box in my profile page here: http://codecanyon.net/user/koalyptus Thanks in advance and sorry for the inconvenience.
I just wrote you please confirm if you received the mail, thanks
Yes received!
Great docs for this script! Question, my current tables use a form. If I convert this to a pure table with this script, can I still use hidden fields?
What do you mean exactly by ‘my current tables use a form’? Regarding the hidden fields, when you submit data to the server, you could add them as query string parameters, for example:
...
actions:{
'insert': {
uri: 'add.php?hiddenfield01=value&hiddenfield02=value', submit_method: 'form', form_method: 'POST',
param_names: ['','name','email','startdate','salary','active']
}},
...
Is this answering your question?
So, I want to use the custom PHP solution for this, do I ditch the form and build this with the script or can the script work with my form? Make sense?
many thanks John
Ok, the script creates automatically its own forms for each row, therefore you cannot use the one you already have in your pages. As showed in the demos, you just need to enable the “editable” option and configure the “actions” object and the script will do all the necessary step in order to make the cells editable and submit the values to the server.
thanks, got it all working, one other follow up: is there a way to get the trid value and pass it as a parameter in the URI of an update?
Thanks and great work!
John
Thanks John! If you like the script do not hesitate to vote it Is your table row id composed of ‘tr’+Id? If this is the case make sure you pass the id to the server and then you can recreate the tr id server side. Does this make sense?
I gave you the vote, at least I believe I did! Two things, first, I’d like to chat about some freelance work if your up for that. Second, I have a question around the select menu. How do I use a separate option and value menu? I actually using a PHP variable for the option and that works fine, I want to insert/update a different value on the select though. Example. the option would be to select a player, the value would be to insert the player_id value. Make sense? I don’t have to have the PHP example, a normal one would do. let me know on the freelance piece. Nice work!
Thanks Johartma. If you want to define your own options for the ‘select’ type editor, use the ‘custom_slc_options’ property. This demo http://edittable.free.fr/custom_layout.php shows how to configure the drop-down list editor. Concerning the freelance work you’d like to talk about, please contact me via this form: http://edittable.free.fr/contact.php?t=premium. Cheers
thanks for the reply, I will reach out today on the premium. A follow up and to make sure I understand. I currently have this: { type: ‘select’, style:’width:80px;’, custom_slc_options:[{‘pl_names’}]}, pl_names is a PHP string replace. My values there show up fine. they are player names, but I want the player_id to be the value sent. ex: in the select menu, johartma would be displayed, but player_id 7 would be the value sent. Like a normal select menu. Is there anyway to do that?
Okay! I just had a look in the code and there is no way to define the option values separately in the configuration object. I will make this possible in the next update. Tell me if you can’t wait and I will explain you how to implement it. Cheers
The script has a search option in the table?
Hi, it has no search option, the scope is editing, selection and keyboard navigation. But you can use it with another script specialized in filtering HTML tables called HTML Table Filter Generator.
When the file is purchased, do you include the php/mysql demo?
Hi, no the server side demos code is available on the scripts website. You can access the demos at http://edittable.free.fr/demos.php. The script is meant to be completely independent of the server side technology, that’s why there is no php/mysql code in the purchased package.
Thanks! It is a very good work!
5 stars!
Mick
Thanks Mick_, I appreciate!
Envoy again Via CodeCanyon.
Thanks!
Mick
Ok it was in spam! Sorry for that!
Did you receive my email?
Thanks!
Mick
No, I haven’t received any email yet. Did you send it via CodeCanyon or the script’s website?
I do not have this problem on your site.
Mick
Ok, in that case send me a static html page reproducing the error so that I can hopefully identify the problem
Hello,
I have error with IE8 :Message: This object does not manage this action. Line: 1524 Character: 3 Code: 0 URI: ezEditTable.js Message: This object does not manage this property or this method Line: 103 Character: 2 Code: 0 URI: file:ezEditTable.js
An idea?
Thanks!
Hi Mick_, From the error message I cannot have a clear idea. Do you have the same issue on the online examples and demos? Contact me via my profile’s contact form or via the script’s contact form at: http://edittable.free.fr/contact.php?t=premium. Thanks in advance.
Purchased this. Nice work Koalyptus, exactly right for a current need. look forward to the update as an Image Upload would also be a terrific upgrade or add-on.
Hi, I just added a demo showing how to implement an image upload editor: http://edittable.free.fr/upload_editor.php
Look good, but no image upload? I thinks that is what digidave0205 is referred to.
Hi vgnocchi, Okay thanks! There is no image upload feature at the moment at least as built-in cell editor type. It could be already possible to add an image upload custom editor type by using the current API though. Definitely, this is a feature candidate for next release! Meanwhile I will try to add a demo in the script’s website implementing this feature as a custom type. Thanks both of you, vgnocchi and digidave0205 for your suggestions.
