Dynamic Filter for an app within gallery

[HBarge]

Hi,

I am trying so hard at this however have been quite successful.

I have a request to create an app and publish it within the gallery with the following conditions:

1. On selecting the school (dropdown preferably), the next filter would be populated with the House values associated with that school.

2. On selecting the house, the output would be all the cells as per selected filters.

This app will be posted in the Alteryx Gallery.

Any help would be highly appreciated.

Harshad

[BenMoss]

Hi!

What you need is a 'chained application', here's a resource on how to create one.

https://www.thedataschool.co.uk/giorgia-umani/alteryx-chained-apps/

In essence you create two applications. The first you take your initial data stream and apply the 'school' filter, then create a list of every house value for that particular school and write it to a DB.

In your second application you then populate your dropdown with the DB output from the previously application.

You can then configure the first application to run the second application on completion; this means to your end user, there is just one application, only you know it isn't ;)

You can populate the list of schools by making this a three part  chained app.

I'll build out an example.

Ben

[BenMoss]

Example chained app.

[HBarge]

Hi Ben,

Thank you. I tried it in Designer and works flawlessly. You made my day!
However, there are a few questions I have:

1. How do I save this as a packaged app?
2. When I publish it to the gallery, are there any steps I have to follow or should I just publish App3 and the rest will be automatically published in the gallery?
3. This app will have a similar schema input but from a DB connection which is a much larger database and more houses so, I would desirably have 1st interface: Select School; 2nd Interlace: Select Year Level and 3rd Interface: Select house. Will this same structure work for the 3rd interface or I need more adjustments?
4. I would need to schedule the workflow to run daily so, which WF should I schedule to run? 
I would really really appreciate if you could please post an updated example.
You are the hero for today!

Can't thank you enough.
Harshad

[BenMoss · Accepted solution]

1. To create a packaged workflow/macro/app you go to options > Export Workflow

2. When publishing to the gallery you should actually publish 'App1'. During the publish process make sure you check 'App2' and 'App3' as assets during this process (they should be checked by default).

3. You will need to create a 4 tiered app, rather than 3 tiers if you add this additional layer. I've created an example for you. I also made some amendments to the previous version of the app as it was returning the right house at the end but it was regardless of the school selection.

4. I'm not sure what the purpose of the schedule is? If your hooked up to the DB then your users values will automatically be populated with the latest data when they run the application. Can you clarify what you want here?