Dynamic Dates for Automations

Topic Labels: Automations Base design
398 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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 table

Then we have a third table that contains pricing records for each item with a start and end date for that pricing validity.

I am trying to source the price for the line item by looking at the order date and then pulling the price from the pricing record in effect when that order is set to load.


0 Replies 0