Inspire 2014 — Alteryx Tips & Tricks

all right good morning everyone welcome we are here for Alteryx tips and tricks my name is Amy pence I’m the sales enablement marketing manager for Alteryx and we have a trio of presenters today margarita wilshire who is our client services representative team lead at Alteryx and we have jeff jones manager of user experience and Chad Martin who is also on our client services representative team so you were in great hands and without further ado I will turn it over to our folks here yeah good morning everyone how many of you have attended at tips in two expressions yesterday so today’s session is going to be really different from the ones that we did yesterday but we are very excited because in this one Jeff John Jones he’s our product manager so he was very closely involved on the analytic enhancements that we did for nine that of his joined us he’s going to chair you know what the new enhancements are and we want this session to be like the ones we had yesterday more informal you know is it’s kind of just we are in client services so we hear from you directly so we think that we’ve seen at all absolutely so we just kind of sharing what we think are they you know let you be in our and you know tips and tricks the things that we use and we have seen our users using so we wanted to be more conversational so if you have any questions or you you have some tips and tricks of your own please you know feel free to share so I’m gonna let Jeff Jones to share the since explore I’m gonna be at a plane thanks margarita so I started at all tricks about two and a half years ago and was brought in to oversee a real focus on user experience and the team I worked with was responsible for the visual refresh back at 85 we got the new icons and the horizontal workflow and the horizontal tool palette across the top and most recently we took the process of taking a module and turning it into an app and tried to make that a lot more intuitive we saw before that a small percentage of our users were actually taking that step in building apps and we wanted to make it simpler easier more intuitive more in line with the rest of how ultrix is used so I’d like to know who before and I know had been building apps in all tricks by show of hands so seems like a few in here great we’re gonna talk about we’re gonna talk a little bit about how your existing apps get migrated as you go from eight six to nine oh and really I’m not gonna show much in the way of slides I just want to get right into all tricks and just show a few things here and there so I’ll switch over the first thing I want to do for the for the new folks is point out some new tutorials that we’ve added under the samples these are actually a new batch of tutorials that came out with eight six release we call them paint-by-numbers or sticker books sticker book tutorials and this this one right here build an app walks you through how to build an app using the new tools it’s got a working module across the bottom here that is taking some data and just filtering it to find the most populated cities in in a given state and what you can do is drag tools out and turn this into an app with a few simple steps and build your first app that way it’s it’s pretty self-explanatory the new tools for building apps are over here under this new tab called interface and you know to start the tutorial the first thing it’s looking for is a drop-down question right there and you’d simply drag that in and drop it into place and follow the steps to configure it based on on what it’s saying there so if you knew that to app building if you’re new to app building and I know go and check out these tutorials and they’ll really walk you through and you’ll get a sense of it pretty quickly right then and there the next thing I want to talk about was the migration of your existing apps and macros so if I come in here and I open this this is an eight-six app that hasn’t been migrated and we handle this for you automatically when I open this up you get a message that explains that the questions and actions and conditions are are now represented by tools on the canvas and when you save this we do have forwards compatibility anything from 86 or earlier will work in my know but anything that you build in nine oh is not compatible backwards so

