Search and Results

[Dick Honing]

@wassim https://ecxs-225c83.appdrag.site/My-Account.html

I hope you don't mind the mess ... I'm just playing around with the sample templates to test a few things out. And searching a database an displaying the results is essential for me. Thanks in advance.

[Dick Honing]

@Daniel-Mulroy Hi Daniel, thanks for the tips. However, neither one of them shows an example of a find/search field with a button that finds the records and displays them in some kind of list/table ...

[Wassim]

@Dick-Honing it seems your function is working because when I search Dick, it appears in the results.

If we go to your page directly with the good URL, it works too (https://ecxs-225c83.appdrag.site/My-Account.html?name=dick)

I see you're trying to use CloudBackend actions but it's more for form submission. Here you just want on the click of your button to redirect to this page with the query string parameter ?name=FirstNameValue

[Thomas D]

If your lists are of reasonable size (< 0.5MB) I'd suggest using javascript for search, or you'll run out of back-end function time faster than you'd expect.

[Dick Honing]

@wassim Hi Wassim, thanks for you advise. Can you please tell me how I can get the value of input field FirstName in the URL?

[Wassim]

You must do some Javascript to do it this way

[Dick Honing]

@ThomasD Hi Thomas, thanks for the tip! Do you know where I can find examples of such a javascript search?

[Thomas D]

@Dick-Honing

There are many, see this one for a simple-to-use one:
https://lucaong.github.io/minisearch/

You need to use the back-end to build the index and save it to a file.

Then a new function to return the Index file to the browser, load that into minisearch and do the search in an input.

[Dick Honing]

@wassim Is it not possible to do a simple search and results page via AppDrag's page builder?

[Thomas D]

@Dick-Honing Can't search normal .html pages in Appdrag, you'd need an external indexing service like https://www.algolia.com/

[Dick Honing]

@ThomasD Hi Thomas, I do not want to search the html pages, but let the user enter a value in a text (input) field, click a button (Search/Find) which calls my API Function. Then I want to display the found records in a list on that same page. See for example this screenshot of something I built in FileMaker and now want to reproduce this in AppDrag.

[Joseph Benguira]

I can confirm you will need custom javascript code to call your API endpoint and generate results to be added on the page
without page reload

Another option might be Dynamic Datasource, please check this video tutorial: https://academy.appdrag.com/FullStack-with-cloud-backend-Episode-5.html

But I believe first option with javascript is really what you are looking for

[Daniel Mulroy]

Hi Dick,

I replied in your other thread about javascript for URL parameters.

I just wanted to check, have you considered/tried using AppDrag's shop? It has a built-in search feature for this purpose

[Linda MacDonald]

@Dick-Honing @Daniel-Mulroy @Joseph-Benguira @Wassim @ThomasD I don't know if this helps any but I am always on the lookout for cool search functionality and stumbled upon a really cool one yesterday - it gives you real-time search, i.e. search results as you type. It's platform agnostic so you can use it with any flavour of javascript and open source (free to use) it's called minisearch and can be found on github - if you scroll down on their github page they even have a cdn link so making it more userfriendly for non-tech use. Just thought I'd mention

[Joseph Benguira]

@Linda-MacDonald said in Search and Results:

minisearch

https://github.com/lucaong/minisearch
https://lucaong.github.io/minisearch/examples/

I've checked it and it seems great, similar to algolia but a bit simpler and free