Analytics app - Textbox and error message tool

[yuqingh318]

Hi all,

I would like to have a error message displaying, when the person running the app enters a word in the Textbox which isn't found in a specific column of the main dataset. Is there a way to do this?

e.g.

Column A	Column B	Column C
Apple
Pear
Peach

In the textbox the person enters 'Appl' instead of 'Apple' due to a typo. I'd like an error message stating 'Appl is not found in Column A'.

Thank you

[IraWatt]

Hey @yuqingh318,

There is the test tool:

It will error if certain criteria you define are not met. 

[DataNath]

I know it's sidestepping the point, but is a dropdown not suitable for your app? Using fields from a connected tool, you can ensure that the only options available to select are those which appear in the column you isolate.

[yuqingh318]

Hi Nath, thanks for the reply. The above is just an example, as I have over 1500 items and a drop down would be huge in that case. 

[gabrielvilella]

Hi @yuqingh318, the best way to achieve this is to have a chained application. The first app will have the text box, the user will insert the value and hit next. The app will then check that value against the dataset and will error out if the value was not found. If it was, then save the value the user inserted and load that on the next app.