Is there a way to use dates to find records dynamically in an automation.I have a line items table for my orders. That table links to an Item in another tableThen we have a third table that contains pricing records for each item with a start and end ...
I am trying to create an automation that updates all records in a table at a specific interval. The automation needs to look a single select field and based on what it is set to update another single select field.The automation works when the trigger...
The roll up field is using
ARRAYJOIN(values)
and the field that is suppose to make it human readable is using
SUBSTITUTE({Items Purchased},",","\n")
If I make it ArrayUnique then I get an error in the Substitute field
I am trying to do something similar, but I want the array to only pull in unique items. When I use this formula on a Unique Array rollup field I get an error. Is there anyway to no show duplicated in the substitution field?
