I'm trying to update the table that is found on the homepage of the website provided. I just have a couple questions:
First of all, with the update, it would be great if we could add to the existing table instead of replace it all together. Is there a way that we can update the table without overwriting the work?
Secondly, I'm trying to make a single search field search over several columns. Is there a way that we can combine inputs so that you search one input and produce multiple results?
"First of all, with the update, it would be great if we could add to the existing table instead of replace it all together. Is there a way that we can update the table without overwriting the work?"
Sorry but I did not quite understand what are you trying to achieve.
Can you please explain me in little more and send me some example/screenshot so I can give you my suggestion.
"Secondly, I'm trying to make a single search field search over several columns. Is there a way that we can combine inputs so that you search one input and produce multiple results?"
Unfortunately at the moment there’s no built-in solution. However, it appears in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in future.
Thanks for the timely response! I'll try to clarify on the first question.
Every month the client send us a new CSV doc to use for the table. I'm not very knowledgeable here so this may be a stupid question, but can we just upload/overwrite the current table with that CSV and everything on the front end will stay the same other than the actual search results?
Yes if that CSV file have same number and same names of columns headers(first row in file) like file that you already use for creating this table. Like this you will have data only for that last uploaded file. Data from previous file will be overwritten in table.
Please bare with me. We initially hired a third party to build this database and add the functionality to our site, but now things have changed and I now need to make changes to this. So I'm just trying to understand how this works.
I'm reaching out to you because I am lost here and feel like I've tried everything. I'll try to make my issue as clear as possible. This is the functionality I'm shooting for: If you navigate to https://interwesthealth.com/, and type in any of those three fields titled "Find a Provider", a table should appear. That is working just fine and is what I want to copy.
However, I have to update that table based off a totally different formatted table that I'm loading via a mySQL database. I want to mimic what is currently on the homepage but with new search criteria and a new table so I have rebuild it from scratch. I have figured most of the process out, except for one part: I am unsure on how to trigger the appearance of the table when the user types in the fields.The table should be hidden, then it appears as the user types in the search criteria. This may not have anything to do with you, but I'm reaching out just to be safe.
Hiding tables before search is not built in option in wpdatatables. You need Powerful filters add on for such functionality or custom code that will do that.
If you do have Powerful filter add on your server, then you can:
1) make table from that table in MySQL with first option(if you now write queries or with fifth option with query generator),
2) turn off option Advanced filtering in column settings for columns that you don't need in filters,
3) turn on option Filters in form on SORTING NAD FILTERING tab in table settings
4) when you turn on this option Filters in form and if you have installed Powerful filters add on it will be shown option Hide table below that you can use.
5) Also what you need to turn on is option Clear filters button that you can find beside option Filters in form on SORTING NAD FILTERING tab in table settings
Concerning this website: https://interwesthealth.com/
I'm trying to update the table that is found on the homepage of the website provided. I just have a couple questions:
First of all, with the update, it would be great if we could add to the existing table instead of replace it all together. Is there a way that we can update the table without overwriting the work?
Secondly, I'm trying to make a single search field search over several columns. Is there a way that we can combine inputs so that you search one input and produce multiple results?
Thanks in advance,
Sam
Hi Sam,
Thank you for your purchase.
"First of all, with the update, it would be great if we could add to the existing table instead of replace it all together. Is there a way that we can update the table without overwriting the work?"
Sorry but I did not quite understand what are you trying to achieve. Can you please explain me in little more and send me some example/screenshot so I can give you my suggestion.
"Secondly, I'm trying to make a single search field search over several columns. Is there a way that we can combine inputs so that you search one input and produce multiple results?"
Unfortunately at the moment there’s no built-in solution. However, it appears in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in future.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Milan,
Thanks for the timely response! I'll try to clarify on the first question.
Every month the client send us a new CSV doc to use for the table. I'm not very knowledgeable here so this may be a stupid question, but can we just upload/overwrite the current table with that CSV and everything on the front end will stay the same other than the actual search results?
Thanks again,
Sam
Hi FirstCallWebMaster,
Yes if that CSV file have same number and same names of columns headers(first row in file) like file that you already use for creating this table. Like this you will have data only for that last uploaded file. Data from previous file will be overwritten in table.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Milan,
Please bare with me. We initially hired a third party to build this database and add the functionality to our site, but now things have changed and I now need to make changes to this. So I'm just trying to understand how this works.
I'm reaching out to you because I am lost here and feel like I've tried everything. I'll try to make my issue as clear as possible. This is the functionality I'm shooting for: If you navigate to https://interwesthealth.com/, and type in any of those three fields titled "Find a Provider", a table should appear. That is working just fine and is what I want to copy.
However, I have to update that table based off a totally different formatted table that I'm loading via a mySQL database. I want to mimic what is currently on the homepage but with new search criteria and a new table so I have rebuild it from scratch. I have figured most of the process out, except for one part: I am unsure on how to trigger the appearance of the table when the user types in the fields.The table should be hidden, then it appears as the user types in the search criteria. This may not have anything to do with you, but I'm reaching out just to be safe.
I hope that makes sense.
Thanks so much,
Sam
Hi Sam,
Hiding tables before search is not built in option in wpdatatables. You need Powerful filters add on for such functionality or custom code that will do that.
If you do have Powerful filter add on your server, then you can:
1) make table from that table in MySQL with first option(if you now write queries or with fifth option with query generator),
2) turn off option Advanced filtering in column settings for columns that you don't need in filters,
3) turn on option Filters in form on SORTING NAD FILTERING tab in table settings
4) when you turn on this option Filters in form and if you have installed Powerful filters add on it will be shown option Hide table below that you can use.
5) Also what you need to turn on is option Clear filters button that you can find beside option Filters in form on SORTING NAD FILTERING tab in table settings
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables