Hi everyone, I’m a new user of Rapidweaver and I don’t have power skill around this tool.
I already purchased Stacks and Foundry, in order to maximise the customisation of my website.
I need to build a result page. So basically I have an external database which I manage by MySQL, provided from an Hosting service.
My question are:
which stack allow me to have access to an external database and set which table use?
which stack allow me to add a search box with a search engine in which I can optimise the query necessary to return the articles in a result page?
how can I show a results page after the search box, and allow to the user to comeback to the home if it’s necessary or to use the same results page to search other articles or improve the search keys?
Many thanks in advance for your patience and support
They can either set up a new table or pull from an existing table (w/ a few minor tweaks usually)
You can filter by whatever field you wish to narrow down the results
Results can be on the same page. If you want visitors to look in detail at a specific record then you can set up FreeForm Pro to allow them to go to a detail page and display as much info on that record as you wish and of course a button link back to the main page can be setup.
You are more than welcome to download the Lite versions out for a test and see if it’s what you want. If you have any problem, please contact me through my site and I can do a screen share w/ you.
In practice I have to build a price comparison site.
I have a database that aggregates a large number of articles sold on different sites, once a user has searched with a keyword for the article of interest, I must return results by taking the values present in the various columns.
Furthermore, once there will be a list of articles, I must have the possibility to put them in order or filter them.
Do you have some suggestion?
Many thanks in advance
Ale
Bill’s EasyDB stacks are pretty much the only game in town for RW and databases, so probably best to speak to him to see if it can serve your needs. There was another stack, by Kuler solutions, but the dev is no longer selling that stack nor involved with RW.
The only other solutions for data I have seen are ones that use GSheet or Airtables as data sources. As you already have tables that somehow collect and aggregate data indoubt these options would work for you.
There was one stack, being worked on by the dev behind the Airtable stack, to integrate with FileMaker Pro but don’t think it’s released yet.
we already spoke with Bill and we can’t use EasyDB because some functionality are missing.
I fear the only way to make something professional is to change software, rapidweaver is not the right tool for our project.
If you’re open for an alternative solution solution, there is a free Airtable stack. Developed by Tim Dietrich: https://timdietrich.me/stacks/air-publisher/
You could export/import OR use Zapier to port the data from MySQL to Airtable and access it from there.