The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
wpdatatables integration - show formidable KEY in column?
Hello,
This is a question to anyone using wpdatatables integration plugin here...
I would like to know, is there any way at all to include the Formidable entry "key" (the 5-character unique identifier) in a wpDataTable column? I can only see how the numeric ID can be included, but for an application we really really need to include the entry key in the table as well.
Anyone can think of any solution at all? I am comfortable with php if there is a patch that I will have to apply.
December 20, 2018 at 5:48 am
I never used the plugin for WPDatatables. I use the jQuery version and manually code the integration. Since this is done in views, the key is available and my preferred method of referencing fields.
December 20, 2018 at 5:49 pm
hello, any example for that? I haven't figured how to create views in a fast way that basically include the whole table and are searchable, filterable and sortable in real-time.
with wpdatatables I can do that quite easily, but it lacks the key. So if it can be done natively with formidable views, I would definitely like to know that :)
December 20, 2018 at 7:12 pm
Try footable plugin and let me know if u need help
December 21, 2018 at 11:05 am
you can try https://formidableforms.com/add-ons/3rd-party-add-ons-wordpress-forms/
there is a plugin made by Teowin-Software for what you need , i didnt try it yet , once i try it i will let you know .
December 21, 2018 at 4:56 pm
hi Ethan, thanks for the help. How about that Teowin plugin? Is it legit? I cannot find any screenshots or features at all.. not even how to contact the developer - his website is almost empty.. Anyone here tried it?
December 21, 2018 at 5:34 pm
am trying but i cant give you an opinion yet but i will let you know
i think this is his email info . : teo@teowin.nl
December 21, 2018 at 6:08 pm
Hi Andreas,
The grid did not get my attention in the last weeks. I guess time for an update.
TeowinGrid is a responsive, JQuery based grid which supports pagination and inline editing. And it saves your entries. There are 2 things not working (not implemented): radiogroups and signatures.
I have posted a screenshot with the product on my website. But if you like there is a demo available which shows the editable grid.
Best regards,
Teo Super
December 21, 2018 at 10:43 pm
Here's the header of a view a wrote a few years ago. It initializes a datatable with filters and sortable columns. It also displays the buttons for copy, excel, and print.
You can download the jQuery extension here: https://datatables.net/
Attachment:
grants-view.js_.zip
December 22, 2018 at 10:26 am
can you give us a quick walk through , that would be much much appriciated
Thanks Vfontjr for ur valuable contrubition to FF community
December 22, 2018 at 11:03 am
Hi Ethan,
Walking you through the code and how to do this is a lot to ask from a community volunteer. I run a full-time consulting business and my time is valuable. I don't mind helping out here by providing code samples I've written in the past or taking a few minutes to provide more detailed explanations, but the preparation and walk through would take too much time away from my paid clients. Please understand, that the customers with whom I have an established business relationship are my priority.
It's really not that difficult and everything you need can be found on the datatables site.
December 22, 2018 at 12:09 pm
I agree with Teo Super in Everything he said , make a lot of sense
December 22, 2018 at 12:29 pm
Hi VFontjr,
I decided to remove my initial comment. I suppose you have seen the initial text. But I will re-post some of it.
Your Javascript file will leave the average Formidable Pro customer clueless. I understand where it should go and what it does because I have coded a plugin and I have background. And even then: it is a hack because your Javascript should go in a separate file.
You gave a very nice but complicated IKEA dressoir but only the wood and the screws. Without drawing. And when asked to lay out the wood, you don't have time.
Your code requires good programming knowledge. You need to know how to implement datatables.net code in your Wordpress website.
I have searched for a JQuery table that takes a column definition to draw an HTML table and can load rows and save data with Ajax. Getting the colums determination, the calculations, pagination, loading and saving to work took me about 150 hours.
If you really need to suggest people an alternative to what I try to make a living from, then please suggest something everyone can carry out. And add the drawing.
Your suggestion requires HTML/Javascript and Wordpress/coding knowlege up to a level where someone knows how they can attach Javascript files to a page. Pointing them to the Datatables website with a "good luck" does not really help anyone..
But one way or another: I have coded this plugin because I see the need for a straightforward grid, made for the website owner.
It costs a one hour fee to get the most simple straightforward solution possible.
Best regards,
Teo Super
December 22, 2018 at 1:11 pm
I'm sorry that you guys are offended because my offer to help doesn't measure up to your standards. But let me ask you, what other professional would you go to and ask for up to 2 hours of their time to provide you with their services for free? Would you ask your doctor, lawyer, auto mechanic, HVAC service tech, or anyone else? It's unrealistic to expect an unpaid volunteer to devote that much time to any issue for anyone with whom they don't have an established business relationship.
I'm also a moderator on the Studio Press Community Forum where I've helped almost 7,000 people over the past few years. I check these forums regularly during my breaks from my client work or writing. I've written 14 books and have thousands of blog posts on a variety of sites and subjects all for the sole purpose of helping others. I do my best, but I guess sometimes, my best is just not good enough.
I wish you all a joyous, safe and satisfying holiday season. I'm taking a very badly needed vacation and signing out until the new year. My best to you.
December 22, 2018 at 4:06 pm
vfontjr you are missing my point.
First of all: I'm not native English but Dutch. I did not mean to offend but I tried to explain.
My point is not about not willing to help but after I mentioned my plugin the first that happens is someone posts an alternative saying that it all is not difficult. I just had to comment on that. I hope you understand what I try to explain. I make a living out of coding/consultancy.
But about your suggestion for the grid, datatables.net is a very nice grid. But that is for the display part. The editor part which also looks realy nice, is premium. Costing 109 dollar for a single developer and you need OEM licensing to distribute the editor.
I think you missed that part.
Sorry if I was offensive.
I too wish everyone who reads this a good/nice holiday season.
January 22, 2019 at 4:53 am
Hi Meremetia
i use the WPDataTables plugin and you can pull and show any data from the database
create mysql query table and link the tables by the required ID
the FF Item_key is on the frm_items table
alternatively you can create a table in database and use a saved procedure to update query to add the 'item_key' by using formidable hooks - ie after entry or after update run the saved procedure .
i hope this will guide you to a solution.
Regards
Discussion closed.