Adding a Parameter that will change text in a formula

[jonathonallen]

I have a formula that creates a column based on a user-inputted date. I want to make it easier for someone to change the formula. What is the best way to have a parameter pop up when running the workflow that can change this text within the formula? (I've attached a screenshot of the formula)

Thank you in advance for any help

[jdunkerley79]

This can be done as an Analytic App. You can use a Date Interface Tool to let the user end a date.

Have attached a simple example showing a formula taking the input from the Date interface tool.

[jonathonallen]

Thanks for the quick response. When I run this as an analytic app, I am unable to select a date other than today (8/31/2020). Anything else I need to add for the user to be able to select a date?

[danilang]

Hi @jonathonallen 

What exactly do you mean by "I am unable to select a date other than today (8/31/2020)"?  Can you post some screen shots?

Dan 

[jonathonallen]

See attached. I have selected July 31, however the workflow continues with the current date (91/).

[danilang]

Hi @jonathonallen 

I can't quite see it, but it looks like your connected the Q output of the Date tool to the Q input of the Formula tool (in green below)  

You need to disconnect this and connect the Q of the Date Input tool to the lightning bolt of the formula.  This will add an Action Tool between the 2 where you can specify how you want the date substituted into your formula

Dan

[jonathonallen]

Thanks- I think I am getting closer.

See below for the formula. The "[#1]" needs to be replaced with the date. How would you configure this?

[grazitti_sapna]

Hi @jonathonallen , try this, you do not need to add an action tool for updating the value you can directly use #1 in the formula tool as shown below. In such case the value will be directly reflected in the formula tool as you select in the date tool of the date interface tool.

I hope this solves your problem.

Thanks.

[jonathonallen]

I might be missing something, but I am unable to change the date from the current (today's) date when prompted with the calendar. How would you run the workflow you created if the date for the formula needed to be 7/31/2018 for example?

[grazitti_sapna · Accepted solution]

@jonathonallen , you can create a new field in formula and pass #1 as a value the value you will select in the prompt will be displayed in the field as well.

I am able to select the value. 

To run the workflow as analytical app click on the wand icon next to the run icon.

I hope it helps.

Thanks.