Systems, devices, and methods for software coding
View Patent ↗Provided method and system allow dynamic rendering of a reflexive questionnaire based on a modifiable spreadsheet for users with little to no programming experience and knowledge. The method comprises receiving a modifiable spreadsheet with multiple rows, each row comprising rendering instructions for a reflexive questionnaire from a first computer, such as a data type cell, statement cell, logic cell, and a field identifier; rendering a graphical user interface, on a second computer, comprising a label and an input element corresponding to the rendering instructions of a first row of the spreadsheet; receiving an input from the second computer; evaluating the input against the logic cell of the spreadsheet; in response to the input complying with the logic cell of the spreadsheet, dynamically rendering a second label and a second input element to be displayed on the graphical user interface based on the logic of the first row.
1. A method comprising:
receiving, by a server, a message from an application running on a client;
reading, by the server, a spreadsheet containing a plurality of rows each having a plurality of cells among which a text statement, a data type identifier, and a logic statement comprising a Boolean or conditional string are linearly distributed in separate cells, wherein the spreadsheet is remote from the client, wherein the rows include a first row and a second row;
generating, by the server, a first set of executable code programmed to cause the application to present a first text string based on the text statement of the first row and a first user input field based on the data type identifier of the first row, wherein the first string one-to-one corresponds to the first user input field;
transmitting, by the server, the first set of executable code to the application responsive to the message;
receiving, by the server, a user input from the first user input field;
evaluating, by the server, the user input against the Boolean or conditional string of the logic statement of the first row;
generating, by the server, a second set of executable code based on the user input satisfying the logic statement of the first row, wherein the second set of executable code is programmed to cause the application to present a second text string based on the text statement of the second row and a second user input field based on the data type identifier of the second row, wherein the second string one-to-one corresponds to the second user input field; and
transmitting, the second set of executable code to the application responsive to the user input.
2. The method of claim 1 , wherein the first row is not immediately adjacent to the second row.
3. The method of claim 1 , wherein each of the first row and the second row contains only text.
4. The method of claim 1 , wherein at least one of the first set of executable code or the second set of executable code includes a markup language content.
5. The method of claim 1 , wherein each of the rows includes a key, wherein the second set of executable code is generated based on the Boolean or conditional string of the logic statement of the first row referencing the key of the second row.
6. The method of claim 1 , wherein each of the rows includes a help statement that is presentable in association with the text statement of that respective row when the help statement is requested within the application.
7. The method of claim 1 , wherein the application presents a reflexive questionnaire including at least one of (a) the first text string based on the text statement of the first row and the first user input field based on the data type identifier of the first row, or (b) the second text string based on the text statement of the second row and the second user input field based on the data type identifier of the second row.
8. The method of claim 1 , wherein the spreadsheet includes a parent worksheet and a child worksheet, wherein the parent worksheet includes the rows, wherein the child worksheet includes a third row inheriting at least one of a property, an attribute, or a feature of at least one of the rows.
9. The method of claim 1 , wherein the application is a browser.
10. A system comprising:
a server programmed to:
receive a message from an application running on a client;
read a spreadsheet containing a plurality of rows each having a plurality of cells among which a text statement, a data type identifier, and a logic statement comprising a Boolean or conditional string are linearly distributed in separate cells, wherein the spreadsheet is remote from the client, wherein the rows include a first row and a second row;
generate a first set of executable code programmed to cause the application to present a first text string based on the text statement of the first row and a first user input field based on the data type identifier of the first row, wherein the first string one-to-one corresponds to the first user input field;
transmit the first set of executable code to the application responsive to the message;
receive a user input from the first user input field;
evaluate the user input against the Boolean or conditional string of the logic statement of the first row;
generate a second set of executable code based on the user input satisfying the logic statement of the first row, wherein the second set of executable code is programmed to cause the application to present a second text string based on the text statement of the second row and a second user input field based on the data type identifier of the second row, wherein the second string one-to-one corresponds to the second user input field; and
transmit the second set of executable code to the application responsive to the user input.
11. The system of claim 10 , wherein the first row is not immediately adjacent to the second row.
12. The system of claim 10 , wherein each of the first row and the second row contains only text.
13. The system of claim 10 , wherein at least one of the first set of executable code or the second set of executable code includes a markup language content.
14. The system of claim 10 , wherein each of the rows includes a key, wherein the second set of executable code is generated based on the Boolean or conditional string of the logic statement of the first row referencing the key of the second row.
15. The system of claim 10 , wherein each of the rows includes a help statement that is presentable in association with the text statement of that respective row when the help statement is requested within the application.
16. The system of claim 15 , wherein the application presents a reflexive questionnaire including at least one of (a) the first text string based on the text statement of the first row and the first user input field based on the data type identifier of the first row, or (b) the second text string based on the text statement of the second row and the second user input field based on the data type identifier of the second row.
17. The system of claim 15 , wherein the spreadsheet includes a parent worksheet and a child worksheet, wherein the parent worksheet includes the rows, wherein the child worksheet includes a third row inheriting at least one of a property, an attribute, or a feature of at least one of the rows.
18. The system of claim 10 , wherein the application is a browser.