This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would definitely put at the top of the list those tools that are natural brethren to the formula tool, such as the multi-row and multi-field formula tools. This is currently quite a jarring shift when stepping from the new to the old, so this is where I would definitely start.
This functionality would also be a natural fit for the dynamic tools, specifically rename and select.
Currently, the older (mature? Experienced? Aged like a fine wine?) users will be comfortable with the old expression editor, but it may be confusing for new users.
I'm blown away by all of your feedback! I'm so glad that so many of you have interest and thoughts on the new expression editor. I'm actively trying to figure out how we can get the new expression editor into more tools. Thanks again for your feedback.
@DultonM and @JohnJPS I'd love to take a look at some of the crazy expressions you are building for the Action tool.
Hi Rachel, in the final analysis they don't look too bad, but I know as I'm doing "Replace with Formula", or especially "Replace Raw XML with Formula" it gets a little tedious with a lot of nested Replacements.
That might work, but depends on how the recommendations pop up in the suggestions and the variable tab. For example, I have created Multi-Row lookups up to 7 days back. That means each field would multiply by 7. And if I have fields of Test Date, Test Type, Test Interpretation, ant Test Result, typing "test" would pop up 4 fields * (7 negative & 7 positive) = 56 suggestions populating the variable list and the suggestion list to choose from. Typing "interpretation" wouldn't be any better because I have several fields with interpretation in them.
Then there would be the ordering. Would suggestions order by field, by Row-offset, or how?
Maybe I just have an outside case, but this was the situation I was referring to.
Having the Variable tab as you show withing the variables X button would solve the problem there. It would just require the user to ignore the overwhelming number of suggestions in the example above.
:-) great question - and it's a fantastic idea to use the community to help figure out where people's priorities would lie @LeahK
I agree with most of the other folk, and @TaraM 's alteryx periodic table bears this out too.
The most commonly used tools, that would benefit from up uplift (in order of usage) are:
In addition, there would be two additional requests I'd throw in:
- There's very little that will cause emotional harm as quickly as a super-long formula written by an enthusiastic amateur with no decent indenting to figure out what it's trying to do. Any chance you could offer the ability in your new editor to pretty print a formula (example below)
- the editor still punches out to the help text related to the formula tool, instead of going straight through to the help for the function I'm working on. If we could make this contextual it will save a google search every time we use a date time function (time spent looking up those % character codes).
Thanks for the opportunity to contribute to this discussion!
Great point on indentation @SeanAdams. I would even add one more small step and keep all the If/Then/Else/EndIf syntax segregated from the rest:
If (X) Then
Else If (A) Then
B Else C
i.e. the "results" (either Y or B or C) are all on their own line; for me this is easiest to read; I'm also in the habit of surrounding my conditions in parentheses, although that serves no purpose other than said habit. :-)