For a while now we’ve known that we wanted to add more functionality to all the tables in Commusoft. We had a lot of areas that looked as though they should behave like spreadsheets, but were a lot less simple to use and didn’t have any of the nifty little features that make spreadsheets so helpful.
We’re happy to announce that this has been remedied and we now have spreadsheet-like functionality throughout the webapp on supplier screens and more. We have a few still to roll out, (anywhere that has a table for data will likely become a spreadsheet) but you can expect to see these become available in the next couple of months.
What can you do with the new spreadsheets?
We’re glad you asked! We’ve done everything we can to ensure that our spreadsheets mimic the behaviour of programs like Microsoft Excel as closely as possible. The main exception is the ability to create formulas that perform equations for you — any calculations that need to be made are done automatically as the columns are already defined and each spreadsheet is for a specific purpose.
Check out the video below for a walkthrough of the functionality you can expect.
As you can see, we’ve also added a way for you to search through your parts to add them to a purchase order.
The list of functions
- Click and drag to select multiple cells
- Click, hold shift and use arrow keys to select multiple cells
- Click corner and drag to duplicate data down columns
- CTRL+Z to undo actions
- CTRL+Y to redo actions
- Hit the delete key to clear data from highlighted cells
- Setup defaults to apply to all rows
As part of our efforts to reduce the amount of time you spend on data-entry, we’ve also added an option for you to set up default nominal codes for entire suppliers. Oftentimes, you’ll have one particular supplier for just one type of product or service. By applying a default nominal code, you won’t waste time copying already-known data into your spreadsheets.
You can do this simply by clicking edit on your selected supplier and choosing the correct nominal code from the drop down menu on the bottom right.