that is something to be aware of but as it mentions here we save a backup file in the eight-six format that you can still use and then we we tell you down here this is especially important for people that are used to building apps previously that the treeview in the interface designer is a great place to go and see something that you’re familiar with some of you might be wondering okay what is an app an app is simply a Mac a module that has a simple interface and I can click on this magic wand up here because this is an app and this is something I can share I can give to someone else who doesn’t want to dig into all tricks and click on every tool and configure the properties they don’t know the ins and outs but they want to keep making changes so I can provide them with something they can you know browse to a file here it’ll populate these dropdowns and they can rerun the same process that could be hundreds of tools in the cannabis with just a few simple changes so this is what you’re producing when you’re producing an app one of these to share with someone through our private server through the analytics gallery or means like that but you’ve built apps before and you’re not familiar with this new system you want to go to the interface designer and there’s a couple of ways to get at that under the View menu up here show interface designer and you can see the shortcut control all the control dog D also for each one of these question tools on the tooltip we’ve got a little reminder that control off D will bring that up so I will open that up and I get this interface designer window which works just like all of the other windows with an altar it’s you can dock it you can move it around you can position it however you like and this shows the app for getting started there’s there’s this layout view there’s three views along the side here and in layout view you’re actually positioning the different questions on the app for what you’re going to deliver to somebody and using layout view you can select them move them up and down you can add the cosmetic kinds of things the things that don’t interact with your data like an extra tab you can see this one has three tabs so you add tabs here you add labels you can add a link in that and I you can put in a group box there but a key thing is to notice that when I select something here I selected this this drop-down I’ve also selected it on the canvas this is what’s new for an ID oh is that the questions are represented on the canvas so I can find it here selected here it’s also selected there and I’m editing it right here in the properties window prior to 9o you had to do this in a series of modal dialogs that popped up and you had to really kind of grasp everything that was going on in the back of your mind as you were as you were digging in I’m gonna jump down to tree view next because an app is you know on this interface you’re providing questions for your end user to answer and the question is performing an action which is actually changing something within your module so let me show you that tree view I was talking about that’s this third third button here this is what existing app builders I believe should all be familiar with this look familiar to folks yes nodding a couple of knots good the nice thing now is that you’re able to see the questions and actions next to one another previously there were two different windows you couldn’t have open at the same time and I can select you know this address question here and I can see through the highlight that the actions it’s connected to are over here so I can really see the relationship between the questions and actions and again selection is is happening here I’m selecting it in here and tree view and it’s also selected on the canvas and it’s also available over here in the properties window for me to edit so if you’ve got an existing APRA macro from 8:6 that you built before and you open it up we’ve added for you all of these questions and actions in this container on your canvas and you don’t you know you didn’t place them here you don’t know what’s what go to the tree view that should be familiar to you that should help you find those and then be able to make any edits that you need at that point and if you don’t want to even see this container you can collapse the container and just get it out of sight out of mind by having the questions and actions on the canvas represented as tools you’re able to see and really really visualize what’s going on because that they are connected and if I select this I can see that this question is connected to these other questions and also to this action and a warning down here but you’ll notice that you don’t see that connection unless I’ve actually

clicked on it and the reason that is we’ve added this new concept of Wireless connectors and they’re purely cosmetic this tool is connected to those tools I can see when I select the tool that the connection is there it’s not limited to the new app app questions it’s not limited to those I can do that with any tool I want I’ve just right clicked on this tool and I say make outgoing connection Wireless and suddenly that’s Wireless it’s still connected this is something for people who you know we we hear you loud and clear that you get frustrated with the lines that turn into spaghetti and that sort of thing and maybe a real use case is on this one you might want to make that line Wireless because it’s coming across the comment there so you can you can another way to do it is to select the connection itself I’ve now got the connection over here in the properties window and I can just click that and make it wireless and now that it’s still connected but it’s not drawing for me you can do that with a bunch of tools at once if I select all of those I can make all incoming or outgoing wired just like that and the connections are drawn for me so that’s something we did because when we found that we were when we were migrating your existing apps you know we couldn’t know programmatically where were the best places to position all of these new tools we were adding and it it became a mess if we just had all of those lines there and you know we knew that people were interested in the idea of something like wireless connections so we added those in I’m gonna pause for just a moment see if there’s any questions about anything I’ve I’ve gone over so far God himself has any anybody has used the new wireless connection what are you aware of them show him I’m like I have a quick question on just general feedback for those users that have used the previous way the the treeview that Jeff was talking about what are your thoughts on the the upgrade and the enhancement do you enjoy I mean do you do you like using the canvas better internally we love it we wouldn’t have done it if we didn’t think that it was useful and helpful and I personally felt that whenever we were testing all of these whenever part of my testing case was to actually create a batch macro and I’m thinking okay well I’m gonna have to go through and you know create this question this action and go through with my macro input and once I actually got into it I created one in about five minutes and this is coming from an ultrix user where I’ve been building apps and macros for seven and a half years the old way and I jumped over and dove in and never looked back so any feedback with those yes one one use case or not use case with one example of something like that is previously you could create an action and not actually have it connected to anything and your module would run and it wouldn’t be doing anything but you might have thought that it was because it wasn’t properly hooked up and in nine oh it does throw out an error and say this action is not connected it helps you find it it’s pretty straightforward we’ve had a number of those come through but it was kind of a false positive before it wasn’t really working before that’s the only thing that I’ve really heard of since then we did a lot of testing and tried to try to get every case we could if you’ve got other examples certainly would love to hear them I saw a hand over here first then we’ll come to the back corner you great that’s the night does feel very much it was a challenging project and it’s very gratifying to hear that so thank you definitely come find us in the solution Center as well after this and we’ll we’ll be happy to go through any sort of demos or just help you walk through something even using your own data if you have your thumb drive or your flash drive with you and we can try to we can try to work something out and we’ll go through and we’d be happy to be happy to work on some of those demos okay that’s that’s good to hear about

