| |
|
|
|
|
|
|
  | | Data Access (11) | | | | |
| | | | Different between Custom List with & without SQL View |
|  | Able to filter display data using SQL Query | Easily filter view data using SQL Query | |
| | | | Shared Data Connection Pool |
| | Centralized access definition to external databases | Makes it easy to access external data | |
| | | | Access SharePoint data as SQL View |
| | Access data stored in SharePoint as SQL views | Performs complex analysis of SharePoint data | |
| | | | | Able to join multiple SharePoint list to provide highly usable data views with filter and ordering. | Access SharePoint data as SQL | |
| | | | Aggregate Views on Sharepoint Custom List |
|  | Provide pivot-style functionalities on SharePoint data to aggregate data using functions such as Count, Max, Min, sum, Average and time-based based groupings. | Simplify reporting on SharePoint data | |
| | | | | Allows you to build multiple Entity Relationships (ER) diagram to ensure a consistent database design; especially for building reports. | Communicate database design to ensure consistent data retrieval across all reports. | |
| | | | | Provide direct access to SQL data for centralized data repository. Suggested scenarios: employee database, customer database, product database, etc... | Provide a high performance SQL database for sharing information across the entire portal. | |
| | | | | Define Workflow using our standard GUI or a new Silverlight Workflow Editor | Visual representation of workflow and easier to use | |
| | | | How To Generate Data Sources by SQL(Read Only) |
| | Pre-Configure Data Source for retrieving data from external databases | Manage Data Sources which can then be reused throughout the solution | |
| | | | Document Library, Image Library, Wiki Page Library |
| | Create Document Library, Image Library and Wiki Page Library | Manage all Document Libraries from AppStudio | |
| | | | Create Virtual List from Custom List |
| | Stores data in SQL Server using SPList as templates | Build relational database, harness the power of Sharepoint forms but stores the data in SQL Tables. | |
| | Data Entry (30) | | | | |
| | | | | Configuring advance lookups | Lookup values from multiple sources. | |
| | | | Dependent Advanced Lookup |
| | Multiple dependent lookup inherits values from each other | Easily create dependent lookup by passing lookup values as parameters and filters | |
| | | | How to perform validation on certain form |
| | Sets form validations | Validate data entry by setting rules and validations. | |
| | | | | Hides the custom list from Site Libraries and Lists. Users will also be unable to create a View Webpart from the List. | Prevent access to sensitive data in the list, ensure data integrity is only maintained via SmartList. | |
| | | | | Prevents access to the associated Allitems.aspx page | Secure sensitive data and views to ensure views are governed by SmartView Roles. | |
| | | | Advanced Lookup (Projection and Return Value) |
| | Allow users to import(project) related data automatically when selecting from a lookup | Provides the ability to use related data when selecting from a lookup. | |
| | | | Advanced Lookup (Searchable Lookup) |
| | Gives a popup search dialog to filter/search for lookup data | Ability to further filter lookup data when selecting. | |
| | | | Advanced Lookup with Parameters |
| | Filter Lookup options based on parameters and criteria | Only show lookup values which are relevant. | |
| | | | Caption, Description, Default Value, Required Column and Column Width Settings |
| | Set captions, descriptions, default values, required columns and column widths for each column | Control the behavior and layout of your control in the SmartList | |
| | | | Use infopath to design your forms |
| | Take advantage of Infopath to design your data entry forms so that you can build crisp professionally looking forms. Requires InfoPath license for this functionality. | Design impressive data entry forms with InfoPath simplicity. | |
| | | | Modal Forms (SharePoint 2010 only) |
| | Pop-up modal forms for data entry while viewing data in a table. | Provides intuitive data entry interface | |
| | | | | Supports parent child data entry, e.g. Sales Orders with item lists. | Make it easy to enter parent-child transactions | |
| | | | Enabling Enterprise Audit on Selected List |
| | Enables Enterprise Audit Tracking on the selected lists. Tracks transactional views, add and edits. Audit Log Views appears in SmartList Forms | Track transactions on the selected list and allows users to view and audit data changes. | |
| | | | | Able to control with fields are accessible by different group of users at different stage of data processing state. | Useful for collaborative transaction processing; submit/approve scenarios | |
| | | | | Able to peform field validation during data entry. | Improves data entry process | |
| | | | | Able to perform actions upon save; such as adding/updating related lists items or SQL database; sending email notification, calling web services, etc... | Able to support complex transaction processing functions during data entry. | |
| | | | | Able to look up values from another list/ SQL table and populate it into selected fields during data entry | Use to load data from related tables during data entry. | |
| | | | | Hide & display certain function within Views | Easily customize the features within views | |
| | | | How to form virtual group |
| | Enable to create group using SP List & SQL | Manage to customize group base on different condition using SP List or SQL | |
| | | | How to use custom functions |
| | Allow to add additional function to retrieve data which requires calculation, comparison and etc | Able to add additional calculated data easily | |
| | | | | Able to retrieve data from different database | Able to retrieve data from different database easily | |
| | | | Link Virtual List from SQL Table |
| | Able to form a virtual list base on the table in SQL Database | Easily form a list from the table in SQL Database | |
| | | | Multiple roles to access different form in different stage |
| | Roles as access criteria to forms/stages. | Use Sharepoint Groups or Roles to decide the correct form to be presented. | |
| | | | Transaction Action - Show Message |
| | Displays an alert message. | Build simple notification actions. | |
| | | | Transaction Advanced Settings (Add, Edit & Delete Button) |
| | Manage form buttons such as Add, Edit and Delete. | Show or Hide buttons based on conditions | |
| | | | Transaction Advanced Settings (Welcome User, Ribbon, Owner Details, Top & Bottom buttons) |
| | Configure layout of User Welcome Notifications, Form buttons, Owner Details and Ribbon | Configure the layout of common buttons and sections on a form. | |
| | | | Transaction Advanced Settings (Manage Permission, Alert Me, Workflow and Debug Mode) |
| | Configure Manage Permission, Alert Me, Workflow buttons and Debug Mode | Manage form security, notifications and back-end processes. | |
| | | | Transaction Advanced Settings (After Save and Cancel URL) |
| | Configure the page to navigate to upon save or cancel | Sets URL of page upon Save or Cancel | |
| | | | Transaction with Individual Advanced Settings |
| | Sets a specific form/webparts advanced settings | Customized advanced settings for an individual form or webparts. | |
| | | | Transaction - Email Attachment settings |
| | Allow user to have additional settings for email attachment | User may choose file types to be attached in email | |
| | Deployment (8) | | | | |
| | | | | Allow to duplicate a solution to other environment | Easily duplicate a copy of the solution to perform testing or Live environment | |
| | | | | Able to save an application as a single file. Able to control whether deployed solution can be re-deployed. | Simplifies redeployment of solutions while provides basic IP protection. | |
| | | | Deploy SharePoint 2007 solutions to 2010 |
| | Package your SharePoint 2007 applications and deploy it to the new SharePoint 2010 (all editions) with a few clicks. | Simply the easiest way to migrate SharePoint 2007 applications to the new version. | |
| | | | Import form settings from another form |
| | Import settings from another configured form. | Saves time from re-creating the entire form by just importing the settings | |
| | | | Link an Existing Document Library |
| | Link an existing Document Library to be used in the Solution | Provides more functionality after linking the library to Appstudio. | |
| | | | | Link an existing custom list into the solution | Easily manage Custom Lists and properties from within AppStudio | |
| | | | How to apply webparts into the page |
| | Adds configured Webparts into a solution page | Apply webparts & manage its properties from AppStudio | |
| | | | | Categorize different modules within the solution | Manage the solution by grouping each module with a named category | |
| | Development (10) | | | | |
| | | | Using the Relationship Diagram |
| | Build an ER Diagram for relationships between custom lists | Easily manage custom list relationships | |
| | | | Data Source by SQL(Executable) |
| | Creates an external datasource by allowing a pre-saved SQL Query | Pre-configured SQL queries allows for re-usability throughout the system | |
| | | | Create Sharepoint Group and Add a User to Group |
| | Create a New Sharepoint Group from within Appstudio | Easily manage Sharepoint Groups and Users | |
| | | | Using the Profile Provider |
| | Link another Solution as an Enhanced User Profile with additional columns | Conveniently link multiple solutions together to share User Profiles | |
| | | | Enforcing List Relationships |
| | Links Custom List via an ER Diagram | Easily manage relationship between lists. This enables Data Sources within SmartView to build comprehensive data reports. | |
| | | | | Provide an additional filter to group webparts. | Make it easier to organize and find webparts | |
| | | | | Upload and stores system icons and images that can then be selected for use in SmartList, SmartView and SmartMenu. | Single Image Repository for entire solutions. Users need to worry about image URLs or deal with permissions issues when using icons or images. | |
| | | | | Centralized catalog of all defined webparts for easy re-use | Able to find all defined webparts and where they are used. | |
| | | | Version Control for Webparts |
| | Able to maintain multiple version for each webparts with major/minor numbering. Can roll backwards and forward to selected version. | Helps to manage system development cycle. | |
| | | | Development Team Access Control |
| | Controls who can access AppStudio development environment with differentiated roles between database access and application access. | Prevents non-authorized access to backend data. | |
| | Layout (8) | | | | |
| | | | Upload and Set Site Masterpage |
| | Change Masterpage for the solution from within AppStudio | Easily manage solution and default masterpage | |
| | | | Export List Columns to Infopath via XML |
| | Export custom list columns definitions to Infopath via XML file | Quickly drag and drop Custom List fields during design of Infopath Form Layout. | |
| | | | SmartList Form Layout using Infopath Templates |
| | Use an Infopath for as the Layout for SmartList | Directly import Infopath form layout and themes into SmartList forms | |
| | | | Upload Infopath Templates |
| | Upload Infopath templates into AppStu | Easily manage all Infopath Layouts used in the solution | |
| | | | 3 types of form layouts (Default, Infopath, Advanced) |
| | Different ways to customize the layout of your form | Choose from a default layout, Infopath layout or advanced HTML layout for your form | |
| | | | Design and Upload Infopath |
| | Design an Infopath form and upload into Appstudio | Use Infopath to design Sharepoint Forms. | |
| | | | | User allow to change the display of search layout | Search layout can be easily change by putting HTML code in the layout | |
| | | | Reports – Apply and Customize Template |
| | Reports template can be customize or change | Reports template can be easily change or customize | |
| | Navigation (8) | | | | |
| | | | Navigation – Top Menu and Side Menu |
| | Configure navigation option for Top Menu & Side Menu | Top & Side menu can be easily configure | |
| | | | | Navigation bar able to allocate in any corner of the page by applying the code in master page. | Flexibility of allocating the navigation bar in each page | |
| | | | Navigation - Display level and Top Custom Level |
| | User able to choose to display the level of nodes to be display in navigation | Allow flexibility to display level of nodes on top or side bar. | |
| | | | | http://dennisssblegh.com|dennisheylove your site! | http://dennisssblegh.com|dennisheylove your site! | |
| | | | | Sets the welcome page for the solution. | Easily manage the welcome page without programming or coding. | |
| | | | Clone a Page with Selected Webparts |
| | Clones a solution page and associated webparts | Build a new page with webparts ready-to-go with a single click | |
| | | | | Create a Solution Page with specified template and masterpage | Easily create a new page and allow AppStudio to manage it | |
| | | | Contextual ribbon menus (2010 only) |
| | Provide contextual ribbon menus while editing lists items | Intuitive interation | |
| | Properties (20) | | | | |
| | | | Apply Masterpage to a Selected Page |
| | Change Masterpage for a selected page from within AppStudio | Easily manage solution pages and masterpage | |
| | | | Enabling Enterprise Audit on Entire Solution |
| | Enables Enterprise Audit Tracking on the entire solution. Tracks transactional views, add and edits. Audit Log Views appears in SmartList Forms. | Track transactions on the solution and allows users to view and audit data changes. | |
| | | | Enabling Webparts Versioning |
| | Enables Version Control on Webparts Definitions for SmartList, SmartView and SmartMenu | Versioning allows development testing on minor versions and publishing of major versions when definition is ready to go-live. Alternatively users may revert to an older version. | |
| | | | How to generate data source by Webservice |
| | Cater the ability to enhance external webservices | Allow user to apply their webservice in Appstudio | |
| | | | Transaction Action - Update Variable |
| | Variable is a function to temporary store a value, then can apply the variable to other columns or functions | Allow user to store value before it change and update that value for other purposes | |
| | | | Transaction - Email Subject and Message |
| | Provide columns for user to key in the email subject and message for each email to be sent | Static or dynamic email subject and message can be easily configure in order to send out the email correctly | |
| | | | | Future task or repeated task can be updated by setting the scheduled in Transaction Action | Scheduled action can be easily configure to provide automation of action to be perform once the date and time are met | |
| | | | Transaction Action - Add Update SQL Record |
| | Allow user to perform action to add, update record through SQL | For SQL competent user to update record easily through SQL script | |
| | | | Transaction Action - Add Update Sharepoint Item |
| | Allow user to perform add or update function without scripting | Data can be easily added or updated without scripting | |
| | | | Transaction Action – Branching |
| | The branching logic can be amend through transaction action | The workflow can be change accordingly by updating the branching through transaction action | |
| | | | Transaction Action - Call Web Service |
| | Provide a functionality to call webservice when action are triggered | Easily call a webservice through transaction action settings | |
| | | | Transaction Action - Copy Document |
| | Provide a functionality to duplicate document into different path | Document can be easily copied and pasted into other path which user define in transaction action | |
| | | | Transaction Action - Create Document Folder |
| | Able to create document folder to store individuals document within the folder provided | Document folder can be easily created by triggering the transaction action settings | |
| | | | Transaction Action - Delete Item |
| | Provide functionality to delete item through transaction action | A function of item deletion can be easily configure to remove data whenever the action are triggered | |
| | | | Transaction Action - How to Import Action |
| | Display the steps to import action from other transaction | Action can be imported from other source, to prevent user to re-create the action repeatedly | |
| | | | Transaction Action - OnSave & OnLoad |
| | Option to trigger action during form save or during form load | During the form on Save or on Load, user may put in additional action such as email or update function | |
| | | | Transaction Action - Rename Folder |
| | Folder can be rename by triggering a transaction action | Folder can be easily rename by setting up the configuration for transaction action | |
| | | | Transaction Action - Send Email (Direct Email) |
| | A static email address email can be configure in order to send the email to this recipient whenever action are triggered | Function to send email to a static email address can easily configure | |
| | | | Transaction Action - Send Email (SQL) |
| | A dynamic email address email can be updated through SQL script in order to send the email to this recipients whenever action are triggered | Function to send email to a dynamic email address through SQL script can be easily configure | |
| | | | Transaction Action - Send Email(SPList) |
| | Email address determine by Sharepoint List | Function to send email to a dynamic email address through Sharepoint List can be easily configure | |
| | Reporting (30) | | | | |
| | | | Reports - Calendar (More) |
| | Provide more additional feature for Calendar view | Easily configure the additional settings to display more columns in the calendar view | |
| | | | | Allow to display data in a calendar view | Able to manage the task easily by looking at each slot in the calendar view | |
| | | | Reports – Get Web Services Data Source |
| | Display how to apply webservice that been created in datasource into reports | Easily generate reports by applying webservices | |
| | | | Reports - Differences of Default View and Aggregate Group |
| | There are 2 types of view can be apply in datasource for reports which are Default View and Aggregate Group | Differentiate the 2 option and apply accordingly to display a better report | |
| | | | | Appstudio reports include creating gantt chart reports | Gantt chart can be easily created by putting in the correct configuration | |
| | | | Reports - Ordering and Filter Parameter in Datasource |
| | Allow user to order the data accordingly and filter the necessary data to be display | Ordering and filtering can be easily configure through datasource in report | |
| | | | Reports – Different in Data Source |
| | Reports can be generate in different source | Report can easily generated by different data source | |
| | | | Reports – How to Clone a Smartview Definition |
| | Able to clone smartview definition to prevent re-create similar definition | Less time consuming compare to create the entire smartview definition from step 1 | |
| | | | Reports – Datagrid how to apply multiple select checkbox |
| | Allow to select multiple data to perform certain action | Less time consuming compare selecting 1 by 1 to perform certain action | |
| | | | Reports – Datagrid Standard Features |
| | Datagrid display data in row columns format | Datagrid settings can be easily configure to display data according user expectation | |
| | | | Reports – Datagrid Totals |
| | Data type which is number can be sum up and display in datagrid | Datagrid has the ability to calculate the total for certain column user which to count | |
| | | | Reports – Gauge (Advanced Settings) |
| | Advanced settings include drill down option, gauge template, max number, min number and etc | Gauge settings can be easily configure to suit everyone | |
| | | | | Gauge can only display 1 data which is number | Gauge display single data clearly | |
| | | | Reports – Join list and select columns in data source |
| | Report can be generate base on different list that joins together | Report can be generate base few different joined lists | |
| | | | Reports – Layout (Infopath layout) |
| | Report can be using infopath layout | Report display using infopath can reduce HTML coding | |
| | | | Reports – Layout (Smartlayout) |
| | Layout templates available to display data in different layout | Less time consuming by using those layout template to display data | |
| | | | Reports – Chart (Advanced Settings) |
| | Charts advanced settings can be configure to display or hide some controls | Charts advanced settings can be easily configure to show or hide some additional control | |
| | | | Reports – Chart Enable drill down |
| | Charts can drill down to view details | Charts drill down function allow user to view more details on how the figure sum up | |
| | | | Reports – Chart Settings (Axis) |
| | Enable additional chart settings to identify the axis layout | Axis layout in chart settings can be easily configure | |
| | | | Reports – Chart Settings (Label) |
| | Enable additional chart settings to label necessary information and display in chart | Can easily set the labeling in the chart settings to display necessary information | |
| | | | Reports – Datagrid Advanced Field |
| | KPI icons and progress bar can be generated in reports view | KPI icons and progress bar can easily generated in reports view | |
| | | | Reports – Datagrid Advanced Settings |
| | Some control such as paging, columns selection can be configure through Advanced Settings | Datagrid advanced settings allow user to hide or display necessary control | |
| | | | Reports – Datagrid Condition Filter |
| | Condition filter allow user to filter certain condition to display on datagrid view | Datagrid can be configure to view own data only through condition filter | |
| | | | Reports – Datagrid Custom Menu and Action |
| | Datagrid view allow to set customize menu or action to perform certain action such as update data, add data, send email and etc | Custom Menu and action allow user to perform action to update, add, delete, send email and etc | |
| | | | | Able to build animated Silverlight gauges | Provide impressive data visualization | |
| | | | | Many type of charts to choose from: Area, Line, Bar, Column, Doughnut, Pie, Stacked, Point, Bubble, etc... Can select animation styles with ability to drill-down to item details. | Delivers impressive charting experience with ease. | |
| | | | Multi-layer datagrid with action menu |
| | Able to build data grids with multiple layer that controls access to different layer of data in a single webpart zone. Provides customized menu option with permission control. | Able to build impressive data grids for data entry. | |
| | | | | Easy to use highly customizable layout for search parameter for data-grid style reporting | Simplify creation of search functions for SharePoint and SQL data. | |
| | | | AJAX based DataGrid Views |
| | Provides multiple views on a single webpart zone for displaying data grids data with many attractive style templates. | Able to paged data presentation with permission control on who can see what first in a single webparts zone. | |
| | | | Traffic lights KPI Icons Style templates |
| | Provide a rich collection of KPI icons style templates to make data more presentation. Users can also add their own icon sets. | Makes data comes alive. | |
| | Security (10) | | | | |
| | | | | Link existing SharePoint groups into Appstudio Groups | Groups that appear in Appstudio may be applied in Appstudio modules | |
| | | | | Setup Developer access rights to different modules in Appstudio | Allows different people with different roles in Appstudio to access certain modules in AppStudio. | |
| | | | Differences of Role name for Developers |
| | Categorize developer access by roles | Limit certain developers to their area protecting sensitive data and configurations. | |
| | | | | Define Validations that are common for all forms/stages. | Single point of definition for validations | |
| | | | Multiple roles to access different form in different stage |
| | Separate roles access into different stages and forms | Creates workflow stages and access matrix based on roles and forms | |
| | | | | Sets the different roles priority | Prioritize the way roles are selected when deciding stages and roles within a workflow | |
| | | | Standard vs Dynamic Access Control |
| | Allow to hide, lock or enable columns based on conditions. | Easily set the columns availability | |
| | | | | Set transaction conditions for user access to forms | easily manage access for different users based on transaction condition. | |
| | | | Transaction Custom Condition |
| | Sets custom conditions for user access to the form | easily manage access for different user using custom conditions. | |
| | | | Navigation – Permission Role |
| | Navigation nodes can be manage by different groups or users | Easily to define navigation nodes to be view and click by different set of groups or users | |
| | Workflow (2) | | | | |
| | | | Reports – Datagrid Groupings |
| | Able to group similar data for selected column | Data can be easily found or understand through grouping the specific column | |
| | | | | Drag and drop designer to define and build workflow with transaction state management and branching logic | Able to build complex workflow without any programming. | |