Javascript example


Before we get deep into it, we will start with a basic example to show you the functionality of the system and basic terminology. We will continue our previous example and use the same tables.

We are going to use JavaScript in our website/UI builder to call back to our database that is connected to our site, and ask it to show all cars that are available in stock with a model above 2014.


Final results 

This is the final result we wish to accomplish:


Step 1 - create a table

Below you will find our table called “cars” that is placed in our database that is named “example”.

Here are our column names if you wish to follow the example:

car_model

car_code

car_color

car_year

car_img

available

stock


Screenshot_6.jpg

Step 2- connect your website to the right database

After setting up our table, we will enter the website builder. From the top left bar we will enter website settings and connect our database named "example" to our website as below:

Step 3 - create an element to contain database data

We will drop down an HTML element and add our code that will present our work:

HTML code:


"snd" Style="padding:30px;border:1px">



Step 4 - get data from the database

To add our Javascript code we will open our Javascript tool. Go to - Page menu > Javascript.

Javascript code:

var car = Simbla.Object.extend("Cars");

var query = new Simbla.Query(car);

query.equalTo("available", true);

query.greaterThan("car_year", 2014);

   query.find({

         success: function(car) {

              var str="";

               for (var i=0;i<car.length;i++){

               str += "<h1>"+ car[i].get("car_model") + "</h1>";

               str += "<p>"+ car[i].get("car_year") + "</p>";

               str += "<p>"+ car[i].get("car_color") + "</p>";

               str += "<img style='width:200px' src='"+ car[i].get("car_img").url() + "'/>";

       

    }

    $("#snd").html(str);

  },

       error: function(car, error) {

           alert("Error - The object was not retrieved successfully" );

    }

 });


Now let's see the result

Click on the Publish button, then on the Preview, and then view live link.


About Simbla

We believe that end users know exactly what they need to perform more efficiently and effectively. Simbla allows them to produce game-changing cloud CRM without writing a single line of code.

Simbla is an AI-generated cloud CRM and a no-code development platform that helps non-coders build quick, flexible, efficient solutions quickly and easily.

Our team has years of experience developing sophisticated cloud-based systems. Drawing on that experience, we built a platform that allowed non-coders to create a tailored CRM that exactly fits the business needs without long deployment and without the help of professionals.

It is a no-code platform with an AI layer, capable of reducing the cost of deploying and maintaining a tailored cloud CRM by as much as 90%.