thank you and I’d like to follow up afterwards and just hear a little more about that that would be great this that many of you have no use apps and I you know highly recommend to either listen to one of the web access I don’t know if wish I could put you in the spot right now you might be coming to tell your story about yesterday well yesterday I was in the solution Center and in vish from KPMG asked me can you just go over the apps I have never used them and we spent like about an hour right and I just love your feedback yesterday so you don’t mind he just say yeah it was very quick the way she did it she first built the module and then we went on to build the app and she was able to publish it also in the private studio all within like maybe 10 15 minutes she completely building oh wow can I do it just without coding without any any coding and we publish it to the web and it was a simple app and and just the easy of use for the end users that they don’t have to do any coding they would just get the front end answer a couple of questions and boom finish get the report customized for them because they decided what the address was for the tray area create the tray area the size of the tray area and get the results so really guys I highly encourage you to learn more about building apps thank you vision thank you so much I want to jump in and show another small feature that we added with the wireless connectors and it’s it’s the navigation window I’m gonna select this input tool here and normally you get the properties view with the wrench up here we’ve added this new Gatien tab or window right here if I click on that I can see all of the tools that are connected to this I’ve got the update input action tool which is the red line up above and I’ve got an outgoing connection to the sample tool which you see right next to it this is another way you can turn the wireless on and off through this tab but a neat thing is I can double click on this and it’s just moved my selection over to the sample and I could navigate all the way through my module just by doing this I can if I just keep clicking how cooling and I’m just all right here I’ve got three choices which one do I want to go to I’ll go down to the join and you can see that it changed this selection it’s moved through it I go back to properties now I’m on them I can click and I’m back on the properties for that tool so this is something we added with the wireless connectors it’s not just for apps at building it’s you know for any tool on your canvas and can help you get around as you’re you know building the bigger and bigger modules that you’re trying to go through next I wanted to talk just a little bit about the basics of constructing an app I made you know a dummy module doesn’t actually do anything here but I’ve gone to the interface tab and this square icons across the top those are questions you know I can do a checkbox question a drop down file browse I’ve got a text input here so I’m gonna just go to a text box and drop that in so this is where I would invite my my end user to you know enter a name and I can just type enter their name and it’s it’s there it’s it’s ready for them to type in it needs an action to actually do something to my text input tool and we’ve got I think it’s close to just over a dozen questions there’s only a single action tool and that’s this guy I dropped this onto the canvas and I see that there’s roughly 20 action types which is a bit overwhelming but the beauty of this new system is when I put this in place and it connects up it has truncated that list down to the only four that might possibly make sense since and it’s giving me a default action that it’s recommending which is the one we think is most commonly going to be used if you’ve got a text box going into a text input and in here I’ve only got the one cell but it’s inviting me to take whatever the end user inputs through this question and use that to replace whatever is in right now Row 1 column 1 so it’s it’s it’s really

straightforward and easy to do you can still do the update value for those of you that were authoring apps before but previously when you created an action this window and you wanted to update a value or I could do the same thing by coming down here and choosing that same value that’s exactly the same as as Row 1 column 1 this has configured exactly the same way now previously though I had to navigate through all what 400 tools on my canvas to find this text input and this this value that I wanted to update because the connection wasn’t there it was all sort of an abstraction now we think that’s a lot easier to do a lot a lot more straightforward for you let’s look at this for a second though this is again a very very simple app it’s got a single tab a single question you can see the selection going on I showed you the tree view it’s very basic right now the last view is test view low on power Thank You Chad and in in layout view I’m selecting the question but I can’t actually type anything I’m not interacting here I could I can change the text up here but I can’t type in the field in test view here I can type so I’ll type XYZ and this is where I can see what the end user is going to actually do with the app now to really test it I can open this I can use open debug and what it’s going to do is open a new tab with just my module not the app stuff but instead of the ABC here because I’ve typed XYZ I open this up and it’s not an app that’s just a module and here it’s replaced the ABC with XYZ so now I can run this and test it and when things get a lot more complicated than my little app here that’s helpful to see all right what what’s going to happen if they do this if they do that just going straight over here and seeing what it does to my module running it and debugging it as a module is a great way to get in and see how that works question you do have to open it every time you got your over every time you delete that come back over one thing you can do though when you’re getting an advanced app is I go back to test you and I come over here and I type X Y Z and I fill out you know a dozen questions I can save these values to a file and then later on and I can you know save multiple of them I can open them and I don’t have to come in and fill that out every time so that’s another another thing you can do but you do need to hit open debug each time to have it populate with with what is in there it’s a good question anything else question wise okay a little tip almost always when you’re building an app the questions that come from up here are going to be connected you will find that you can get away with radio buttons not being connected actually let me show you another tip first you you saw me place the radio button question and earlier you saw me place the action I can actually drag from this Q to this little lightning bolt and it’ll place the action for me and I can come in and then configure that it’s not going to make a lot of sense of what I’m building right here but just a shortcut you can drag straight in and it’ll populate it and it’ll give it the default action that that it recommends and it it’s calling the list for you in this case when you know when you’re using a radio button you’re saying all right if this is selected do a for my module you can have a floating radio button that’s not attached to anything and that is run the module as it was initially configured you can tell it to run the module as initially configured but you don’t need to just a little little tip there with that and just because it’s not always completely obvious you can have as many actions connected to a tool as you want it’s the mortgage calculator might wanted to look at very simple but it kind of demonstrates that just a little so here you can see that these six questions and actions are all modifying the values within this one text input at the beginning of the mortgage calculator

