Query

[Arpita23]

Hi everyone,

I want my workflow should through a warning if a user input numeric value in name and string value in phone number and a submit $ cancel button at the end. which tools I should use and How should I do this? For example

First name             123(warning)

Phone no               abc(warning)

           submit     cancel

[pedrodrfaria]

Hi @Arpita23 

Are you doing an Analytic App or a regular workflow?

In an App you can set up a conditional and error message in case the field meets this requirement. Regular workflow you can do in the formula tool.

Some formulas you can use:

if REGEX_Match([Name], "\d*") = -1 then 'FLAG' ELSE '' ENDIF  For the Name field

if REGEX_Match(Phone, "\D*") = -1 then 'FLAG' ELSE '' ENDIF   For the Number field

Pedro.

[Arpita23]

Thankyou Pedro but I want to do this through analytic app.

[pedrodrfaria · Accepted solution]

HI @Arpita23 ,

Please find attached an example to accomplish this task. Also attached is a input file example I used to create this App.

Please mark this discussion post as concluded by assigning the correct answer if your questions were answered. Feel free to reach out if you have any questions. We recommend that you open a new discussion post if you have a different question.

Pedro.

[Arpita23]

Thankyou so much Pedro!!

[Arpita23]

Hii Pedro, If I want to do this example using macros how can we do that?

Like if a user enters a name in number column or number in name column.