-
Pattern: Contains Operator for Data Table Filter
Oftentimes you need to check to see if a text-type column contains a substring of text anywhere in the cell. To do this, you need to write a formula using the Tables: Apply formulas to columns action…1 -
Pattern: Reference a Variable Within a Variable ({{lookup this field}})
Occasionally you may have a need to reference a field within a field (variable within a variable). The following syntax allows you to do so: {{lookup this your-field-reference}} What we're saying abo…1 -
Pattern: Dynamic Task Assignment
You can use the attached workflow model to dynamically assign tasks to a user, leveraging your team's Application Table: Users table. For the below steps, you should select to Use Table by name, and …1 -
Pattern: Split Dataset by Variable Maximum Number of Rows
This workflow allows one to upload a .xlsx or .csv file, and split rows into separate datasets (tables) by a variable maximum value (default 100) to be manipulated, reordered, validated, etc in an in…1 -
Re: Tables: Apply Filters - Dynamic Columns
@Dylan_478989 I'm not sure what was different, but I hard-coded this as you suggested (it worked), then shifted it back. It now seems to work, provided the formula is used to concatenate the Advanced…1