Dynamic app or macro to allow user to input variables for each row

Question

Hi Everyone,

I want to create an app or a macro to allow the user to assign variable to certain rows.

So the input is a list of amounts however - this is not fixed list and can change.

The user need to be able to decide:

- which row has a split

- what is the qtr+year for each row

- what are the rows are not included at all.

I have added a video that would explain the problem better

https://youtu.be/_es3uabvwjg

Test workflow.yxmd

Input.xlsx

gabrielvilella · Answer

So, I started developing here and I ran into an issue that the interface to present the user which values the user selected to insert the splits is not great, the only way would be a list box. I don't believe that is a good solution. Unfortunately, I will have to say that it is not possible to accomplish what you want using the regular interface tools. A solution for this would be having the user fill out a Excel sheet before with all the required information.

anayet1988 · Answer

@gabrielvilella

The issue I have right now with apps is that it the split and the Year+Qtr can only be defined once.

I want a way that will prompt the user to go through the rows ask do you want this row split, if yes how would you like it split and what's the Year+Qtr. Once the user has defined for one row, go onto the next row. etc

If you have time - I would greatly appreciate it if you can create a small example based on the data i've provided.

Thank you

gabrielvilella · Answer

Yeah, it is possible, but I must add that that won't be pretty. The regular interface tools won't give us much flexibility on how to display those values. There is a more complex way but using the SDK and HTML, but I don't think you want that. To understand more about chained apps you can check this. I might be able to build an example for you if I have some extra time.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

https://www.youtube.com/watch?v=h4NhAwUPpW0