Friday, 9 January 2015

Working with a new file

Quick Start Screen and Working with new file

                                                                                                                                           
When you launch FileMaker Pro, you will get a quick start window.
From this quick start window you can
  1.Create new database
  2.Convert an existing file to a FileMaker file.
  3.We can use a starter solution. Starter solutions are inbuilt FileMaker
      solutions (Solutions are applications created by filemaker software). Starter solutions are examples from which we can learn how to build our own FileMaker solution(ie. application).
  4.We can learn from video tutorials.
  5.We can see FileMaker forum.
  6.We can open recent files.


Quick start screen is for beginners. We can create new database via quick start screen. Or close the quick start screen, go to File-> New Database. Give a name to file and click on save. A new file will be opened.

Professional programmers create a file in following method.
File -> New Database -> Give a name -> Save.
We get this screen(which is shown below)after saving. We can add data here and create new fields too by pressing the "+" button.
But creating new fields via this screen is not a good practice.(To see the best practice read the next line after this diagram)


The best practice to create new fields is go to File-> Manage-> Database.
After selecting Manage Database, we will get following window.            
                                                                                                                                  

We have 3 tabs on this window which are Tables, Fields and Relationships. 
-In Tables tab, we can create, delete a table. 
-In fields tab we can create, delete, duplicate a field.
-In Relationship tab we can relate tables. 

Now in Fields tab, at the top left corner of the Manage Database window we can see the present table(in diagram present table is Contacts). We can enter the Field Name and press "Create" button to create a new field. We can select the type(data type) from drop down list. Some types are Text, Number,Container, Calculation. We can Change, Duplicate, Delete a selected field.

Now we will add fields to Contacts table.
-Type the field name as Company_name.
-Select data type as text.
-Hit Create

Wednesday, 7 January 2015

Working with a new file

Quick Start Screen and Working with new file

                                                                                                                                             
When you launch FileMaker Pro, you will get a quick start window.
From this quick start window you can
  1.Create new database
  2.Convert an existing file to a FileMaker file.
  3.We can use a starter solution. Starter solutions are inbuilt FileMaker
      solutions (Solutions are applications created by filemaker software). Starter solutions are examples from which we can learn how to build our own FileMaker solution(ie. application).
  4.We can learn from video tutorials.
  5.We can see FileMaker forum.
  6.We can open recent files.


Quick start screen is for beginners. We can create new database via quick start screen. Or close the quick start screen, go to File-> New Database. Give a name to file and click on save. A new file will be opened.

Professional programmers create a file in following method.
File -> New Database -> Give a name -> Save.
We get this screen(which is shown below)after saving. We can add data here and create new fields too by pressing the "+" button.
But creating new fields via this screen is not a good practice.(To see the best practice read the next line after this diagram)


The best practice to create new fields is go to File-> Manage-> Database.
After selecting Manage Database, we will get following window.              
                                                                                                                                  

We have 3 tabs on this window which are Tables, Fields and Relationships. 
-In Tables tab, we can create, delete a table. 
-In fields tab we can create, delete, duplicate a field.
-In Relationship tab we can relate tables. 

Now in Fields tab, at the top left corner of the Manage Database window we can see the present table(in diagram present table is Contacts). We can enter the Field Name and press "Create" button to create a new field. We can select the type(data type) from drop down list. Some types are Text, Number,Container, Calculation. We can Change, Duplicate, Delete a selected field.

Now we will add fields to Contacts table.
-Type the field name as Company_name.
-Select data type as text.
-Hit Create