Hello everyone - I've made my own search box and I'm sharing the code here.

Features:
Searches your blog title and subtitles for the user inputted keywords. If it matches the title, return it. If it matches the sub title (meta description) of the blog post, label it with a special indicatory, like "(related)".

Automatically opens a new tab towards that blog post when selected.

Demo:
https://www.visigo.fr/blogsearch.html

Three steps:

Step 1 (Setup):

a) Add a simple "Searchable List" component to your page.

b) Give that Searchable List component an identifier (I recommend "blog-search" - you will have less settings to change later)

c) Add a "jQuery Source Code" object to your page.

d) Add some blog posts if you don't have any:)

Step 2:
Open the jQuery Source Code, replace EVERYTHING by pasting this code.
You MUST modify the first two parameters or else it will not work. You must also modify the BLOG_SEARCH_SELECTOR and BLOG_SEARCH_LANGUAGE to reflect your actual use case.

Step 3:
Save your page, load it up and try it out!

If you want to change the action taken after the user selects an option, modify line ~48 "window.open(data.url)" and change it to whatever you'd like.

Additional info:

• This does not allow you to search categories or tags. This could theoretically be implemented, but I'd need your help to understand the best use cases.

• Accented characters:
  I've decided to disregard accented characters when making the comparison. This is to allow people to choose how they search for topics, especially if they are searching in a language that is not the default one on their keyboard. The details of how this is processed is in the removeDiacritics function.

• FYI, AppDrag's blog API returns the results in this format, which you can access using the data variable returned after user selection:

{
            "id": "9", // Integer of the blog post ID number
            "appID": "your-app-id",
            "title": "The Title of your Blog Post",
            "subTitle": "The meta description of your Blog Post",
            "imageUrl": "uploads/url-of-your-blog-photo",
            "tags": "blog-post-tags",
            "category": "[\"4\",\"5\"]", // Blog post categories as JSON stringified array
            "author": "John Doe",
            "nbReads": "152",
            "previewID": "b2b6bxd2-exxe-480c-abf4-a2908s2b4829", // GUID of blog preview ID
            "totalRead": "152",
            "isPublished": "True",
            "PublishDate": "2020-10-20 09:34:05",
            "formattedDate": "20 octobre, 2020",
            "lastUpdate": "2020-08-31 13:56:39"
        }

Hi Dick,

