AgileApps Support Wiki Pre Release

Difference between revisions of "Creating a Database Application"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(27 intermediate revisions by the same user not shown)
Line 1: Line 1:
This page outlines the process for creating an application.
'''Start with a plan:'''
 
Start with standard Design work:
# Design your data structures.
# Design your data structures.
#* What data tables do you need?
#* What data tables do you need?
Line 7: Line 5:
#:
#:
# Determine the [[Roles]] that will be needed govern interactions with the application.
# Determine the [[Roles]] that will be needed govern interactions with the application.
#* What data will they need to see?
#* What actions will they perform?


Then build the initial application:
'''Build the initial application:'''
# Use the [[Application Construction Wizard]] to create the objects.
# Go to '''[[File:GearIcon.png]] > Administration > Applications > [Create New Application]
#* Specify the main data fields
# Choose '''Create by Import''' to start by importing {{^CSV}} data exported from a spreadsheet.
#* Specify the object relationships (which creates [[Lookup]] fields]]
#:'''Note:'''<br>Use this option only for a single object (a single-table spreadsheet).<br>For multiple object-tables that link to one another:
#:
#:: a. Continue to the next step to set up the objects and the relationships between them.
#::'''Note:'''<br>Later, you can use the [[Object Construction Wizard]] to add additional objects and relationships.
#:: b. Then use the ''Data Import Wizard'' to upload your spreadsheet data into those objects.
#::: ''Learn more:'' [[Import Data]]
# Choose '''Create Using Wizard''' to create the application objects using the [[Application Construction Wizard]]:
#* Define the objects, specifying singular and plural labels and creating up to 10 data fields for each. (You can create more later.)
#* Specify object relationships, which creates the [[Lookup]] fields that connect objects to one another.
#* Later, use the [[Object Construction Wizard]] to add additional objects and relationships.
#:
#:
# Configure the [[Application Access]] settings to give yourself permission to access the application. (Assign yourself the default role.)
# Once the application is created, configure the [[Application Access]] settings to give yourself permission to access it.
#* Assign yourself the default role.
 
'''Customize the application:'''
# Create the application [[Roles]]
# Create the application [[Roles]]
#:
# For each object, create the [[Forms]] that will be used by each role
# For each object, create the [[Forms]] that will be used by each role
#:
# Configure [[Forms Assignment]] settings to assign the forms to specific roles
# Configure [[Forms Assignment]] settings to assign the forms to specific roles
 
#:
Finally:
# Configure [[Tab Preferences]] to specify the objects that will appear for each role, and the order in which they appear
# Configure [[Tab Preferences]] to specify the objects that will appear for each role, and the order in which they appear
#:
#:
# Configure [[View Preferences]] for each Role:
# Configure [[View Preferences]] for each Role:
#* Select the [[Home Page]]
#* Select the [[Dashboard]]
#* Specify which records are shown in each object [[View]]
#* Specify which records are shown in each object [[View]]
#:
# Customize [[Field]] settings. Add additional fields, as needed.
#:
# Further customize the [[Forms]] that will be seen when records are accessed or created
#:
# Explore other ways to customize [[Objects]]
#:  
#:  
# Further customize object [[Forms]] and [[Fields]] that will be seen when records are accessed or created
# Explore other ways to [[Customize Objects]]
# Use the [[Application Access]] settings to specify other users who can access the application, and the roles they can play.
# Use the [[Application Access]] settings to specify other users who can access the application, and the roles they can play.

Latest revision as of 23:56, 21 May 2015

Start with a plan:

  1. Design your data structures.
    • What data tables do you need?
    • How do they relate to one another?
  2. Determine the Roles that will be needed govern interactions with the application.
    • What data will they need to see?
    • What actions will they perform?

Build the initial application:

  1. Go to GearIcon.png > Administration > Applications > [Create New Application]
  2. Choose Create by Import to start by importing CSV data exported from a spreadsheet.
    Note:
    Use this option only for a single object (a single-table spreadsheet).
    For multiple object-tables that link to one another:
    a. Continue to the next step to set up the objects and the relationships between them.
    b. Then use the Data Import Wizard to upload your spreadsheet data into those objects.
    Learn more: Import Data
  3. Choose Create Using Wizard to create the application objects using the Application Construction Wizard:
    • Define the objects, specifying singular and plural labels and creating up to 10 data fields for each. (You can create more later.)
    • Specify object relationships, which creates the Lookup fields that connect objects to one another.
    • Later, use the Object Construction Wizard to add additional objects and relationships.
  4. Once the application is created, configure the Application Access settings to give yourself permission to access it.
    • Assign yourself the default role.

Customize the application:

  1. Create the application Roles
  2. For each object, create the Forms that will be used by each role
  3. Configure Forms Assignment settings to assign the forms to specific roles
  4. Configure Tab Preferences to specify the objects that will appear for each role, and the order in which they appear
  5. Configure View Preferences for each Role:
    • Select the Dashboard
    • Specify which records are shown in each object View
  6. Customize Field settings. Add additional fields, as needed.
  7. Further customize the Forms that will be seen when records are accessed or created
  8. Explore other ways to customize Objects
  9. Use the Application Access settings to specify other users who can access the application, and the roles they can play.