Test roadmap 3
 
This script will create all Registries, their attributes and Screens, and associations between them directly by INubem without import spreadsheets. Let's create a registration system for internal training of a company
Create an account
Create an account if you does not have one. If you already have access the account by name.
Create Registries
We will create four Registries (with their Attributes, which are nothing more than their fields) and then make associations between them: Course, Topic, Employee, and Department.
Use the item Registry in the main INubem screen to create a new Registry. In the top horizontal menu click on Add to create it.

Figure 1 (Click to enlarge/reduce)
Fill in the fields with the Registry name and description. This description can help the users to better understand it. Click Add button and a new Registry will appear in the list.

Figure 2 (Click to enlarge/reduce)
In the horizontal top menu click on Edit Course.

Figure 3 (Click to enlarge/reduce)
A screen for editing the Registry opens. Click the plus sign (1) that is on the left side of the name Course and the Attributes list (still empty) may appear. Then click the Create New button (2) to create a new attribute.

Figure 4 (Click to enlarge/reduce)
Now let's fill in the properties of a new Attribute called Name (1), where the user will put the name of the course. In the description (2), fill in a description of this attribute that can help end users better understand its role. The type (3) will be Text because we want a text entry field. Set it as mandatory (4), ie the system does not allow blank value. We also want the Name appers on the search screen for Courses then we mark it as Partial value (5). A Partial Value filter allows the search to be made for parts of the name. I can for example search for a course by "Training" and all courses beginning with this text are brought. An Exact Value filter allows only search for exact names. We also want this field to be Unique (6) (no repeated Courses names). Only Attributes that are Partial Value filters can be Unique, so this property is only enabled after setting the filter. The same goes for Use to order (7). With this the list of Courses are displayed or exported sorted by name. Finally, we define a Max. Size (8) to fill the field, so that the Course name could not exceed 40 characters. Click Save button.

Figure 5 (Click to enlarge/reduce)
Clicking the Save button the Attribute Name is created. See that it now appears just below the Course. The asterisk indicates that it is a mandatory attribute and (F) indicates that it is a filter. To create another Attribute repeat the procedure. Click the Create New button, fill in the data and save.

Figure 6 (Click to enlarge/reduce)
The Attribute Class Load is of tipo Number (1) and is Mandatory (2).

Figure 7 (Click to enlarge/reduce)
The Attribute Description is of type Text ans has maximum size of 300 characters.

Figure 8 (Click to enlarge/reduce)
The Attribute Level (1) is of type List of values (3), where we provide all the values to the list. For the user a selection list will be displayed. Each list value can be added by clicking the Add button (4, 5 and 6) that adds a new item to the list.

Figure 9 (Click to enlarge/reduce)
In the end, the Registry Course has four Attributes: Name, Class Load, Description, and Level.

Figure 10 (Click to enlarge/reduce)
Let's now create a new Registry Topic. Click on the top horizontal menu in Add (1). Fill in the Registry name and description and click Add (2).

Figure 11 (Click to enlarge/reduce)
This Registry has only two Attributes Name, which refers to the topic name and Content that refers to the content delivered in that topic.

Figure 12 (Click to enlarge/reduce)

Figure 13 (Click to enlarge/reduce)
Repeating the process of adding a new Registry we will create a Employee with Attributes Name, Code and Outsourced. This last Attribute, as you can observer, is of type Checked / Not checked. This type is presented on the screen as a field to select or deselect (checkbox).

Figure 14 (Click to enlarge/reduce)

Figure 15 (Click to enlarge/reduce)

Figure 16 (Click to enlarge/reduce)

Figure 17 (Click to enlarge/reduce)
Now we'll create the Registry Department with the Attribute Name.

Figure 18 (Click to enlarge/reduce)

