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 is configured to receive a set of logic and a version identifier from the first client device, the set of logic comprising a plurality of logic statements, wherein each logic statement comprises a Boolean or conditional string;
populating, by the server, a spreadsheet with the logic statements and the version identifier;
executing, by the server, the logic statements from the spreadsheet;
presenting, by the server, a second user interface to a second client device and a third user interface to a third client device, wherein the second user interface and the third user interface each contain a reflexive questionnaire with a set of questions generated based on the logic statements;
storing, by the server, the set of questions such that the set of questions is associated with the version identifier;
receiving, by the server, a first set of answers to the set of questions inputted from the second client device and a second set of answers to the set of questions inputted from the third client device;
storing, by the server, the first set of answers and the second set of answers as a set of metadata;
associating, by the server, the version identifier with the set of metadata;
presenting, by the server, a fourth user interface to a fourth client device, wherein the fourth user interface is configured to receive a request from the fourth client device;
locating, by the server, the version identifier responsive to the request from the fourth client device;
retrieving, by the server, the set of questions based on the version identifier;
retrieving, by the server, the set of metadata based on the version identifier;
generating, by the server, a first reflexive questionnaire and a second reflexive questionnaire with the set of questions based on the version identifier and the first set of answers and the second set of answers based on the set of metadata responsive to the request; and
presenting, by the server, the reflexive questionnaire on the fourth user interface to the fourth client device responsive to the request.
2. The method of claim 1 , wherein the version identifier relates to a date the spreadsheet is populated with the logic statements.
3. The method of claim 1 , wherein the version identifier includes 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 the set of metadata.
5. The method of claim 1 , wherein the set of metadata is stored in a single data structure.
6. The method of claim 1 , wherein the set of metadata is stored in a plurality of data structures.
7. The method of claim 1 , wherein the request relates to the version identifier.
8. The method of claim 1 , wherein the first client device and the fourth client device are internal to a network containing the server, wherein the third client device is external to the network.
9. The method of claim 1 , wherein the set of metadata is hierarchical.
10. A system comprising:
a server configured to:
present a first user interface to a first client device, wherein the first user interface is configured to receive a set of logic and a version identifier from the first client device, the set of logic comprising a plurality of logic statements, wherein each logic statement comprises a Boolean or conditional string;
populate a spreadsheet with the logic statements and the version identifier;
execute the logic statements from the spreadsheet;
present a second user interface to a second client device and a third client device, wherein the second user interface and the third user interface each contain a reflexive questionnaire with a set of questions generated based on the logic statements,
store the set of questions such that the set of questions is associated with the version identifier;
receive a first set of answers to the set of questions from the second client device and a second set of answers to the set of questions inputted from the third client device;
store the first set of answers and the second set of answers as a set of metadata;
associate the version identifier with the set of metadata;
present a fourth user interface to a fourth client device, wherein the fourth user interface is configured to receive a request from the fourth client device;
locate the version identifier responsive to the request from the third client device;
retrieve the set of questions based on the version identifier;
retrieve the set of metadata based on the version identifier;
generate a first reflexive questionnaire and a second reflexive questionnaire with the set of questions based on the version identifier and the first set of answers and the second set of answers based on the set of metadata responsive to the request; and
present the reflexive questionnaire on the fourth user interface to the fourth client device responsive to the request.
11. The system of claim 10 , wherein the version identifier relates to a date the spreadsheet is populated with the logic statements.
12. The system of claim 10 , wherein the version identifier includes at least one of an alphanumeric, a barcode, an image, or a sound.
13. The system of claim 10 , wherein the version identifier is stored as the set of metadata.
14. The system of claim 10 , wherein the set of metadata is stored in a single data structure.
15. The system of claim 10 , wherein the set of metadata is stored in a plurality of data structures.
16. The system of claim 10 , wherein the request relates to the version identifier.
17. The system of claim 10 , wherein the first client device and the fourth client device are internal to a network containing the server, wherein the third client device is external to the network.
18. The system of claim 10 , wherein the set of metadata is hierarchical.