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

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

Capture.PNG

Workflow

Accepted answers

All comments

binu_acs

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

binu_acs

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

binu_acs

@rashmiks By default the Date tool shows the current date, you can use that for your application

rashmiks

@binu_acs
I want the current time to be dynamically populated as the default value in the Text Box when the user runs the app, without it being hardcoded in the Formula Tool.

binu_acs

@rashmiks you can create something like the attached workflow, which takes the date from the user and adds the current time dynamically with the date

DateTime_24012025.yxwz

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703