Figure 19 (Click to enlarge/reduce)
Create associations between Registries
The first association that we will create will be between the Employee and Department. Select the Registry Employee on the vertical side menu (1). Click the Create New button (2) to create a new Attribute. Put the name (3). Let's take the same name as the Registry that we associate (Department) but this is not mandatory. Select the type List of values (4). In this case, we inform that the values come from another Registry. To do this click on Values from Registry (5). To indicate the Registry open the selection Registry Name (6) and select Search ... (7).

Figure 20 (Click to enlarge/reduce)
In the window that opens fill in the Registry name (it can be just the beginning of the name that the system finds all the Registries whose name has the same beginning). Click Ok.

Figure 21 (Click to enlarge/reduce)
In our case there is only one Registry that matches the entered text and it is already automatically loaded in Registry Name. We should also select which of Registry Department Attributes will be used for the text that appears in the selection list and for the identifier of the list. The identifier is nothing but another value that we can associate with the text that appears in the selection list to facilitate their comprehension when values are exported to spreadsheets. In this case, let's just leave the Attribute used as text with the Attribute Name and let´s blank Attribute used as identifier, as it is optional. Click Save.

Figure 22 (Click to enlarge/reduce)
At the end the Registry Employee has an Attribute Department which is a selection list whose values come from another Registry that has the same name (this is not mandatory, this was done only to facilitate). When new data is added in the Registry Department the selection list in Employee is automatically updated.

Figure 23 (Click to enlarge/reduce)
Let's create another kind of association where the Registry Topic will be associated exclusively to Course. An exclusive associção means that the data of the topics are unique to a course, ie each course maintain, in itself, a set of topics.
Open the Registry Course (1), click Create New (2) and then fill in the name (3) and description of the Attribute. Let´s use the plural Topics as the Attribute name since it is the association between course and topic. The type of the Attribute must be Other Registry grid (4). To select the Registry associated open the selection list Registru Name (5) and click Search ... (6).

Figure 24 (Click to enlarge/reduce)
Fill in the beginning of the name and press Ok.

Figure 25 (Click to enlarge/reduce)
Make sure that the Registry name is Topic, mark the option Data exclusive to this association to ensure that the association is exclusive and save the Attribute.

Figure 26 (Click to enlarge/reduce)
Let's now create a third type of association that is not exclusive between Course and Employee. This combination should not be exclusive because the same employee may attend various courses. Click Create New (1) to create a new Attribute. Put the name (2), the description (3) and type Other Registry grid (4) and look for the Registry Employee (5).

Figure 27 (Click to enlarge/reduce)
Before saving the new Attribute (which defines the association) set another very interesting property: make this a bidirectional association. A bidirectional association, besides associate employees to the courses, also makes the inverse association, ie associates courses to employees. This can be very useful. Marking a Employee as a attendee in a course at the same time this course was put in the list of courses held by the employee. To make a bidirectional associção check the Association is bidirectional (1) and give a name to Attribute name on reverse Registry (2), which is the name that a new Attribute will be created in the Registry Course. This new Attribute will make the reverse association and hence its name resembles a list of courses to which the employee has attended. Save the Attribute and the result is shown below.

Figure 28 (Click to enlarge/reduce)
Select in the vertical side menu the Registry Employee (1), click the plus sign (2) next to Registry name to open the Attributes list. Click on the Attribute Attended courses (3) and see that it is also of the type Other Registry grid (4), this Registry is Course (5), it is also bidirectional (6) and the name of the reverse Attribute is Attendees (7) as it was given by you in the previous step.

Figure 29 (Click to enlarge/reduce)
Create the application Screens
For now we created only Registries, their Attributes and their associations. Let´s create the Screens so that the system can be used.
Let's start with the simplest screens. Select the vertical side menu Registry Topic (1) and click on the tab Screen (2) in the horizontal submenu. In the selection list Select screen choose New ... (3) to define a new Screen.

Figure 30 (Click to enlarge/reduce)
Let's give the name Topics to this Screen. There is no need to be the same name as Registry, so we choose to use the plural. Click Ok to create the new Screen.

