Difference between revisions of "Database Application"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
A database application is essentially a spreadsheet on steroids. In fact, you can build one by importing your spreadsheet data! Or you can use the Wizard to specify the ''objects'' (database tables) you need, the fields in those objects, and the relationships among them.
A database application is essentially a spreadsheet on steroids. In fact, you can build one by importing {{^CSV}} data exported from a spreadsheet, using the [[Application Construction Wizard]]. Or you can use the Wizard to specify the ''objects'' (database tables) you need, the fields in those objects, and the relationships among them.


Once you do, you get a running, mobile-enabled application with forms for entering and viewing data, and tabular views of your objects. You also get the ability to run [[Reports]], generate [[Charts]], all of which can be customized at will. And you get much more:
Once you do, you get a running, mobile-enabled application with [[Forms]] for entering and viewing data, and tabular [[Views]] of object data. You also get the ability to run [[Reports]] and generate [[Charts]]. And you get much more:
:* Add [[Users]] and define their [[Roles]]
:* Add [[Users]] and define their [[Roles]]
:* Organize users into [[Teams]]
:* Organize users into [[Teams]]
:* Determine which data is visible and how Forms are organized 
:* Automate procedures using [[Processes]] and [[Rules]]
:* Automate procedures using [[Processes]] and [[Rules]]
:*  
:* Define [[Email Templates]] you can use to send messages that contain record data
:* Create [[Document Templates]] that contain record data using Word, HTML, or PowerPoint
:* Create common [[Global Picklists|Picklists]] to simply data entry
:* Define [[Macros]] so users can take multiple actions on a record at the click of a mouse
 
You retain control of your data, as well. You can:
:* [[Import]] and [[Export]] data
:* Do a [[Mass Update]] to change multiple records at once
:* [[Monitoring|Monitor]] platform operations
:* Rely on the platform for [[Collision Detection and Prevention]]
 
Best of all, every feature of the application can be extensively customized to suit your purposes. For example, you can:
:* Send emails that integrate record data, and store those messages in the record history.
:* Use [[Web Forms]] to submit data from an external site
:* Create [[Sites]] to let external users interact with the system, without having to log in to the platform
:* Create [[Database Views]] that merge data from multiple objects, for use in Reports
:* [[Java API:Schedule a Job|Schedule jobs]] for automated housekeeping


''Learn more:''
''Learn more:''
:* [[Application Construction Wizard]]
:* [[Designers Index]] - For customization capabilities
:* [[Developers Index]] - For sophisticated development capabilities using programming languages
<noinclude>
 
[[Category:Applications]]
</noinclude>

Latest revision as of 23:56, 21 May 2015

A database application is essentially a spreadsheet on steroids. In fact, you can build one by importing CSV data exported from a spreadsheet, using the Application Construction Wizard. Or you can use the Wizard to specify the objects (database tables) you need, the fields in those objects, and the relationships among them.

Once you do, you get a running, mobile-enabled application with Forms for entering and viewing data, and tabular Views of object data. You also get the ability to run Reports and generate Charts. And you get much more:

  • Add Users and define their Roles
  • Organize users into Teams
  • Determine which data is visible and how Forms are organized
  • Automate procedures using Processes and Rules
  • Define Email Templates you can use to send messages that contain record data
  • Create Document Templates that contain record data using Word, HTML, or PowerPoint
  • Create common Picklists to simply data entry
  • Define Macros so users can take multiple actions on a record at the click of a mouse

You retain control of your data, as well. You can:

Best of all, every feature of the application can be extensively customized to suit your purposes. For example, you can:

  • Send emails that integrate record data, and store those messages in the record history.
  • Use Web Forms to submit data from an external site
  • Create Sites to let external users interact with the system, without having to log in to the platform
  • Create Database Views that merge data from multiple objects, for use in Reports
  • Schedule jobs for automated housekeeping

Learn more: