Systems, devices, and methods for software coding
Provided methods and systems allow dynamic rendering of a reflexive questionnaire based on a modifiable spreadsheet for users with little to no programming experience and knowledge. Some methods comprise 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:
presenting, by a server, a first user interface to a first client device, wherein the first user interface comprises a spreadsheet corresponding to a version identifier;
populating, by the server, the spreadsheet with a plurality of logic statements;
presenting, by the server, a second user interface to a second client device, wherein the second user interface contains a reflexive questionnaire with a set of questions generated based on the plurality of logic statements;
receiving, by the server, a set of answers to the set of questions from the second client device;
storing, by the server, an association between the set of answers and the version identifier; and
in response to a request from a third client device, presenting, by the server, the reflexive questionnaire on a third user interface based on the stored association between the set of answers and the version identifier.
2. The method of claim 1 , wherein the version identifier comprises a date the spreadsheet is populated with the plurality of logic statements.
3. The method of claim 1 , wherein the version identifier comprises at least one of an alphanumeric, a barcode, an image, or a sound.
4. The method of claim 1 , wherein the version identifier is stored as metadata of the spreadsheet.
5. The method of claim 1 , wherein the version identifier is stored in a cell of the spreadsheet.
6. The method of claim 1 , wherein the set of answers is stored in a plurality of data structures.
7. The method of claim 1 , wherein the request identifies the version identifier.
8. The method of claim 1 , wherein presenting the questionnaire at the second client device comprises executing, by the server, one or more logic statements of the spreadsheet.
9. The method of claim 1 , wherein the first client device and the third client device are internal to a network containing the server, wherein the second client device is external to the network.
10. The method of claim 1 , wherein the set of answers is stored in a hierarchical data structure.
11. A system comprising:
a server configured to:
present a first user interface to a first client device, wherein the first user interface comprises a spreadsheet corresponding to a version identifier;
populate the spreadsheet with a plurality of logic statements;
present a second user interface to a second client device, wherein the second user interface contains a reflexive questionnaire with a set of questions generated based on the plurality of logic statements;
receive a set of answers to the set of questions from the second client device;
store an association between the set of answers and the version identifier; and
in response to a request from a third client device, present the reflexive questionnaire on a third user interface based on the stored association between the set of answers and the version identifier.
12. The system of claim 11 , wherein the version identifier comprises a date the spreadsheet is populated with the plurality of logic statements.
13. The system of claim 11 , wherein the version identifier comprises at least one of an alphanumeric, a barcode, an image, or a sound.
14. The system of claim 11 , wherein the version identifier is stored as metadata of the spreadsheet.
15. The system of claim 11 , wherein the version identifier is stored in a cell of the spreadsheet.
16. The system of claim 11 , wherein the set of answers is stored in a plurality of data structures.
17. The system of claim 11 , wherein the request comprises the version identifier.
18. The system of claim 11 , wherein the server is configured to present the questionnaire at the second client device by executing one or more logic statements of the spreadsheet.
19. The system of claim 11 , wherein the first client device and the third client device are internal to a network containing the server, wherein the second client device is external to the network.
20. The system of claim 11 , wherein the set of answers is stored in a hierarchical data structure.