Analytics question - prompting for value

[StephenT]

Hi all

I have a workflow that we manually enter a value of either username or user ID (i.e. GUID) into a filter e.g. Contains([Worker],"Shannon Nel") or Contains([GUID],"SNEL099") and  run the workflow based on the results.

I'd like to see if there was a way that we could prompt the user to select user name or GUID, then enter in the appropriate value e.g. Contains([Worker],"value1") e.g. or Contains([GUID],"value2").

Let me know if i haven't described my query very well - any help or suggestions would be greatly appreciated.

[clmc9601]

Hi @StephenT,

Have you considered using an Analytic App for this? The user could enter (Text Box) or select (Drop Down or List Box) the username and simply run the workflow from there.

[mathieuf]

Hi @StephenT,

As @clmc9601 said Analytic Apps could be helpful here.

Have a look at the Interactive lesson to help you: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...

[StephenT]

Thanks all

@clmc9601 that's what i'm looking to do but the "issue" I have is the data can't be prefilled using a list box or dropdown list, as it will always for for a different user name or ID. Just not sure how to configure a manual input question in Alteryx Analytics App.

@mathieuf Thanks - I'll take a look

[StephenT]

I've had a look at the "Entering Free-Form Text" lesson but can't get the input free text entry to work with the filter.

I have an input file with name and GUID

I have 1 text input (may need to be converted to XLSX ?) containing name and GUID, but when i run the attached workflow

 the data output is the column headings.

If someone could point me in the right direction, as to what I am doing wrong, I'd be appreciative

[clmc9601]

Hi @StephenT,

Thankfully this is a simple fix! Your action tool hasn't been configured. Action tools can be tricky to learn, but they're key to actually creating an analytic app. It's how you implement the user's changes. 

The action tool needs to taking the GUID input and changing some configuration in the underlying workflow.

Here's your original non-configuration. Whatever is highlighted in blue, the action tool will try to replace with the connected interface value. Some things don't accept changes, like the tool name. That's why this is an ineffective configuration.

Here's the configuration I'd recommend (after changing your filter tool)-- note, this will only work when run as an analytic app or in Debug because none of your workers have a GUID of "test"

And I've attached the workflow as well. If this helps, please consider marking it as a solution so others may find it. Thanks! 

[StephenT]

Hi @clmc9601 

Your 'fix' is ideal, and works well. Thank you so much.

On the rare occasion we have to enter more than one GUID so I'm wondering if all I need to do this is change the text box to 'multi-line' ? And do I need any special formatting to differentiate the 2 GUIDS (e.g comma, semi-colon etc.,)

Based on your solution i have already implemented it into our process.

I will mark the solution as accepted, and liked, shortly.