Digital processing systems and methods for column automation recommendation engine in collaborative work systems
Systems, methods, and computer-readable media for associating a plurality of logical rules with groupings of data are disclosed. The systems and methods may involve at least one processor configured to: maintain a table containing columns; access a data structure containing the plurality of logical rules; access a correlation index identifying a plurality of column types and a subset of the plurality of logical rules; receive a selection of a new column to be added to the table; perform a look up in the correlation index for logical rules typically associated with a type of the new column; present a pick list of the logical rules typically associated with the type of the new column; receive a selection from the pick list; link to the new column a second particular logical rule associated with the selection from the pick list; and implement the second particular logical rule.
1. A system for associating a plurality of logical rules with groupings of data, the system comprising:
at least one hardware processor configured to:
maintain a table containing columns;
access a data structure containing the plurality of logical rules including a first logical rule that when linked to a first column, enables a table action in response to a condition change in a cell associated with the first logical rule linked to the first column;
access a correlation index identifying a plurality of column types and a subset of the plurality of logical rules associated with each column type;
receive a selection of a new column to be added to the table;
in response to the received selection, perform a look up in the correlation index for logical rules associated with a type of the new column;
present a pick list of the logical rules associated with the type of the new column;
receive a selection from the pick list;
link to the new column a second logical rule associated with the selection from the pick list; and
implement the second logical rule when data in the new column meets a condition of the second logical rule.
2. The system of claim 1 , wherein each of the plurality of logical rules includes a logical sentence structure.
3. The system of claim 1 , wherein when the second logical rule is linked to the new column, the at least one hardware processor is configured to apply the second logical rule to at least one cell in the new column.
4. The system of claim 1 , wherein the table action includes a change in data in the maintained table or in another table.
5. The system of claim 1 , wherein the condition change in a cell includes a change of data in the cell.
6. The system of claim 1 , wherein the correlation index is stored in the data structure.
7. The system of claim 1 , wherein the type of the new column is defined by a heading of the new column.
8. The system of claim 1 , wherein the at least one hardware processor is further configured to generate the correlation index by inspecting preexisting linkages between preexisting columns and at least some of the plurality of logical rules.
9. The system of claim 1 , wherein the at least one hardware processor is configured to customize the correlation index to the maintained table based at least in part on other column types in the maintained table.
10. The system of claim 1 , wherein the correlation index is based on correlations previously employed by an entity associated with the new column.
11. The system of claim 1 , wherein the correlation index is based on correlations previously employed by entities subscribed to the maintained table.
12. The system of claim 1 , wherein the correlation index includes rules customized to identify individuals subscribed to the maintained table.
13. The system of claim 1 , wherein the at least one hardware processor is further configured to permit alteration to the correlation index to remove suggestions.
14. A non-transitory computer readable medium containing instructions that when executed by at least one hardware processor, cause the at least one hardware processor to perform operations for associating a plurality of logical rules with groupings of data, the operations comprising:
maintaining a table containing columns;
accessing a data structure containing the plurality of logical rules including a first logical rule that when linked to a first column, enables a table action in response to a condition change in a cell associated with the first logical rule linked to the first column;
accessing a correlation index identifying a plurality of column types and a subset of the plurality of logical rules associated with each column type;
receiving a selection of a new column to be added to the table;
in response to the received selection, performing a look up in the correlation index for logical rules associated with a type of the new column;
presenting a pick list of the logical rules associated with the type of the new column;
receiving a selection from the pick list;
linking to the new column a second logical rule associated with the selection from the pick list; and
implementing the second logical rule when data in the new column meets a condition of the second logical rule.
15. The non-transitory computer readable medium of claim 14 , wherein when the second logical rule is linked to the new column, the operations further include applying the second logical rule to at least one cell in the new column.
16. The non-transitory computer readable medium of claim 14 , wherein the type of the new column is defined by a heading of the new column.
17. The non-transitory computer readable medium of claim 14 , wherein the operations further comprise generating the correlation index by inspecting preexisting linkages between columns and logical rules.
18. The non-transitory computer readable medium of claim 14 , wherein the correlation index is based on correlations previously employed by an entity associated with the new column.
19. A computer-implemented method for associating a plurality of logical rules with groupings of data, the method comprising:
maintaining a table containing columns;
accessing a data structure containing the plurality of logical rules including a first logical rule that when linked to a first column, enables a table action in response to a condition change in a cell associated with the first logical rule linked to the first column;
accessing a correlation index identifying a plurality of column types and a plurality of logical rules associated with each column type;
receiving a selection of a new column to be added to the table;
in response to the received selection, performing a look up in the correlation index for logical rules associated with a type of the new column;
presenting a pick list of the logical rules associated with the type of the new column;
receiving a selection from the pick list;
linking to the new column a second logical rule associated with the selection from the pick list; and
implementing the second logical rule when data in the new column meets a condition of the second logical rule.
20. The hardware computer-implemented method of claim 19 , wherein the correlation index is based on correlations previously employed by an entity associated with the new column.