community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

Hi there,

 

My idea comes when I've built an application, where user select filter from drop-down list. However it contains thousands of records, so it takes lot's of time to find desired record.

In Excel and MS Access when you use filter you can put many letter and filter shows rows that match the input. In Alteryx user can only put first letter, which is huge drawback to my users.

 

This is how it works in Excel:

werwe.jpg

 

Hope you like it!

I'm adding a 'Dynamic Input' tool to a macro that will dynmaically build the connection string based on User inputs. We intend to distribute this macro as a 'Connector' to our main database system.

 

However, this tool attempts to connect to the database after 'fake' credentials are supplied in the tool, returning error messages that can't be turned off.

 

In situations like this, I think you'd want the tool to refrain from attempting connections. Can we add a option to turn off the checking of credentials? I assume that others who are building the connection strings at runtime would also appreciate this as well.

 

As a corollary, for runtime connection strings, having to define a 'fake' connection in the Dynamic Input tool seems redundant, given we have already set the 'Change Entire File Path' option. There are some settings in the data connection window that are nice to be able to set at design time (e.g. caching, uncommitted read, etc.), but the main point of that window to provide the connection string is redundant given that we intend to replace it with the correct string at runtime. Could we make the data connection string optional?

 

To combine the above points, perhaps if the connection string is left blank, the tool does not attempt to connect to the connection string at runtime.

Would it be possible to have the text wrap inside the box when we are creating new formulas?

  • Category Apps

Hi Alteryx Devs - 

 

It would be *really tight* to have a drop down interface tool that would support auto completion based on a odbc connection to a table/column or ajax call.  I recently had a situation wherein we need to give the users the ability to select an address, then run a workflow.  But the truth is, our address data is terrible, and what I really needed was to be able to let the users start typing the address, then give them a list of choices to pick from, they pick the correct (but usually wrongly formatted) address, and then I send that value into the workflow. 

 

I could not find a decent way to give a gallery user a reliable way to pick an address from our list, so eventually wound up having to write an ajax piece to handle the auto completion, capture the user input, then post to a service that would in turn, interact with gallery through the API, get the response, and send it back calling page, and back to the user.  A significant amount of work to put into something that is an exceedingly common web operation of auto completion.  

 

This would make a lot of gallery operations flow so much more naturally.  

 

Thanks for listening! 

brian

It can be bothersome trying to find a particular field in a long list of fields in the select tool.  It would be nice to have a search tool to go to the one I want.  Something like what the formula tool uses.

Select with Search.png

 

This should be a simple addition:

 

In the same way that many default tools automatically generate annotations when they are dropped into the workflow, or their configurations are modified, there should be a way to add custom annotations for custom made macros. 

 

Thanks!

I frequently make analytic apps for my clients that requires them to enter information or parameters to the workflow via a prompt before running. The user could be entering codes that will affect a certain filter or it could be a prompt to browse to the new source file required to run the workflow. In order to make adjustments to the workflow itself, I need to work in Debug mode so that I can see the data as it passes through each node in the workflow. Once I am done making all of the changes in debug mode and I am satisfied with how it works, I then have to remember each change I made, and copy and paste each tool and its contents over to the workflow that I am debugging. This is a pain because it is like I am fixing the workflow twice. A good solution to this would be allowing the user to apply changes made in debug to the workflow you are debugging, so that there is no duplication of efforts!

One major improvement in version 11 is that you can now schedule workflows directly in the Gallery. One thing I miss though is the ability to see the whole log from the workflow (messages, warnings and conversion errors).

 

I have made a workaround by using the list runner (Crew Macros), but I think this should be a functionality on the server itself.

 

To see the workaround and the expected output, you can watch this video:

 

https://vimeo.com/214995668

This idea is concerned with suggesting values based on text box entry in an analytic app. This would be an autocomplete within the text box interface based on matches to a list of connected values. For example, if someone was posting "805 Wells Road" it would expand the text box window and supply potential matches to click on.

 

Quick and dirty photoshop image below:

 

autocompleteaddress.png

Hi,

 

Would it be possible to add additional sections to the 'Summarise Tool' such as one for dates so that you might be able to group by Year, Month, Quarter, Week or a combination of all these. There are other extensions that could also be considered such as group with nulls or without that would make this tool far more usable and not dependent on data manipulation prior to it; you might offer to have all nulls grouped and called something else for readability and this shouldn't be very hard at all to implement.

 

Kind regards,

