Hello,

AppDrag migrates its one to one support to a general community. We aim to provide high-quality answers available to everyone. After some time we would have a strong questions/answers database bringing a lot of value to our users to build their web applications with confidence. We also want to create a dynamic community to improve the platform and our reactivity to build and fix things based on what you as website builders really need.

Here are the 3 main rules to respect when asking a support question on the board:

• Don’t post until you’ve searched the Community for the answer first

• When posting, provide as much information as possible so that your problem can be fully and clearly understood. You can include an appID, link, screenshot, detailed description, etc.

• Be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

Don’t forget that if you want somebody else to consult on or develop your AppDrag solution for you, we can provide you with paid support or connect you with one of our certified partners.

I can see you have a script on the page that is crashing ...
and it's making crash the render of the page

Please try to remove your custom script (or fix it)

Also, instead of placing scripts directly in the source code of your page or in the head of the page, place it in a block of code, this way it will be safe

Hey Thomas, indeed great idea!
I have just added the new section "How-to, Tutorials"

Hey Community, we are happy to announce that our CLI tool is now available on NPM
https://www.npmjs.com/package/appdrag

deploy your full-stack apps to the cloud. Work with your local tools (VS Code, Atom, ...) and build process, then push your compiled code to your app in appdrag

This tool is recommended for:

• Develop locally with your usual tools (VS Code, Atom, ...) and build process (Webpack, ...)
• Setup a CI/CD pipeline
• Setup an external backup of your app
• Export/Import full-stack projects

Hey Daya

In our SEO assistant there is a button to Fix all duplicated H1 and replace them by H2
This should save you tons of times

Hey Mark,

we don't have an integrated plugin for that, but it can be easily done in a block of JS code on your page!

Here is a tutorial to do it in 3 lines of javascript:
https://dev.to/asaoluelijah/text-to-speech-in-3-lines-of-javascript-b8h

Hey Community,

Today we have created a new category to post your features requests:
https://community.appdrag.com/category/8/features-requests

You are encouraged to post your suggestions & features requests, comment or vote for ideas posted by others.
This will help us to prioritize which features should be done first

I've just searched on google: jQuery CDN
https://www.google.com/search?q=jquery+cdn

and it was in the first 2 results

@ThomasD FYI we do have plans to add a premade auth system for Authentication, but as ALL premade components it will be limited in terms of features and customization.

Our process is to always focus first on having fully customizable solutions with source code and with cloud backend
then later we do create plugins based on that.

Already mooved there

You can run the in "New Query", this is returning the execution time in miliseconds of your query
Another great thing you can do to improve query speed is to add indexes on your tables on the fields you are using in WHERE or JOIN conditions. You can get a 100x improvement with indexes

It's accessible from the EDIT button when you are inside a table

Done, moved to Features requests

Hey Thad,

The dns configuration on your domain seems wrong
Please check again our DNS Tutorial for external domains (we do have a tutorial video for GoDaddy)

https://support.appdrag.com/blog/61-External-domain.html

If the responsive is not working on mobile it's because you have not followed our guide above but instead have used a frameset config at Godaddy, this prevent site responsivness and completely prevent site indexing by search engines ....

please simply follow our tutorial above

Hey Pierre,

1. The post exec require the server response, so we cannot execute it if the request was cancelled, that's the expected behavior
   I suggest that in the case you cancel the request in the PRE event you should call your post action in a block of code rather than defined there in the event handler. This way you can share the same function called from the cancel or post event

2. Indeed, the PRE event is executed only if your fields validation are OK, if some fields are not completed this will not trigger the action at all. If you want to trigger the action in all case there is a simple way to do it, disable all validations on the fields so the PRE event will always be triggered. Of course in that case you will have to handle the validation by yourself.

With more power comes more responsibility

Hello

can you try to reload the pagebuilder then try to publish again?

What you can do in the cloud function is to make 2 queries, one to get the main data, and another one to get the references from your ref table, then loop on the main results and enrich them based on what you have in the ref table. So this solution is few lines of node.js

There is another way we also use quite often, the idea is to return the data with the refs in an array and in the same api call also return the dictionnaries

E.g: in your node.js function

var result = {
    rows: yourRowsHere,
    dic: rowsFromAnotherQueryToYourRefTable
};
callback(null, result);

Then in the frontend code use the dictionnary when interpreting the rows.

Ah I see, you can handle that in business logic when you rename through your UI a data to do the corresponding UPDATE in SQL ... or handle this at runtime with a dictionnary ... We can't return directly the merged structure because it would be a major hit to perf.
Database do that 100x faster with JOIN in SQL.
That way you can do a SQL query with JOIN that will return exactly that in JSON (and still storing by reference)

It's always a tradeoff and you have to choose the best solution for your use case

You can do basic things easily, you can also do advanced things with SQL or code
but you can't do Advanced things without Code and without SQL

Hey Thomas, just use Linked Fields by Value instead of By Reference and that's exactly what you will get

Hey Pierre,

This must be done in the same transaction, please check this tutorial about it:
https://support.appdrag.com/blog/63-Inserting-a-Row-in-the-Database--Create-New-Row-Id.html?category=13

@ThomasD FYI we do have plans to add a premade auth system for Authentication, but as ALL premade components it will be limited in terms of features and customization.

Our process is to always focus first on having fully customizable solutions with source code and with cloud backend
then later we do create plugins based on that.