topic Re: How to Validate User Input with a Condition Block? in Qlik Automate

How to Validate User Input with a Condition Block?

_amiiine_ — Wed, 29 Jan 2025 17:12:17 GMT

Good evening, everyone!

I'm using Qlik App Automation, and I want to add a condition to check whether the user's input follows the format YYYY-MM-DD HH:MM.

For this, I'm using the regex ^\d{4}-\d{2}-\d{2} \d{2}:\d{2}$.

How should I configure the condition block to properly validate this format?

Any help would be greatly appreciated!

Re: How to Validate User Input with a Condition Block?

Bhushan_Mahajan — Thu, 30 Jan 2025 05:53:44 GMT

@_amiiine_ Try below expression.

If(Match(Text(YourDateField), '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}$'),

then execute your script

else end.

Re: How to Validate User Input with a Condition Block?

JandreKillianRIC — Thu, 30 Jan 2025 06:17:28 GMT

Hi @_amiiine_

Where are the users entering this input? Is this a variable in the front end of Qlik?

If this is a variable, I would just use a normal text object to test this and save the automation.

Regards Jandre

Re: How to Validate User Input with a Condition Block?

diegozecchini — Thu, 30 Jan 2025 08:42:06 GMT

Hi
try to set the condition type to "Expression Evaluation" and use the expression: Match(Text(YourInputField), '^\d{4}-\d{2}-\d{2} \d{2}:\d{2}$')

Re: How to Validate User Input with a Condition Block?

_amiiine_ — Mon, 10 Feb 2025 09:06:12 GMT

Hi Jandre,

The users enter the data in an Input Block within the automation.

Let me know if you need more details!

Best regards,
Amine

Re: How to Validate User Input with a Condition Block?

diegozecchini — Mon, 10 Feb 2025 13:30:38 GMT

Hi!
To validate user input in Qlik App Automation using a Condition Block, you can add a Condition Block in your automation and set condition type to "Expression Evaluation" in the condition settings.

Use the following expression to match the required format:

Match(Text(YourInputField), '^\d{4}-\d{2}-\d{2} \d{2}:\d{2}$')
YourInputField should be replaced with the actual field where users enter data.

finally in output paths

If the condition matches, proceed with the next step in the automation.
If it doesn’t match, handle errors (e.g., sending an alert or stopping execution).