How to provide default values(Epoch Seconds) to prompts in alteryx

[rashmiks]

Hello,

"I want to create a parameter that sets default values for prompts (i.e., the default values should be epoch seconds), and this default value should replace the value in the RunIdentifier field, which is created in the Formula tool. This way, when the workflow is run, the default value (epoch seconds) will be generated and stored in the RunIdentifier field."

[binuacs]

@rashmiks There is an option in the text tool to provide the default value

[rashmiks]

Thanks Binuacs for your Response. In the default text field, I can provide only hardcoded values. What I am looking for is a prompt to which I can set some dynamic default value. Something like date in YYYYMMDDhhmiss. 

[rashmiks]

Hi Team,

Please advise on this issue as soon as possible. It will be a great support for me.  Thanks!

[binuacs]

@rashmiks Have you consider using the date tool ? 

[rashmiks]

Thanks Binuacs for your Response. I have not used the Date Tool.

[OllieClarke]

Hi @rashmiks 

If I understand you, you want the epoch seconds to be stored in the RunIdentifier field whenever the workflow/app is run?

If that's the case, then I wouldn't use a text input to update what's in the RunIdentifier field, but rather use the formula tool to set its value.

If you change the RunIdentifier formula to:

DateTimeFormat(DatetimeStart(), "%Y%m%d%H%M%S")

This will output the time the workflow was run as a string formatted YYYYMMDDhhmmss

Hope that helps,

Ollie

[rashmiks]

Hi OllieClarke, Thanks for your reply.

My intention is to provide a dynamic default value to an prompt(or a question). When I run the app, The prompt should have default value of  current EPHOC seconds or current datetime. Currently in text input, I can provide only static default value and in date input, no option to have a default value.

[rashmiks]

Hi Team,

Please let me know your advice on this issue. Thank you!

[caltang]

Perhaps you can share what your workflow and also an expected output / solution (you can mock it up on Excel) to better assist your ask.