Challenge #115: Let's get crafty!

[CynWodka]

I changed the dropdown to a checkbox so users can select multiple styles. Here is my result:

[martinson]

Very useful practice with apps

[3I_ATLAS]

Patrick, @patrick_digan 

this is exactly what I was wondering if existed!

IIF("%Question.QueryStyle%"="True",[style]="%Question.Style%",[state]="%Question.State%")

THANK YOU!!

Does Alteryx have any documentation around this anywhere?  I.E. how to reference elements of tools with the % sign like in the above??

Do you have any links you could share?

Thanks again!!!

[3I_ATLAS]

HA!  Just found your great article!!

What Are Reference Shortcuts? (And Why You Should ... - Alteryx Community

Thanks again!  Just puzzling why this is so obscure and why Alteryx doesn't do a better job documenting this feature.

Cheers!

[3I_ATLAS]

I'm pretty sure the posted solution is not working for one of the searches.  But many possible ones posted by folks.  I particularly liked the one from @patrick_digan due to its simplicity and where I learnt about the very useful yet obscure 'Reference shortcuts' - What Are Reference Shortcuts? (And Why You Should ... - Alteryx Community

( to avoid using cross tab to transform Field values into field names so they can be used as values in a combo box (What sense does this make anyway?!), I generated a value, name pair and output it to a yxdb file first, which is then used to populate the drop down box.  Again, why does this tool takes different data feeds depending on its  method of populating?!?! i.e value name pairs for a 'external source'; just names (field names) from connected tool?!?!  It would be nice if we could choose regardless of the source, if we want to feed it a value name pair, or a simple name list, and what field would be provided as output from the users selection (name or value if both were loaded).. points already raised by @patrick_digan as well I believe.

Spoiler

[BransonJamesFarley]

More difficult than I anticipated. Great learning and practice with apps!

Spoiler

 

[RebekaMazuchova]

:)

[Miffy_Allen]

Spoiler

[JBevan89]

I got there in the end, as it seems to take me a lot of time to work out the interface designer, as it does not accept certain ways

[Alesson_Oliveira]

My Solution:

Spoiler