Spreadsheet Form Templates with Metadata for Workflow Control
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Spreadsheet-based form design lacks the ability to distinguish between user-entered data and form structure, manage different record sets, and implement workflow tools, making it difficult for organizations to manage and track form submissions effectively, especially when compared to Business Process Management (BPM) software suites that require specialized technical expertise.
Innovation Solution
A computer-implemented method and system for form design and data input that utilizes spreadsheet templates with formula-based values and metadata for input formatting, validation rules, and workflow functions, allowing for user input evaluation and submission to a server-based form engine for compilation and data management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If spreadsheet-based form design is used, then ease of operation and user familiarity are improved, but the ability to distinguish between user-entered data and form structure deteriorates
Solution Approach 1:
The patent applies local quality by assigning different properties to different cells within the spreadsheet. Specific cells are designated as data entry cells with metadata markers that distinguish them from formula cells and structure cells. This allows the spreadsheet to maintain its user-friendly interface while internally differentiating between user-entered data and form structure through cell-specific attributes and metadata.
2Ease of operation
If spreadsheet-based form design is used, then ease of operation is improved, but the ability to manage different record sets and perform queries deteriorates
Solution Approach 1:
The patent introduces an intermediary layer between the spreadsheet interface and the data management functionality. A server-based form engine acts as a mediator that receives spreadsheet templates, processes them with metadata, and manages multiple record sets. This intermediary enables spreadsheet users to benefit from simple operation while the backend system handles complex record set management and querying capabilities.
3Ease of manufacture
If spreadsheet-based form design is used, then ease of manufacture and implementation speed are improved, but the lack of workflow tools and sequence control deteriorates
Solution Approach 1:
The patent segments the form system into distinct functional components: spreadsheet template creation, metadata annotation, server-side processing, and workflow execution. This segmentation allows the form design to remain simple and fast to implement using familiar spreadsheet tools, while the server-side components handle the complex workflow control, sequence management, and approval tracking functions that are otherwise absent from basic spreadsheets.
4Adaptability or versatility
If Business Process Management software suites are used, then workflow control and data management capabilities are improved, but ease of operation deteriorates due to requiring trained technicians
Solution Approach 1:
The patent employs copying by allowing users to create form templates using familiar spreadsheet copying and replication mechanisms. The spreadsheet-based template can be copied, modified, and distributed easily by end users without requiring technical expertise. The server-based engine then processes these copied templates and manages the underlying complexity, enabling rapid deployment of workflow-controlled forms by non-technical users.
Data Source
AI summary
Methods and systems for form design and data input collection are described. The method at a server system includes receiving a form template in which multiple cells are provided in an array, wherein in the form template a plurality of the cells define formula-based values, and a plurality of the cells include metadata specifying a required format of a cell input. The method includes rendering the form template as a form instance including providing displayable input controls for fields of the form instance based on the cell metadata in corresponding cells of the form template; receiving user inputs into fields in the form instance; and evaluating user inputs to update formula-based values for cells.