Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Multi-Row & Multi-Field Formula Enhancements

When using the formula tool -- one of the nice features is that when you start typing in a function or variable -- the tool will show formulas/variables that begin with that letter and keep changing as you type in more letters. I believe this is called predictive typing.

Good.jpg

 

However, this does not happen in tools like multi-row or multi-field where a user would have to search for functions and variables if they weren't sure what they are.

 

Not good.jpg

 

Can predictive typing be added to the multi-row and multi-field tools? If I want to take it further, any tool that allows a user to use the formula functionality should be able to see predictive typing. 

 

Thanks,

Seth Moskowitz

 

 

8 Comments
RachelW
Alteryx Alumni (Retired)
Status changed to: Accepted

I am so glad that you like the autocomplete suggestions or predictive typing as much as I do! I have adding the new expression editor to Multi Row Formula and Multi Field Formula on our roadmap for the next year. Do you use any other tools with expression editors that you'd also like to see converted? 

 

Also, how do you use the autocomplete suggestions? Are you using them to remember functions or column names? Or to type expressions faster? I've gotten lots of great feedback about the feature, but people seem to like it for different reasons. I'd love to hear your feedback. 

smoskowitz
12 - Quasar

@RachelW--

 

Thank you for reaching out and I am so happy that this is on the roadmap! I guess no credit for the idea...:(

 

I like the autocomplete because it simply a more efficient way to write formulas. Another place I use this is in the Action tool. See below and would like the autocomplete to be here as well. 

 

Action.jpg

I probably don't know all the place where formulas are but would like it to work consistently any place I can work with formulas. It works nice in the formula and filter tool, but the tools I mentioned work differently.

 

Let me know if you wish to discuss.

 

Thanks,

Seth

RachelW
Alteryx Alumni (Retired)

Thanks for the additional feedback. We will eventually be replacing the expression editor in all tools, but we will be doing it one tool at a time. I'm super excited to ship the tools as we convert them. 

 

 

Credit? I'll give you extra credit! =) Thanks so much for submitting an idea to Community. 

 

Image result for credit gif

smoskowitz
12 - Quasar

Haha! Thanks for the chuckle Rachel! Have a wonderful rest of your day! :)

 

Seth

grossal
15 - Aurora
15 - Aurora

I really like the auto-suggest/complete feature in the Formula-Tool, it feels like coding in an programming enviroment, but it's sadly not everywhere.

 

I would love to see the auto-suggest/complete feature in every Tool that has the option to enter formulas.

 

E.g. 

- multi-row formula

- multi-field formula

- generate rows

 

 

Comparison: 

 

1) Formula Tool

grossal_0-1579772740713.png

 

2) Multi-Field Formula

grossal_1-1579772824017.png

MPohlers
8 - Asteroid

Dear Alteryx Team,

 

what is the status on this? I teach Alteryx trainings and I get asked in every training why the now more than 3 years old formula editor is not available throughout the product. It was written in 2018 that it were on the roadmap for the next year.

 

JanetteJohnston
7 - Meteor

It is a great idea and it will be consistent with the formula tool 🙂

KylieF
Alteryx Community Team
Alteryx Community Team

Hello!

 

We apologize for the delay on this feature. We have been looking into do this, and enhancing these tools with a better expression editor experience is still planned. However, it is taking longer than expected due to shifts in priority and necessary research. But, these tools will have a consistent experience with the Formula tool.