Difference between revisions of "Database Application"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(8 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, 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.
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:
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:
Line 9: Line 9:
:* Create [[Document Templates]] that contain record data using Word, HTML, or PowerPoint
:* Create [[Document Templates]] that contain record data using Word, HTML, or PowerPoint
:* Create common [[Global Picklists|Picklists]] to simply data entry
:* 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:
You retain control of your data, as well. You can:
:* [[Import]] and [[Export]] data
:* [[Import]] and [[Export]] data
:* Do a [[Mass Update]] to change multiple records at once
:* Do a [[Mass Update]] to change multiple records at once
:* [[Schedule Reports]] and other jobs, for automated housekeeping
:* [[Monitoring|Monitor]] platform operations
:* [[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:
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
:* 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 [[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
:* 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:''
:* [[Designers Index]] - For customization capabilities
:* [[Designers Index]] - For customization capabilities
:* [[Developers Index]] - For sophisticated development capabilities using programming languages
:* [[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: