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;
populating, by the server, a spreadsheet with the set of logic and the version identifier;
executing, by the server, the set of logic from the spreadsheet;
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 set of logic;
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 set of answers to the set of questions inputted from the second client device;
storing, by the server, the 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 third user interface to a third client device, wherein the third user interface is configured to receive a request from the third client device;
locating, by the server, the version identifier responsive to the request from the third 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, the reflexive questionnaire with the set of questions based on the version identifier and the set of answers based on the set of metadata responsive to the request; and
presenting, by the server, the reflexive questionnaire on the third user interface to the third 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 set of logic.
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 set of metadata is a first set of metadata, wherein the set of answers is a first set of answers, wherein the version identifier is associated with a second set of metadata, wherein the second set of metadata is associated with the second set of answers to the set of questions.
9. The method of claim 1 , wherein the first client and the third client are internal to a network containing the server, wherein the second client is external to the network.
10. The method of claim 1 , wherein the set of metadata is hierarchical.
11. 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;
populate a spreadsheet with the set of logic and the version identifier;
execute the set of logic from the spreadsheet;
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 set of logic,
store the set of questions such that the set of questions is associated with the version identifier;
receive a set of answers to the set of questions from the second client device;
store the set of answers as a set of metadata;
associate the version identifier with the set of metadata;
present a third user interface to a third client device, wherein the third user interface is configured to receive a request from the third 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 the reflexive questionnaire with the set of questions based on the version identifier and the set of answers based on the set of metadata responsive to the request; and
present the reflexive questionnaire on the third user interface to the third client device responsive to the request.
12. The system of claim 11 , wherein the version identifier relates to a date the spreadsheet is populated with the set of logic.
13. The system of claim 11 , wherein the version identifier includes 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 the set of metadata.
15. The system of claim 11 , wherein the set of metadata is stored in a single data structure.
16. The system of claim 11 , wherein the set of metadata is stored in a plurality of data structures.
17. The system of claim 11 , wherein the request relates to the version identifier.
18. The system of claim 11 , wherein the set of metadata is a first set of metadata, wherein the set of answers is a first set of answers, wherein the version identifier is associated with a second set of metadata, wherein the second set of metadata is associated with the second set of answers to the set of questions.
19. The system of claim 11 , wherein the first client and the third client are internal to a network containing the server, wherein the second client is external to the network.
20. The system of claim 11 , wherein the set of metadata is hierarchical.