and then this single question is performing actions that update three different tools to make this this simple little mortgage calculator work so again typically every question is connected to an action is connected to a module tool but with radio buttons you can leave one unconnected and have it so that your module will just run without making whatever change the other radio button is doing that makes sense Oh question here yes so what you’re getting at there is getting a little more advanced and I’ll get Chad Margaery to help me out a little bit but if you want you can write an expression here and create something and you want this expression to reference bring in a text input text box rather and this expression I can go to connections from questions here and I can have the expression actually use the value that’s passed in straight from the funding textbox and essentially any tool that has an expression editor in it has this extra Q input for the ability to do that so that’s your formulas your filters your Diner multirow multi field formulas things of that nature like if I understand correctly so so when you say variable what do you mean very well like a well she’s asking if you can search for specific like expert like an expression or something like that yeah which we can’t really search the text unless you go into like the XML view of Alteryx but you can search for specific tools that you’ve referenced as well do you do you use multiple formula tools or do you use one formula tool with multiple formulas within it both mm-hmm – so the question is how do I go back through my module and find a particular formula tool that’s doing a particular thing I don’t remember where it was from when I offered it okay okay that thing yeah so I don’t think that we well unless margarita oh well there’s a fine tool and you can find here the text but actually and that’s not yet unless you actually go into the text editor or the XML portion do you are you guys aware of the XML view that you can enable okay for those of you who don’t know you can actually go into tools and settings and there’s an XML view we actually do have it enabled on this particular one there’s it’s a little XML open and closed tag and the left-hand side of the the properties window so it’s right next to your wrench for your configuration for each tool so you can enable the XML view and then actually go into the text so from there you could actually click Edit and then you know do a manual search it is a little more compass or cumbersome still but it at least is some sort of functionality but that’s also a really great suggestion and for those of you who aren’t aware we do have a community forum with an idea center as well that is we’re really growing it pretty rapidly right now but with that idea Center you could actually post that idea as a feature request that can help you and then other users can go on and upload it so that would be a very very good addition to that and if you want more information on that please let us know and we’ll work on getting you access to the community that’d be really good though yes and also to access the XML view for the entire module no just for that a specific tool you will just click on any empty space and then go to the XML view and areas and you can do the find right here they filled one so you will find you know in there so in that case you could

