topic Re: How to provide default values(Epoch Seconds) to prompts in alteryx in Alteryx Designer Desktop Discussions

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

rashmiks — Mon, 13 Jan 2025 14:18:39 GMT

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

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

binu_acs — Mon, 13 Jan 2025 15:18:57 GMT

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

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

rashmiks — Mon, 13 Jan 2025 17:10:58 GMT

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.

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

rashmiks — Wed, 15 Jan 2025 11:37:02 GMT

Hi Team,

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

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

binu_acs — Wed, 15 Jan 2025 11:53:31 GMT

@rashmiks Have you consider using the date tool ?

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

rashmiks — Wed, 15 Jan 2025 12:27:57 GMT

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

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

OllieClarke — Wed, 15 Jan 2025 17:48:56 GMT

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

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

rashmiks — Thu, 16 Jan 2025 13:07:19 GMT

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.

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

rashmiks — Fri, 17 Jan 2025 12:48:06 GMT

Hi Team,

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

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

caltang — Fri, 17 Jan 2025 12:52:57 GMT

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.

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

binu_acs — Fri, 17 Jan 2025 17:29:10 GMT

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

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

rashmiks — Fri, 24 Jan 2025 16:17:39 GMT

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

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

binu_acs — Fri, 24 Jan 2025 16:41:15 GMT

@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