Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create a APP to allow user to enter a value to a table questions

khu
8 - Asteroid

Hi,

 

I want to create an App which allow 4 people to enter their Decision : "Approve" Or "Not Approve"

If all 4 people enter "Approve", then a workflow will be run to send out a email.

 

My thinking is to create an input table which only have Name Column and Decision Column, Name Column only have A,B,C,D , four people's names, While Decision Column leaves blank waiting for 4 people to enter.

1. Currently, I'm create an APP, and input file looks like this:

1.jpg

2. Next is to creating first dropdown list to allow 4 people to select their names ,which like following:

2.jpg

3.Then SELECT change Decision Column data type to String and Second dropdown list is created like following:

3.jpgSo this is the whole App and I click  run and select A and Approve:

4.jpgWhich gives me a error:

5.jpg

Any ideas how to solve this?

 

Thanks

 

 

 

 

2 REPLIES 2
jrgo
14 - Magnetar

Hi @khu,

 

Curious to see how your going to make this workflow work in general, but to to answer your question as to why you're getting an error...

 

I suspect that the Action tool that updates the Formula is the problem. The issue is how you have it configured to update the target Attribute. If what I suspect is correct, you have it set to update the entire expression with whatever the user select. This also replaces the QUOTES which captures your string value. At the bottom, there's an option to only replace a specific string. check that option that then remove the quotes so that it only replaces Approve instead of "Approve".

image.png 

 

Hope this helps!

 

Jimmy

khu
8 - Asteroid

Yeah, I included the quote , thx

Labels