Passing Value At Run Time

user11651
user11651
in Dataflows

Hi All,

 

Is there any way that can be used to pass the value to DoMo Dataflow at runtime?

 

Thanks & Regards

usr12321

Best Answers

  • GrantSmith
    GrantSmith Indiana 🔴
    Accepted Answer

    Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set you want to filter / parameterize and then join the two datasets together. You can then do filtering based on the dataset and the parameter / webform dataset value.

     

    You can then update the webform dataset to update the parameter you want to use within the dataflow.

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    https://www.youtube.com/watch?v=wmMrnPO9ivY&t=56s

    @user11651 here's a video that shows the design pattern @GrantSmith  is referring to!

    @GrantSmith wrote:

    Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set you want to filter / parameterize and then join the two datasets together. You can then do filtering based on the dataset and the parameter / webform dataset value.

     

    You can then update the webform dataset to update the parameter you want to use within the dataflow.

     

Categories