While almost all interface tools allow for default values, the listbox / manually set values does not. The idea would be for a property on each line that when displayed to the user would have one or any values checked upon entry. The configuration might look like Name:Value:Default. I.e.
I would use this to pre-populate the listbox with entries from a database that would essentially allow the user to edit his previous entry. In this example, the user previously selected Alabama and the results were stored in a database. When editing the record using an analytics app, I would want the user to see what he chose and the other options available.
I've just downloaded the latest version, 2020.2.3, which I do like overall. However, I was horrified to see an issue that keeps coming back, I'm hoping this time it doesn't take as long to fix. I'm referring to the Select tool no longer showing the whole (or at least the majority) of the field name...again (this is at least the 3rd time this has come back). It appears you only show the first 6-9 characters making it so I have to hover my mouse over each column to get the full name or drag the field pane out every time I click on a select tool/join tool/spatial match tool/find nearest tool/etc etc.
I suggested in the past each time this has happened before, that you just drop the description field, which you give the most room to by far. I've been using Alteryx since you were SRC (too depressing to count how many years that's been...so old) and I have not once put anything in the description area, does anyone really ever use this area on a consistent basis? Or if you can't drop it, maybe not allocate all the room to it & make it one of the smaller panes, which would allow for the actual field names to have more display room, which then allows your user base to more easily tell what is in the data they just loaded.
This is definitely a step backwards in my mind in design/time efficiency, holding out hope this was an oversight & will be fixed next release (fingers crossed, rabbit foot rubbed, lucky shirt on, donated to charity, & knocked on wood)! Please please please.
I just installed 2020.2 & I LOVE this update within the Formula tool:
Are there any plans to bring this ability to the Filter tool as well, where I can double click on my column name & have it grab the brackets as well?
Not going to lie, love that you added the Open/Save/Undo buttons back to the top toolbar too! Latest version looks great, thank you!
When writing a good amount of code, it is easy to get lost in a sea of parentheses. Just when you think you're all done, you get an error that can force you to scour through your code to find the missing, extra, or misplaced parenthesis.
A common feature today is to highlight a parenthesis when its partner is clicked on. This instantly lets you know if you have the wrong number of them and where.
I didn't think this was that important early on in Alteryx, at least for me. Formulas were meant to be short and easily readable at a glance. Now as I dig deeper, there's R, Python, SQL and other text-heavy inputs.
I don't need a full-fledged text editor in Alteryx, but I would love some quality of life features like parentheses matching.
I think I'm liking the new UI, but I think it's necessary to bring back save, undo and re-do buttons....
1. Frequent saving of workflows is crucial and not everyone uses keyboard shortcuts
2. The ability to undo (lots) of changes is a key part of iterating and rapidly building workflows in Alteryx and again not everyone uses keyboard shortcuts to do this.
Looks like there's potentially space to add this to the right of 'help' (I suspect this might be technically quiet difficult) or to the left of 'run', 'schedule' and 'active documents' as seen in the image below.
Out of interest, where has the 'documents' terminology come from?
I do a lot of work with SQL code in the PRE/POST SQL options and when I get an error, it usually returns the entire code and a little bit about what is wrong. These long strings are hard to read in the current tooltip format as if you hover over to see the entire error, the tooltip goes away after 5 seconds. So I am frantically reading through lines of error code 5 seconds at time. Can we make it so the tooltip just hangs out until I move my cursor off of it?
The beauty of workflow constants is that a user can change a value in one place and it will be effective everywhere in the workflow where the constant is used. I want to be able to update the workflow constant value itself using an App interface. If I use interface tools to update the constant value wherever it appears, the constant loses its value and beauty. This becomes a maintenance nightmare and an interface tool clutter. Can I have a new tool or a current tool in the interface palette which allows me to change workflow constants in the interface? Thank you.
When training people on the use of action tools, something that I always have to hit on is that when you are telling the tool which piece of the XML that you are adjusting, it's sort of difficult to tell what you have selected, and super easy to accidentally select something else.
When you initially select the action to take it's this nice Blue Color. However, it still doesn't feel exactly like you have actually selected anything or told the Action Tool what to do, since it's so easy to just select any other one of these actions.
A slightly different problem is that if you are selecting an action that has been previously configured, it is just this light grey color. So it can be easy to accidentally change your settings because you may not realize it's actually set up.
Here is a recent community post that sort of outlines a few of these problems.
I've recently been delving into using the interface tools and there are a couple of glaring issues for me as a developer/designer, all having to do with the UI, ironically (yes, I used that correctly!) with the interface tools. The irony here is that the interface tools utilise a poor user interface.
Firstly, I finished this video to ensure I was indeed doing things correctly, and I was.
The UI for designer's interface tools is incredibly sluggish. In order to rearrange tools, each time you create a new one, you have to push the up arrow for each tool and you have to traverse the groupings.
Instead of this, I suggest two changes to the interface designer.
I know not everyone is building macros/apps and dealing with this, so I have little faith that this will jump to the top of your queue. But this is a painful part of the UI. I don't know if your UX designers could easily fix this or if it is more pain on your end than the pain you're giving me, but I just want to say: This hurts. 35 clicks every time I add a new element with no option to 'move to top' like you (wonderfully) do in the select tool is a big drag on my time (hint: maybe add that sort of functionality too; the select tool manages this stuff so well!). Which is supposedly valuable. In theory. But it certainly doesn't feel that way when I've spent 10 minutes clicking an up arrow (and yes, my UI is slow. And I may be exaggerating, but not by much!).
Thank you for your continued improvement!
Add an option to the tree tool generate custom lists similar to the list box. When building apps for teams to use and we need them to select from either a product or store hierarchy it would greatly simplify the process if the tree tool could generate a custom list of the lowest level of the hierarchy that we could feed into a sql pull in the dynamic input tool. On top making the workflow cleaner, I think it would make the user interface a lot cleaner, instead of a giant lists of stores/departments etc. they could drill down to the relevant area much faster.
Default on Folder Picker Interface tool
The folder picker tool does not currently allow a default value - this unnecessarily adds work if users have the same value 90% of the time.
Please add a field for the default value that will show when the interface starts up
- Default on Date interface: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Default-Date-for-Interface-Tool/idi-p/35770
- Default on File Selector: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Default-file-location-in-file-broswer-Interf...
This request is super simple! I love how Alteryx displays the row count and size of the data passing through each tool at run time. Can you set the default formatting for the row count indicators to be #,###? Without the commas, it's hard to easily check the row count once you get more than 6-9 digits.
In the example below, it would be so much more readable if it displayed as 75,640,320.
The drop down\list box have numerous ways to list values. One of them that I like is connecting to an external source. You simply have an external source file with a Name column and a Value column. It will display the data in the Name column and pass the data in the Value column. Now suppose instead of connecting to an external source I wanted to use connected tools. Currently, I would have to crosstab this data and the drop down\list box would display and pass the column names.
What if the drop down\list box could have an additional option added where you could connect tools and it would act identically as an external source (display the data in the Name column and pass the data in the Value column). This would be much easier and more functional!
In GIS, spatial data is regularly stored/transmitted as text. With this comes metadata, including the projection used.
Example Issue: When extracting data from ESRI's ArcGIS REST Directories, the projection can be extracted from the information, but must be manually defined in the Make Points Tool. If you are trying to compile data from several different sources, all using different projections, you cannot automate the process.
Suggested Solution: Add WKT to macro interface configuration options so that an Action Interface Tool can update the Create Points Tool.
JSON extract.png - This is a screenshot of the spatial reference metadata in a JSON formatted query from an ArcGIS REST Directory.
action tool.png - Current configuration options for Create Points Tool in the Action Interface Tool.
It would be nice if we can arrange some tools on the canvas neatly by one click and having them distributed evenly (horizontally/vertically).
See this picture which worth thousand words.
It is just a bit of annoyance, really. I'd like to see the option of inputting a hexcode of color and/or a screen color picker in the color dialog. At the moment, you have to change R, G, B separately or play around with the cursor to find the right color.
The color dialog is relevant for the documentation purposes but also reporting tools and I'm sure it would make life easier to some people, especially when branding colours are important.
Can you add the search functionality in the dropdown (Apps) where the user enters specific text and the dropdown list gets filtered accordingly?
It would enhance the user's experience while using large lists in dropdown.
I'd like to hold CTRL, click on a tool and drag it to somewhere else on the canvas to copy it.
This is functionality common in other software (e.g. Tableau, MS Office).
Currently I have to either:
right click > Copy, right click > Paste, or
Ctrl + C, Ctrl + V.
I would like to be able to modify my connection string in the Alias Manager.
Connection string is greyed out :
If I want to change my connection string, I have to create a new alias.