Updated: Apr 2, 2020
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.
Please register your details
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.
Go to the Login page and sign-in to your account with your email address and password
Now you’ll automatically come to the Home page
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
So let’s start with creating a new application
Click on [New] and enter the Name of your application
Click on [Accept] and behind the scenes, a database is created inside the Azure SQL cloud
All pretty painless!
You can now see the application that you have created in the Application List
You can edit the Name of the application at anytime by right-clicking on it to display a context menu, and selecting [Edit]
You can click on the Url to preview the application as your users would see it
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.
Go to the Application List page
Double-click on the application you created to display the Application Design page
Click on the [Table List] tab
Click on [New] and enter the Name of your table
Click on [Accept] and behind the scenes, the table is created in the application
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.
On the [Table List] tab, double-click on the table you created to display the Table Design page
Click on the [Field List] tab
Click on [New] and enter the Name of your field
Enter the Caption which is a more user-friendly name for your field
Enter the Type of field to create (e.g. Autoincrement, Check, Date, Memo, Numeric, Text)
Enter the Width of the field when the table data is displayed
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
Click on [Accept] and behind the scenes, a corresponding field is created in the table
You can edit the field details at any time by right-clicking on it to display a context menu, and selecting [Edit]
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:
On the [Table List] tab in the Application Design page, choose a table and click on the Table Url
On the Table Details page, click on the Table Url