Create a database application on the Cloud

Codistri (rhymes with artistry) is a platform that allows you to build database applications hosted on the Azure cloud which can be accessed by your users anywhere in the world, anytime they want. Building your first application is easy and we'll show you how.

Create a user account for yourself

You'll first need to register yourself on the Codistri platform.

1. Please register your details

2. Just fill in your email address, password and phone number

Create an Application

An application is a collection of tables, forms and macros, with a navigation menu that connects them to provide a sense of organization and workflow.

1. Go to the Login page and sign-in to your account with your email address and password

2. Now you’ll automatically come to the Home page

3. You may not see anything listed yet but eventually you’ll see a list of applications which you have created or have been given access to

4. So let’s start with creating a new application

5. Click on [New] and enter the Name of your application

6. Click on [Accept] and behind the scenes, a database is created inside the Azure SQL cloud

7. All pretty painless!

8. You can now see the application that you have created in the Application List

9. You can edit the Name of the application at anytime by right-clicking on it to display a context menu, and selecting [Edit]

10. You can click on the Url to preview the application as your users would see it

11. Your Role = Owner because you created the application, otherwise if another application owner has shared the application with you, then your Role = User

Create a Table

A table is a structure that organizes data into rows and columns, forming a grid. This data is stored in an Azure SQL database.

1. Go to the Application List page

2. Double-click on the application you created to display the Application Design page

3. Click on the [Table List] tab

4. Click on [New] and enter the Name of your table

5. Click on [Accept] and behind the scenes, the table is created in the application

6. You can edit the Name of your table at any time by right-clicking on it to display a context menu, and selecting [Edit]

Create a Field

Fields are the building blocks of tables and contain the data that you have captured from users.

1. On the [Table List] tab, double-click on the table you created to display the Table Design page

2. Click on the [Field List] tab

3. Click on [New] and enter the Name of your field

4. Enter the Caption which is a more user-friendly name for your field

5. Enter the Type of field to create (e.g. Autoincrement, Check, Date, Memo, Numeric, Text)

6. Enter the Width of the field when the table data is displayed

7. Tick the Primary Key box if this field is used to uniquely identify a record; this field may act alone or be part of a combination of fields

8. Click on [Accept] and behind the scenes, a corresponding field is created in the table

9. You can edit the field details at any time by right-clicking on it to display a context menu, and selecting [Edit]

10. You can also change of the order of the fields by changing the Field ID

Browse the data in a Table

There are 2 ways of doing this:

1. On the [Table List] tab in the Application Design page, choose a table and click on the Table Url

2. On the Table Details page, click on the Table Url