Creating Custom Analytic App Interfaces

[rishabh_1995]

Hey Alteryx Community,

I am trying to create an interface which allows the user to update values in within a table. The users could be anyone within my immediate team. The below is what my table roughly looks like

	Column Description	Column Description	Column Description
Row Description	[Number]	[Number]	[Number]
Row Description	[Number]	[Number]	[Number]
Row Description	[Number]	[Number]	[Number]

I need the user to update every single cell which contains 'number'. Because the table is already in a format which the user understands, I was hoping to create some sort of an interface, which shows them the exact same table layout, with the ability to change the concerned cells.

Based on what I've seen so far, it doesn't seem like there's a native capability in Alteryx to do something like this (even with the interface tools). However, just wanted to check to see if someone is aware of a workaround to something like this.

[Blake]

Hi @rishabh_1995 have you considered breaking the info that you're asking for into separate tabs in the interface designer to make it more digestible for your users? 

Something like the screenshots below? You could also provide them a link to the schematic like the 2nd screenshot and include a link to it on each tab. 

I don't really love that idea though. Why not just give them a template to complete with their 9 (or however many) values and use that as an input instead of having them put multiple values in to the app interface? Those values would be super easy to peel out and apply properly. 

[rishabh_1995]

Hi @Blake yeah I did look into breaking it up into different tabs. But like you mentioned, from an end user's perspective it might not look as good.

To your point, I did consider the option of also having them dynamically input a template with the numbers in there. However, the only reason I'm a bit hesitant with this is because there may be certain occasions where the user doesn't have to provide any numbers (so they would just basically have to submit a blank template). In those situations, I would have preferred to give the user flexibility to not have to upload the file at all. 

I guess I do have to provide a bit of a background here as well: I was planning to package this inside an Alteryx Macro which would have some other interface questions embedded into it as well. I have analyzed the situation and have found that packaging it as a Macro is the most ideal method to solve the issue I'm facing. In addition, due to some reasons, the end user should not have access to the underlying workflow, so I will be encrypting the Macro before sharing it. So my challenge is if I use a file browse tool within the Macro, I kind of have to force the user to input a file, even if they have no numbers to report.

Do you know if there is a way by which a user can be excused from inputting the template file, without the Macro throwing an error. I do understand the discussion has probably now moved to something a bit different and I'm happy to raise this across in a different channel.

[Blake · Accepted solution]

Hey @rishabh_1995,

You can definitely have default values that will be used if the user elects to not use a template. I have attached an example that shows generally how the mechanics could work. It shouldn't make a difference if you are passing this information to a macro or straight in to a workflow. You'll have to do some renaming within the Join Multiple but I think you can accomplish what you're looking to do with this as a scaffolding to start with. 

Let me know if this is helpful and feel free to send me a DM if you have further questions. 

[rishabh_1995]

Hi @Blake I didn't think of the Radio button option at all. I just built the workflow using the same logic you've shown and that works perfectly. Thanks for sharing this across. I'll definitely remember the Radio button now 🙂

[Gowrikrishnan]

Hi Blake, how can we create multiple tabs in user interface? Which all tools are used?