Adding a Parameter that will change text in a formula

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

Capture.PNG

Help

Accepted answers

grazitti_sapna

@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.

{166F6FE9-EE86-414D-A0AC-A476753470B6}.png.jpg

{75512CCE-B888-4F75-AE7C-30A97ACEFC17}.png.jpg

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

I hope it helps.

Thanks.

Adding a Parameter that will change text in a formula-GS.yxwz

All comments

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.

Analytic App.yxwz

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703