(Disclaimer, I'm not an AppDrag representative, just a user and fan, but my opinions are my own)

The AppDrag Whitepaper has some good information about their own security.

But, part of the AppDrag's power in allowing you to design and build your own 'back-end' to a site is giving you the flexibility how much (or how little) security you need.

In this sense, it's almost as if you are renting a storefront in a mall. The mall (AppDrag) mops the floors, maintains the public restrooms, manages the parking lot, etc.

But you have to decide what kind of door and what kind of locks you put on or in your store.

AppDrag prevents 'unauthorized' access in the default state. Meaning, nobody can change your website or access your data directly.

However, as soon as you start using their tools to build other ways of accessing the data, the responsibility for security falls under your scope.

For example, if you build an API function to access confidential or private data, you should also build-in tests or checks to ensure that the API caller is authorized to access that information.

This is obviously part of a much larger conversation about application security in general, but I wanted to get the ball started by defining and distinguishing the 'scopes' of your responsibility vs. AppDrag's.

Hello Thomas!

These are SQL parameters.

AI: Auto Increments the field on each new insertion
PK: Primary Key - this is the field that will be used when doing joins (like linked fields)
UQ: Unique - the SQL operation will fail it would cause two rows to have the same value in this column. This is best used for things like social security numbers, customer id numbers, and other things that are VERY IMPORTANT never to have conflict or duplicated.

Hope this helps!

@Wassim-Samad or @Joseph-Benguira, it'd be really nice to have these as tooltips.

@Wassim said in Sending html mail from API:

https://stackoverflow.com/questions/41412512/node-js-promise-request-return

@Dick-Honing I've used the package 'request-promise-native' which allows you to await a request.

I recommend checking it out, it's been working great for me:
https://www.npmjs.com/package/request-promise-native

In case you haven't found this out yourself yet, you can access it from within a CloudBackend function using:

event["HEADERS"]["CloudFront-Viewer-Country"]

Hope this helps!

Hi Julien,

By using Chrome inspector / dev tools, it looks like your page is loading the same script from heyoliver 14 times! And each time it is taking between 2-6 seconds.

See screenshots here:

HI @Stephen-Alsobrook ! Welcome.

You've got two options:

1. You can add a "JavaScript Source Code Embedded" element as described here:
   https://support.appdrag.com/blog/48-.html

2. Go into that page's settings -> Advanced tab -> "Insert HTML before end of body"
   And paste the javascript snippet from your app there.

Note, for option two, your snippet should start with <script> and end with </script>.

Cheers!

Hello team,

When sharing DB access with others, unfortunately these people can see all data and edit any field, but they are not able to add any records.

When attempting to add a record, they get a message that it was successful, but the record is never created.

Thank you!

Brilliant, thank you!

That does sound very strange.... but I have had a similar bug.

1. Can you share your project name (for AppDrag support when they see this, they may be able to look into it)

You can find it in the URL as "appid=your-app-id"

1. What browser/OS are you using? I had a PageBuilder problem using Brave once, where changes would seem to save, then revert. It was very strange indeed.

2. Are you using any custom CSS styles? Could be that. If you share your public URL that could also help.

Hi David and Linda,

David, it seems like the code in the blog article you linked retrieves the articles from the 'official' AppDrag API and inserts them into a Cloudbackend table... but it doesn't mention at all how to link that to a search bar via PageBuilder.

I did this here: https://community.appdrag.com/post/2048 searching the AppDrag Blog API directly, without copying it into our own table first... but it's fairly technical for non-coders to set up and I think we're all looking forward to a PageBuilder-native solution.... so.... is there one?

Thanks @Wassim, that was exactly it.

Some feedback: I NEVER would have looked in that menu to find something that affected the entire header section. Can I suggest moving or copying the "desktop menu" settings menu to the paintbrush of the entire header section?

Either way, thanks for the precise and rapid diagnostic. You guys are the best, seriously.

Hello team,

We're launching our blog soon and I can't seem to get rid of this behavior:
https://www.goodvibes.news/blog/8-L-Equite-dans-l-entreprise-.html?previewID=fd6cb625-c725-45af-9f77-077829b110f8

When scrolling down, the header background changes to transparent.... why?

Thanks

Related to the excellent work @Wassim-Samad was doing here, can we generate author and date tags please ?

Example of the tag set I'm hoping for:
https://github.com/niallkennedy/open-graph-protocol-examples/blob/master/article-utc.html

article:published_time
article:author
article:tag
article:section (AppDrag's category)

Thank you!

Steps to reproduce:

Add standalone CloudBackend inputs to a page

Then, add a pre-built form-section
Enable submit to CloudBackend on the pre-built form. Attempt to assign values from the pre-built form to the inputs of the CloudBackend function you have selected.

You will see you can only select the standalone inputs, not the fields from the pre-built form.

Bravo!

Bumping this up, @Joseph-Benguira any progress on this? I'm starting to have use cases for socket.io piling up

If not sockets.io, is something like this
https://www.serverless.com/blog/realtime-updates-using-lambda-websockets-iot
compatible with PageBuilder/CloudBackend?

Hi @Wassim just to clarify - does AppDrag automatically use any cookies that we need to manage if the user declines?

Perhaps for some, but Twilio and G-Suite, for example, I can add someone as a billing contact that receives copies of the invoices and is able to log in and change payment details, download past invoices, etc.

Hello team,

I am constantly asked to fetch PDF invoices for our various projects.

Any chance there is a way to give billing admin status / access / monthly PDF's by email to our office manager / secretary that takes care of these?