Figure 31 (Click to enlarge/reduce)
Let us first change some properties of this Screen. Select Allow data exportation and we disable Do not show in menu. This allows the Screen to be displayed in the user menu screens and so can be used for he/she. Notice the horizontal submenu the highlight for List, Search and Edit. In each of them you´ll define the Screen layouts. The List Screen is one where the data are listed. The Search Screen is where we do the search for the data we want to find and the Edit Screen is where you can add or change data.

Figure 32 (Click to enlarge/reduce)
Select the submenu List Topics and click on Creating a default layout. This is the easiest way to create a layout. You can also create it cell by cell using the commands of this frame.

Figure 33 (Click to enlarge/reduce)
The layout automatically created has the two attributes side by side.

Figure 34 (Click to enlarge/reduce)
Repeat the procedure to create a layout automatically for the other two layouts Search Topics and Edit Topics.

Figure 35 (Click to enlarge/reduce)

Figure 36 (Click to enlarge/reduce)
Let's create the Screens of Registry Department as we did earlier. Select the Registry in vertical side menu and click on the tab Screen of the the horizontal submenu. In selecting Select screen choose New ... and name it Departments. Do not forget to selecionr Allow data exportation and uncheck Do not show in menu. Click on each of the submenu tabs and create the layots automatically, as shown in the following figures.

Figure 37 (Click to enlarge/reduce)

Figure 38 (Click to enlarge/reduce)

Figure 39 (Click to enlarge/reduce)

Figure 40 (Click to enlarge/reduce)
For the Employee Registry we would need two Screens. The first Screen is used to show the employees associated with the courses, that we call Attendee. The second screen is used to manipulate employee data. Screens should be different because while seen as Employee the data should be shown in full screen, but when seen as Attendee there is no need to show all. This is a point should be clear when we build associations. Often to establish the association we need no define a Screen with all the data. In this case, to associate a Employee to the Course, that we call a Attendee, we need to view limited information. Name and Code are sufficient, while the rest we do not need. Let's create the Screen Attendees in Employee. Select it in the vertical side menu as shown below. Note that in this case we will set also Allow data exportation and we will leave marked Do not show in menu as this Screen does not need to be accessed by the vertical side menu, but only within the Screen Courser (which we will build later) where we´ll associate the employees to courses.

Figure 41 (Click to enlarge/reduce)
As this Screen should not have all the data from Employee we´ll have to build it cell by cell and not automatically as done so far (another alternative would be to build automatically and then remove the Attributes you do not want). Select the submenu horizental List Atteendees and click on Create an empty new row at the end .

Figure 42 (Click to enlarge/reduce)
Click at the new empty row layout (1) and divide it into two columns by clicking Split <emptu> in two columns (2).

Figure 43 (Click to enlarge/reduce)
Select the Attribute Name on the side tree (1) and then click on the leftmost layout cell (2). Ready! This Attribute is placed in the layout. Do the same with the attribute Code.

Figure 44 (Click to enlarge/reduce)

Figure 45 (Click to enlarge/reduce)
Repeat the same procedure for layouts Find Attendees and Edit Attendees.

Figure 46 (Click to enlarge/reduce)

Figure 47 (Click to enlarge/reduce)
In Registry Course we also set a screen to be viewed only in its association with Employee. This Screen will show the Attended Courses and can contain only the Attributes Name, Class Load and Level. When we consult the employee and want to know which courses he attended this information may be sufficient. The following figures show how would be the screen layouts. The procedure for defining them is the same as previously used, namely the layouts are constructed cell by cell. Remember that for List Atteded courses only one line is allowed (it is like a spreadsheet row) and therefore you should split the line in three cells, using twice Split ... into two columns. Also note that in the layout Find Attended Courses we can only put the Attribute Name, since only attributes that are filters can be used in search fields.

Figure 48 (Click to enlarge/reduce)

Figure 49 (Click to enlarge/reduce)

Figure 50 (Click to enlarge/reduce)

Figure 51 (Click to enlarge/reduce)
Now we are ready to mount the Screen Courses showing all course data along with their associations. This Screen should appear in the sidebar, so the Do not show in menu should be cleared.