search specifically for your text color or does that help not yet but yeah definitely unrelated to app building I did want to point out that we now have the favorites tab pinned or static up here if I go clicking through you’ll notice that favorites is not moving that was a customer request when we added the new tool pallet and we were you know very excited to get that in and add it for you and we went one step further I’m using my connectors category all the time I can right click and hit in and now I’ve got both of these pinned over here on the left and you can do that with as many as you want and have them static over here on the left just adds to these ability you can take the ones that you don’t use so often and not have to look at those and worry about those I can unpin them all at once and get it so that nothing’s pinned and go back to favorites and I’ll put it back the way it was by default I’ve got that in there for you this is a tip that that it’s been around for a good while but I think not everyone knows I can drag from these tabs so I can just click and hold and drag straight down from the transform tab and get that tool there and if that’s not the one I want to use if I’m transposing a lot today I can right click on that and set as default tool you’ll notice it changed up here I can now drag it a transform straight in so it’s kind of like a bonus favorites going across the top there but the the pinning is new the ability to lock them over here and have that just like that is new more questions while I keep going cool things like this question so the way to the way to do that is through our analytics gallery and to publish it up to the gallery and up there you can have it published privately so that only you can see it only you can run it the people that you want to share it with and then the next way to do that is through our new server product where you can have a gallery inside your firewall that only people within your organization can see correct correct to run it without an actual designer on up on a computer yeah in so the question was whenever you publish something do you have to contain or or keep your input files in the same directory what happens whenever you actually export a Alteryx zip package or publish to the gallery it first creates this altering zip package where everything gets dumped into the same local directory so if you have you know a whole substructure of sub folders that keep your data organized that is fantastic but whenever we create that zip package there’s no way to really truly maintain that just programmatically it’s just not it’s it’s opening up a can of worms that is really not solvable so we keep everything in the local directory and make everything a relative path to do that but for the majority of your inputs yes you’re gonna have to publish those to the gallery as well with that unless it’s a part of our core data bundle so a lot of you are probably customers with data and their packages you’ve got the data package with your instances of all tricks so anything in the coordinated bundle like your Experian data sets all the tomtom base Maps the Calgary data sets they are all located on the gallery already so you don’t have to worry about publishing those the beauty of that as well whenever you go to publish is Alteryx knows what those are so by default they will be unselected so you’re not trying to push 160 gigabyte individual file up to the gallery that’s just not gonna happen so if you’re going for you can do whatever you want if you hits your own server yeah you can absolutely do that exactly there are definitely a lot of benefits to using the private server most notably is just security you can also use Windows authentication whenever you have private server behind your own firewall so your your IT department still doesn’t even really have to be involved with this they’ll set up the server or we’ll help you set up the server and then through windows authentication all you have to do is just navigate through your browser to your private server instance which is going to look just like our analytics

gallery that we host online and it’s really it’s really helped out a lot of people they really do like that because then it gives them more control they don’t have to go in and maintain additional settings of their IT department doesn’t have to maintain additional settings it’s just that okay there behind the firewall they’re using Windows off let’s navigate there and and then go for it another tip is well you’re asking about publishing to the private server or just at a gallery in general it’s also I think the term is dynamic where you can even run it from or you can navigate there from your cell phone your tablet your iPad or whatever and everything will scale appropriately so whenever you build out these apps let’s say you have field reps that you that run location analysis apps well they don’t want to carry around this giant computer with them they can actually run things directly from their phone that are shared specifically with them we have a lot of examples I believe actually I think whatever you have tableau and install tableau I believe what happens is you get access to a few more samples but definitely come find us in the solution centers and yeah that if there’s ever install I said you gotta go to several loads /keep and that allows those extract samples the tableau kit yeah yeah and it’s the same thing with like revolution analytics and the predictive tools you won’t actually see any of those tools or those samples unless you have that data installed or though that functionality installed it’s not that it’s a secret or anything like that if somebody calls us they will have access to the dun and bradstreet data but they want to know the functionality this actually just happened yesterday would they want to see the functionality of how we actually kind of we’ve kind of hacked the Calgary tool in order to do a fuzzy match well it’s just a macro underlying the whole business matching macro so I’m happy to forward that to that particular person just because it’s he’s not gonna be able to use the data with it obviously but he’ll be able to see that functionality and what we’ve done with those formula tools in order to create this fuzzy matching scenario using Calgary I’ve got another example of a little automation that we added here I’ve got a simple module you’ll notice that it module type is module and as soon as I drag any tool from here in the interface category it’s going to show me the properties for that tool if I go back to to here module is now grayed out and it’s changed it automatically to an analog app so I don’t have to do that anymore I’ll have to think about that anymore and if I save this right now it’ll be saved with the app extension with the Y with the Y Z extension if I had previously saved this as a module and I’ve been working on it working on it and then started adding app tools it would pop up a window that would prom to me okay you’re an app now do you want to save this just as an app and overwrite what was there or do you want to leave your module and save a new file for the app that you’re now building so you will get a message if you if you get into that that scenario there’s one other correct me if I’m wrong but that’s all so it’s going to be very specific so if you’re using a control parameter which is very specific for batch macro it’s automatically going to change it to a batch macro as well yep I drop that in and you’ll notice that is now a badge macro from the control parameter tool and then a small thing here it used to be that if you wanted to see this this tool happens to be a macro if you wanted to see this tool as a macro you needed to drag it down to canvas right click on it and say open macro and we added the ability for you to do that straight from the tool palette and just do that and it will open this macro math macros are migrated just like apps are so I’ve I’ve opened that up all of this is basically built to create this so this is what this is the inside the guts of this this tool right here because it happens to be a macro and I see a couple of hands ones one back here yes absolutely so okay so with the field mapping yes what the question was can you use that same functionality that Jeff just demonstrated with the macro in the app in that you’re using a field map what the field map is is let’s say

