Digital processing systems and methods for column automation recommendation engine in collaborative work systems

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.

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.