Back to results
US 10,896,288 B1Granted
Systems, devices, and methods for software coding
AssigneeMassachusetts Mutual Life Insurance Company
InventorsMark Sayre, Karen Fontaine, Harish Krishnaswamy, Sam Elsamman
Life of this patent
Estimating the term…
Abstract
Methods and systems described herein allow dynamic rendering of a reflexive questionnaire based on a modifiable spreadsheet for users with little to no programming experience and knowledge. The method and system allow retrieving a spreadsheet to generate a dynamic and reflexive graphical user interface and to pre-populate one or more input elements within the reflexive graphical user interface based on user information retrieved from a disparate data source, where the spreadsheet may be configured for a worksheet inheritance or where the worksheet may be accessed through a check-in/check-out functionality.
Claims20
A method comprising:
- causing, by a server, a user interface to be presented on a client, wherein the user interface is programmed to receive a selection of an image depicting a set of data;
- receiving, by the server, a copy of the image based on the selection;
- recognizing, by the server, a pattern in the set of data sourced from the copy;
- generating, by the server, a query based on the pattern;
- submitting, by the server, the query to a database;
- receiving, by the server, a response to the query from the database;
- accessing, by the server, a spreadsheet containing a plurality of rows each having a plurality of cells among which a plurality of text statements, data type identifiers, and logic statements are linearly distributed;
- causing, by the server, the user interface to present a reflexive questionnaire having a plurality of first questions and a plurality of first user input fields, wherein the first user input fields correspond to the first questions, wherein the first questions and the first user input fields are generated based on the text statements and the data type identifiers sourced from the spreadsheet, wherein the first user input fields are prepopulated with a content based on the response;
- evaluating, by the server, the content against the logic statements;
- and
- updating, by the server, the user interface such that the reflexive questionnaire presents a plurality of second questions and a plurality of second user input fields based on the content satisfying the logic statements, wherein the second user input fields correspond to the second questions, wherein the second questions and the second user input fields are generated based on the text statements and the data type identifiers sourced from the spreadsheet.
8 more elements
A system comprising:
- a server programmed to:
- cause a user interface to be presented on a client, wherein the user interface is programmed to receive a selection of an image depicting a set of data;
- receive a copy of the image based on the selection;
- recognize a pattern in the set of data sourced from the copy;
- generate a query based on the pattern;
- submit the query to a database;
- receive a response to the query from the database;
- access a spreadsheet containing a plurality of rows each having a plurality of cells among which a plurality of text statements, data type identifiers, and logic statements are linearly distributed;
- cause the user interface to present a reflexive questionnaire having a plurality of first questions and a plurality of first user input fields, wherein the first user input fields correspond to the first questions, wherein the first questions and the first user input fields are generated based on the text statements and the data type identifiers sourced from the spreadsheet, wherein the first user input fields are prepopulated with a content based on the response;
- evaluate the content against the logic statements;
- and
- update the user interface such that the reflexive questionnaire presents a plurality of second questions and a plurality of second user input fields based on the content satisfying the logic statements, wherein the second user input fields correspond to the second questions, wherein the second questions and the second user input fields are generated based on the text statements and the data type identifiers sourced from the spreadsheet.
9 more elements
Dependencies are inferred from the claim text.