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:
identifying, by a server, a first document identifier and a first version identifier to a first worksheet, wherein the first worksheet includes a plurality of first keys and a plurality of first logic statements, wherein the first keys one-to-one correspond to the first logic statements;
identifying, by the server, a second document identifier and a second version identifier to a second worksheet, wherein the second worksheet includes a second key and a second logic statement, wherein the second key one-to-one corresponds to the second logic statement, wherein a first key of the plurality of first keys and the second key semantically correspond to each other;
linking, by the server, the second worksheet to the first worksheet based on at least one of the second document identifier, the second version identifier, the first document identifier, or the first version identifier;
receiving, by the server, a request comprising at least the second document identifier and the second version identifier;
executing, by the server, the first logic statements by calling the second key instead of the first key such that the second logic statement overrides the first logic statement; and
presenting, by the server, an output based on the execution.
2. The method of claim 1 , wherein a first logic statement of the plurality of first logic statements and the second logic statement are semantically different from each other.
3. The method of claim 1 , wherein the first logic statements comprises a third key, wherein executing the first logic includes:
calling, by the server, a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; and
importing, by the server, the value based on the third key into the execution of the first logic statements when the third key is called from within the first logic statements.
4. The method of claim 1 , wherein the second logic statement includes a third key, wherein executing the first logic includes:
calling, by the server, a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; and
importing, by the server, the value based on the third key into the execution of the second logic statement when the third key is called from within the second logic statement during the execution of the first logic statements.
5. The method of claim 1 , wherein at least one of the first logic statements includes at least one of a conditional statement, a Boolean statement, or a function.
6. The method of claim 1 , wherein the second logic statement includes at least one of a conditional statement, a Boolean statement, or a function.
7. The method of claim 1 , wherein at least one of the first logic statements includes a logic to call a specific key in a specific tab of a third worksheet.
8. The method of claim 1 , wherein the request contains an alphanumeric string associated with the second document identifier and the second version identifier.
9. The method of claim 1 , wherein at least one of the first worksheet or the second worksheet is stored in a JSON format.
10. The method of claim 1 , wherein at least one of the first document identifier and the first version identifier or the second document identifier and the second version identifier is a single alphanumeric string.
11. A computer system comprising:
one or more processors; and
one or more computer-executable instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
identifying a first document identifier and a first version identifier to a first worksheet, wherein the first worksheet includes a plurality of first keys and a plurality of first logic statements, wherein the first keys one-to-one correspond to the first logic statements;
identifying a second document identifier and a second version identifier to a second worksheet, wherein the second worksheet includes a second key and a second logic statement, wherein the second key one-to-one corresponds to the second logic statement, wherein a first key of the plurality of first keys and the second key semantically correspond to each other;
linking the second worksheet to the first worksheet based on at least one of the second document identifier, the second version identifier, the first document identifier, or the first version identifier;
receiving a request comprising at least the second document identifier and the second version identifier;
executing the first logic statements by calling the second key instead of the first key such that the second logic statement overrides the first logic statement; and
presenting an output based on the execution.
12. The computer system of claim 11 , wherein a first logic statement of the plurality of first logic statements and the second logic statement are semantically different from each other.
13. The computer system of claim 11 , wherein the first logic statements comprises a third key, wherein executing the first logic includes:
calling a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; and
importing the value based on the third key into the execution of the first logic statements when the third key is called from within the first logic statements.
14. The computer system of claim 11 , wherein the second logic statement includes a third key, wherein executing the first logic includes:
calling a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; and
importing the value based on the third key into the execution of the second logic statement when the third key is called from within the second logic statement during the execution of the first logic statements.
15. The computer system of claim 11 , wherein at least one of the first logic statements includes at least one of a conditional statement, a Boolean statement, or a function.
16. The computer system of claim 11 , wherein the second logic statement includes at least one of a conditional statement, a Boolean statement, or a function.
17. The computer system of claim 11 , wherein at least one of the first logic statements includes a logic to call a specific key in a specific tab of a third worksheet.
18. The computer system of claim 11 , wherein the request contains an alphanumeric string associated with the second document identifier and the second version identifier.
19. The computer system of claim 11 , wherein at least one of the first worksheet or the second worksheet is stored in a JSON format.
20. The computer system of claim 11 , wherein at least one of the first document identifier and the first version identifier or the second document identifier and the second version identifier is a single alphanumeric string.