Figure 52 (Click to enlarge/reduce)
We will use the feature Create a defualt layout to built with a single click. For layouts of List Courses and Find Courses we see the result in the following figures.

Figure 53 (Click to enlarge/reduce)

Figure 54 (Click to enlarge/reduce)
In Edit Courses note that the complete layout contains two larger cells, which are the listings of the associations made by Attributes Topics and Attendees. Note that to display these associations is necessary to define the screens that they will use. So in Edit Courses Screen two screens are shown for associations with topics (the Screen Topics) and employees (the Screen Attendees).

Figure 55 (Click to enlarge/reduce)

Figure 56 (Click to enlarge/reduce)
Now let's build the same way the Screen Employees of Registry Employee. Do not forget to enable it to be shown in the sidebar.

Figure 57 (Click to enlarge/reduce)
We use automatic layout construction for the layouts of List Employees and Find Employees.

Figure 58 (Click to enlarge/reduce)

Figure 59 (Click to enlarge/reduce)
The layout of Edit Employees also use construction with a single click. Note that between the two Screens available for the Attribute Attended courses we choose the simplest one, that screen that have the same name.

Figure 60 (Click to enlarge/reduce)
Finally we can click on the vertical side menu in Open Screen ... and see the four screens that can be shown in this menu.

Figure 61 (Click to enlarge/reduce)
Use the Screens
Before using the screens we just defined, we will return to main Screen of INubem. The easiest way to do this is to reload the INubem using the button to reload the browser itself or the F5 key (Windows and Linux). The initial screen returns to the initial state as in the following figure.

Figure 62 (Click to enlarge/reduce)
Let's open the screen Departments, by first clicking Open Screen... .

Figure 63 (Click to enlarge/reduce)
We see that list is empty because we have no Department added. Let's add one by clicking Add in the top horizontal menu. Fill in the Department name and click the Add button.

Figure 64 (Click to enlarge/reduce)
Repeat the process until you have the three Deptartamentos in the list.

Figure 65 (Click to enlarge/reduce)
Open Employee Screen and let's put some data into it. Use the same procedure as in the previous Screen (Add in the top menu horizonta, enter details and click Add button). Add the five employees of the listing.

Figure 66 (Click to enlarge/reduce)
Let us now remember where we define the Screen Employee and compare the Listing layout definition to the list of employees of the previous figure.

Figure 67 (Click to enlarge/reduce)
Let's open the Screen Courses and add three courses following the same procedure we did earlier to add data. The result should be as follows.

Figure 68 (Click to enlarge/reduce)
Select the first course and click on the option Edit HP 12C Calc... in the top horizontal menu. Note that now arises the screen to edit the course. Click on the associations Topics and Attendees to expand the lists of associated data. Compare the smaller figure (the Edit Course layout of Screen Courses) with the layout of the Screen presented.

Figure 69 (Click to enlarge/reduce)
To add a Course Topic click the option Add the horizontal submenu of Topics.

Figure 70 (Click to enlarge/reduce)
Add topics as you did for the other data. Note that I must add the topic data on this screen because it had been defined as an exclusive association with the course. Topics of the course are created along with the course.

Figure 71 (Click to enlarge/reduce)
Note that the attendees (whose association is not exclusive) can not be added by this Screen. There is the screen Employees which is able to add new Employees who may be attendees to any course. To select which employees will be attendees just choose Show All in the list of attendees and select those you want to put into the association.

Figure 72 (Click to enlarge/reduce)
Finally, go to the screen Employees, select one of those who were associated with a course and you will see that this same course appears in inverse association Attended Courses. An inverse association connects the two data reciprocally. This can be very useful.

Figure 73 (Click to enlarge/reduce)
There are other features that were not covered in these scripts. To learn how to use them all just test the INubem and look the help texts that always exist in each control. For example: when using the Edit Registry Screen and position the mouse over the control Remove associated a description of the feature is shown.

Figure 74 (Click to enlarge/reduce)