i need to create a database displayed as a table searchable form anywhere on the site
You can use Types to create multiple post types, which can help you distinguish different content types. You can use Types to create custom fields, and apply those fields to your posts. You can also use Types to create custom taxonomies to further classify your posts, or create post relationships to establish connections between posts. Then, you can use Views to create tables of this content, including front-end search filters based on those posts, custom fields, custom taxonomies, and post relationships. You can split that search form into a widget and include that widget in other portions of the site, and when the User submits the form, redirect to a page that contains the results.
If you're curious about how any of this works, we have a sandbox site set up where you can create and manage test sites: https://discover-wp.com
The Listing Site - Travel Destinations has a custom search form on the home page that redirects to another page containing results. You can see how this is set up in wp-admin.
This is just some general information because I don't have a very clear picture of what you want to achieve. If you have more specific questions, please let me know.
i need to be able to add 3 feilds like here: hidden link
and have them display in a table format like that.
Yes, this is possible in Views. More information about different View formats can be seen here:
https://toolset.com/documentation/user-guides/view-layouts-101/
https://toolset.com/documentation/user-guides/digging-into-view-outputs/
I have created a quick demo here: https://christiancox-22119-gswt-1.discover-wp.com/table-search/
In this demo, only the post title is searchable in the text box but on a live site you can configure the search input field to search custom field values as well.
Because there are so many entries at once I need to upload them via CSV.
We have information about uploading content with CSV import tools available here: https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/
If you have specific questions about that, please start a separate ticket.
the problem is that the listings were only searchable from the page and not from anywhere on the site, i was told toolset can do this?
Yes, we offer a way to separate the search form and results into different sections of the site. You can accomplish this with shortcodes or widgets. Look here:
https://christiancox-22119-gswt-1.discover-wp.com/different-page-search-form/
Submit the search form and the results will be displayed on another page.
So the immediate question is how can i create a few fields in the database which i can then populate , unlike listings and events etc where each listing has to be put on seperate.
I don't understand, sorry. If you want multiple, searchable results shown in a table, each result must be created or imported as a separate post (or a repeatable field group, but that is a special case). If you want to include custom fields (each column) in the results, and if you want to filter by those custom fields, the custom field values must be saved in the postmeta table and linked to each post. The CSV guides I shared offer advice about how to import custom field values in a CSV file.
can you also tell me if this is visible publicly on a forum , as we do not really want to share this with anyone but support.
Forum posts are public, by default. Links and URLs you include in a comment are hidden from other Users, but your comments are public. I can make individual comments private. I will do that now.
The content editor is not displayed because Template for Registrations layout does not include any shortcodes or cells that display post content.
If you want to display the content editor in the post editor screen, you should add a Post Body cell to the Template Layout for Registrations. Otherwise, the post contents won't be displayed on the front-end because they aren't included anywhere in the Layout. At least that's what the system thinks...if that's not the case there could be an issue to investigate separately.
Iam i correct in assuming that because these are Custom Feilds a free version of the plugins you mentioned will not work?
Not completely correct, because most custom fields are supported. The exceptions are listed in that table: Repeating fields, repeatable field groups (RFGs), checkboxes groups, and Skype fields. In addition, post relationships are not supported. Otherwise, the free import tool is functional. You can also use the documentation as a guide for creating your own CSV file for use with another free import tool.
Hmm when i tried to import the custom fields it prompted me to use the paid version - I could only import the standard WordPress feilds and not the Toolset Types - I wonder if this had changed when you last looked. Reggardles we bought the full premium version inn any case.
Just one more question - in regards to the registration view previously outlines here; hidden link
Is creating a record for each registration the best way to do this? Or would you suggest another way. There could be 2 lots of up to 2000 entries at a time on any given auction you see. Initially we used tablepress - but we could only search that table on the page the table was present - and it also searched across all fields - sso if i specified "19" in the search it would bring up any lot numbers AND reg AND Guide price containing the query. Which is why we bought toolset.
=======================
Can we also change where these answers go to for our technical team - ideally the answers want to go to chris@webdoggy.co.uk thanks
========================
Thanks
a bit of addition info, now i have the importer pro it bottoms out generally at about 500 of 1200 records. Iss there anything in toolset i can do to ease the burden on the import? Or is that a question for WP import?
Just one more question - in regards to the registration view...Is creating a record for each registration the best way to do this?
It's the only way to do this with Toolset. Views loops over posts, taxonomy terms or Users from your WordPress database. There is no external data source capability built-in, so you're limited to those three options, and to use custom search with custom fields, making each entry a post makes the most sense.
Iss there anything in toolset i can do to ease the burden on the import? Or is that a question for WP import?
More a question for WP import, but you could try increasing your server's max_execution_time, max_input_time, max_input_vars, memory_limit, upload_max_filesize, and so forth. You may need assistance from your host to update those settings.
Can we also change where these answers go to for our technical team
The support forum is only able to access the email address on your account. Unfortunately I don't think there is a way to override that in the current system. Another toolset.com User with a valid registration can sign up for notifications from any forum thread, but they don't have access to private comments. If you need to sign up with a different email address, feel free to do so during your full refund window.
