Systems, devices, and methods for software coding

Patent metadata

Field	Value
Publication number	US-11210459-B1
Application number	US-201715714870-A
Country	US
Kind code	B1
Filing date	Sep 25, 2017
Priority date	Sep 23, 2016
Publication date	Dec 28, 2021
Grant date	Dec 28, 2021

Abstract

A method comprising displaying a first GUI to a first client comprising an option to check-out and a check-in a spreadsheet comprising at least one row comprising a statement a statement, a data type identifier, and a logic; checking-out the file such that the file cannot be modified by a second client; receiving from the first client, a modification request and a modification input; modifying the checked-out spreadsheet based on the modification input; checking-in the file; generating a set of rendering instructions corresponding to a second GUI based on the modified spreadsheet; and transmitting the set of rendering instructions to a computing device associated with a third client, whereby the set of rendering instructions causes the computing device associated with the third client to display the second graphical user interface.

First claim

What is claimed is:

1. A method comprising:
displaying, by a server, a first graphical user interface to a first client, wherein the first graphical user interface comprises a check-out element configured for a check-out input related to a file and a check-in element configured for a check-in input related to the file, wherein the file comprises a spreadsheet, wherein the spreadsheet comprises a plurality of rows that are positioned immediately adjacent to each other, wherein each of the rows comprises a statement cell comprising a statement, a data type cell comprising a data type identifier, and a logic cell comprising a logic;
in response to receiving, by the server, the check-out input from the first client, checking-out, by the server, the file such that the file cannot be modified by a second client until the server receives the check-in input from the first client;
receiving, by the server, from the first client, a modification request associated with the file that is checked-out and a modification input associated with the modification request;
modifying, by the server, for at least one of the rows, at least one of the statement, the data type identifier, or the logic based on the modification request and the modification input from the first client;
in response to receiving, by the server, the check-in input from the first client after the at least one of the statement, the data type identifier, or the logic has been modified based on the modification request and the modification input from the first client, checking-in, by the server, the file such that the file can be modified by the second client;
generating, by the server, a set of rendering instructions corresponding to a second graphical user interface based on the rows of the spreadsheet after the spreadsheet has been modified such that the second graphical user interface comprises a plurality of labels and a plurality of input elements, wherein the labels are conditionally generated based on the statement in each of the statement cells and the logic in each of the logic cells, wherein the input elements are conditionally generated based on the data type identifier in each of the data type cells and the logic in each of the logic cells, wherein the rows one-to-one correspond to the labels, wherein the rows one-to-one correspond to the input elements, wherein the labels one-to-one correspond to the input elements, wherein at least one of the labels comprises at least one of the statements, wherein at least one of the input elements is configured for an input based on at least one of the data type identifiers, wherein the second graphical user interface is a reflexive questionnaire formed via the labels and the input elements; and
transmitting, by the server, the set of rendering instructions to a third client, whereby the set of rendering instructions causes the third client to display the second graphical user interface when the set of rendering instructions is executed by the third client.

2. The method of claim 1 , wherein the file is stored in the first client.

3. The method of claim 1 , wherein the spreadsheet is partially stored in the first client and the second client.

4. The method of claim 1 , further comprising:
notifying, by the server, the second client that the file is checked out, in an event that the second client attempts to modify the file when the file is checked out.

5. The method of claim 1 , wherein the server notifies via a notification that comprises an identification of the first client.

6. The method of claim 1 , further comprising:
upon rendering the second graphical user interface on the third client, receiving, by the server, a plurality of inputs corresponding to the input elements.

7. The method of claim 1 , further comprising:
generating, by the server, a second file corresponding to the second graphical user interface rendered on the third client.

8. The method of claim 7 , wherein the second file comprises at least the inputs received from the third client.

9. The method of claim 1 , wherein the server receives the modification request from the first client.

10. The method of claim 1 , wherein the third client is a mobile device.

11. A computer system comprising:
a server comprising a hardware processor and a non-transitory computer-readable storage medium containing instructions that when executed by the hardware processor cause the hardware processor to perform operations comprising to:
display a first graphical user interface to a first client, wherein the first graphical user interface comprises a check-out element configured for a check-out input related to a file and a check-in element configured for a check-in input related to the file, wherein the file comprises a spreadsheet, wherein the spreadsheet comprises a plurality of rows that are positioned immediately adjacent to each other, wherein each of the rows comprises a statement cell comprising a statement, a data type cell comprising a data type identifier, and a logic cell comprising a logic;
in response to receiving the check-out input from the first client, check-out the file such that the file cannot be modified by a second client until the server receives the check-in input from the first client;
receive from the first client, a modification request associated with the file that is checked-out and a modification input associated with the modification request;
modify, for at least one of the rows, at least one of the statement, the data type identifier, or the logic based on the modification request and the modification input from the first client;
in response to receiving the check-in input from the first client after the at least one of the statement, the data type identifier, or the logic has been modified based on the modification request and the modification input from the first client, check-in the file such that the file can be modified by the second client;
generate a set of rendering instructions corresponding to a second graphical user interface based on the rows of the spreadsheet after the spreadsheet has been modified such that the second graphical user interface comprises a plurality of labels and a plurality of input elements, wherein the labels are conditionally generated based on the statement in each of the statement cells and the logic in each of the logic cells, wherein the input elements are conditionally generated based on the data type identifier in each of the data type cells and the logic in each of the logic cells, wherein the rows one-to-one correspond to the labels, wherein the rows one-to-one correspond to the input elements, wherein the labels one-to-one correspond to the input elements, wherein at least one of the labels comprises at least one of the statements, wherein at least one of the input elements is configured for an input based on at least one of the data type identifiers, wherein the second graphical user interface is a reflexive questionnaire formed via the labels and the input elements; and
transmit the set of rendering instructions to a third client, whereby the set of rendering instructions causes the third client to display the second graphical user interface when the set of rendering instructions is executed by the third client.

12. The computer system of claim 11 , wherein the file is stored in the first client.

13. The computer system of claim 11 , wherein the spreadsheet is partially stored in the first client and the second client.

14. The computer system of claim 11 , wherein the server is further configured to:
notify the second client that the file is checked out, in an event that the second client attempts to

Assignees

• Massachusetts Mutual Life Insurance Co

Inventors

• Krishnaswamy Harish
• Elsamman Sam

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F40/166 Primary

  Editing, e.g. inserting or deleting · CPC title

• G06F40/106

  Display of layout of documents; Previewing · CPC title

• G06F40/103

  Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191) · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title