Peter 

Hi!

 

For a improved presentation of the GUI elements (Inteface Tools), may be to use for an Analytic App.

 

It would be great if it were possible to position the Interface Tools also side by side, instead of one above the other.

 

combineCanvasTools.JPG

 

Best regards

Mathias

It would be nice to be able to set a default date for the Date Interface tool.

Props to @KaneG for the workaround ( http://community.alteryx.com/t5/Publishing-Gallery/Set-Default-Date-for-Date-Interface-Tool/m-p/3573... But I'd like to see something built in to the tool rather than use a workaround every time as the standard.  Plus, I enjoy the uniform look of having two date inputs.

Just as a side note while we're on the topic of the Date Interface tool; it is really misleading the way "Today" stays outlined even after you click on a different date.  I always second guess if it took my click or not.

 

It is important to be able to test for heteroscedasticity, so a tool for this test would be much appreciated.

 

In addition, I strongly believe the ability to calculate robust standard errors should be included as an option in existing regression tools, where applicable. This is a standard feature in most statistical analysis software packages.

 

Many thanks!

Hello. While working at my company it has come up a few times that An Interface tool that acts like a standard "grid" would be extremely helpful.  

 

This tool would allow users to update data that has a logical link to each-other like a stanard "row".  Below are a few very simple examples where this would be extremely helpful.

 

 

#1) An application is being used as a file System ETL that has an interface that allows users to select what data to pull from a flat file and store in a database.  The users can pick which 'columns' to keep by choosing the following information.  The column name, type, and final database location of that column. 

 

In this case a user needs to enter 3 key pieces of field information that have to relate to eachother.  

 

#2) There is a table in a database that has thresholds for a specific law at the state level. (for Example: All loans in Florida must have a loan balance < 300k).  However these laws can be updated, and the end users want the ability to #1: See the data, and then #2: Update it if the laws have changed.

 

A grid in this case would be perfect, as they could query the data to see the 50 states and specified limits, and then change the data in the "limits" column in order to update the database.

 

 

The previous 2 examples are pretty simple examples, but I have run into this request a few times from my personal experience, so figured I would see what everyone thought!

 

 

 

Put in some <CR> to break-up the SQL into a readable form.

  • Category Apps

Motivation:

I have an app that a team at my company uses to (sort of) quickly verify transactions. Our legacy VBA application was pretty slick, but in Alteryx it is fairly clunky.

 

Problem:

I can not figure out, after a reasonable amount of searching, how to get the Alteryx app to display data before inputs are added. This seems like such an obvious feature-- I have written many Shiny apps that do exactly this. The current Alteryx app is very inefficient. The user must run one app to select a case to review. That app downloads a pdf with the info on it. The user must then run another app that closes the case with the needed information. This process is very slow and inefficient and the users are starting to  migrate back towards 2 excel spreadsheets.

 

Solution:

We need a way to display a data table or spreadsheet (or whatever) on the app itself. The workflow needs to be: Open app, select case, data pops up,  off-app work, cases are updated and saved into the ledger. If this solution is available, please show me how to do this. If this is not available can the feature request be considered.

 

Thank you,

Bryan

 

  • Category Apps

It would be great if the interface tools would include a back button that will let the user go back and forth the chained apps.

It would be great if we could set the default size of the window presented to the user upon running an Analytic App. Better yet, the option to also have it be dynamically sized (auto-size to the number of input fields required).

We have a large number of apps which are used by a substantial number of end users. One frequent end user complaint is that forms do not persist, i.e. the settings need to be reselected each time the form is run.  We've heard that this is an Alteryx issue.   Are there any solutions or work-arounds? It is a huge ease of use issue.   It has occurred to me that we may need to dramatically simplify the forms (they have many controls) but I would like to have a solution that is correct in terms of complying with modern Web UI standards.  I remember pushing to make forms persistent twenty years ago.

 

I would like to see a time interface tool similar to the Date and Numeric Up Down tools. I am working on some macros where the user can select the time they would like to use a filter for the data. 

 

Example: I want all data loaded after 5:00 PM because its late and needs to be removed.

Example 2: I want to create an app where the user can select what time range they would like to see records for (business hours, during their shift, etc) 

 

Currently this require 2-3 numeric up downs or a Text box with directions for the user on how to format field with Error tools to prevent bad entries. It could even be UTC time.

 

Time Interface Tool.jpgTime Interface Tool 

Top Starred Authors