you’re doing a geocoding app you’ve got address city state and zip all right for fields your sample file your sample input file would have those address city state and zip address city and state at least would be text fields the zip may be a numeric maybe text or whatever it’s going to expect that same field type as well whenever you use the field map so if you’ve got numeric fields with sales data it’s going to expect some sort of numeric field so using that field map will automatically populate or show you all of those fields that are in your sample input data so if you have an example that you generally use it’s going to show up automatically every one of those for all every one of my four address fields are just going to show up you don’t have to create separate questions for each one of them the other really awesome thing about that if you do have very standard fields like address city state and zip it’s automatically going to map those whenever you connect to your input tool to that macro so it’s or or actually the same thing with the analytic app as well let’s say you have your gonna browse to your YX DB file it’s automatically going to see oh I have a fields in this YH TV called address city state and zip and it’s going to automatically populate them you don’t even have to really worry about choosing things but you know it’s it’s not fully dynamic so if you have a field that says addr instead of address it’s not going to know that automatically changes reminded me of another benefit of having the tools on the canvas to the app app and macro building I can now select these and if it’s set up to feed say an address with you know all the different address fields and there’d be a bunch of questions here not just the the one I got selected I can copy that and paste that into another app and just go from there I don’t need we build that from scratch it makes it a lot easier to select stuff copy it paste it move it around so definitely advantage is your as you’re working on your house is there question there isn’t but you can have everything selected so control a and then right-click and you can make them all just like that so I just done it to the entire module like that but there isn’t a global sort of a shortcut that could definitely be a little scary though with those large modules with a lot of questions and actions and you control a and then show all wired connections and it could definitely get a little overwhelming one of the things we experimented with when we were building actually when we were figuring out how to migrate your existing apps and macros we thought that it really made more sense to put the actions down by the tools that they that they modify it and we tried to do that and then we got a hold of some customer modules and it just it wrecked them it really did it it moved things around too much and we had some great help from beta testers looking at that and expressing their frustration with it and so that’s where we landed on this I might have closed it but the idea of just putting it all in a container and compartmentalizing it off to the side so the container represents how apps and macros are migrated but best practices we think you you want to organize things so that the questions and the actions are near the tools that they’re actually modifying and maybe the horizontal layout was the best for it right it works with both horizontal and vertical for vertical we I bring that over and it brings the the questions and actions in from the side it was important to us to to not have it be part of the workflow to have it come in you know at a right angle to your actual workflow because it’s not changing the data it’s it’s changing the tools changing what’s happening within the tools and so it’s it’s a different way of kind of thinking about things that’s a good point we do support the vertical well how many folks I’m curious how many folks are using vertical ok forever I hear you said John looks like maybe a poser roughly I’m I’m very interested in hearing feedback usability ideas how to make it easier to use so much of what we’ve been doing has come from talking to folks that inspire and talking to customers so track me down and definitely pass on any feedback that you have in the solution center we also have some surveys that we’d like people to fill out with questions like what I just asked are you using vertical or horizontal does anybody ever make these horizontal tab groups and have two modules open invisible at the same time anybody do that okay we’ve got one good I was up here and I right clicked and I

chose new horizontal tab group and you can go vertical as well and you can actually have multiple open of course your real estates pretty small at that point other questions John if it’s over the actual tools we don’t have a way to turn that off but gathering that’s getting anyway okay every little bit know what is that so that’s that’s pretty much it for time are there any other last questions yes we don’t have that configurable book one of the things on our list is to make the the user settings more robust in that you can’t actually set the things you want and you can restore just the things you want not the entire thing we know that’s frustration and that’s that’s definitely on our list as well so real quick I wanted to let you guys know as well if you have more interest in app and macro authoring Jeff has another session coming up where he’s going to go into full detail I mean we we’ve pretty much covered a lot of stuff here as well but but you’re going to go into even more detail about the app and macro authoring a 9.0 in the new way so if you haven’t upgraded to 9.0 yet please do so or don’t start building apps and macros the old way until you actually upgrade the 9.0 because you’re going to be very happy that you did thanks everyone