Skip to main content

O365: Make Life Simple. Grab Data on the Go

O365: Make Life Simple. Grab Data on the Go.


Earlier Office 365 posts have pointed towards simple ways to make SharePoint List and SharePoint Library data containers, simple ways to populate these with data that is useful to business and simple ways to filter that data for useful output commination like invoices and reports.

Reading back through those posts it becomes obvious that the more data you collect, the more you can do with it. This is probably best highlighted in the CRM example, where all communication between company representatives and individual customers is captured and used across the business.

The great thing about modern technology is that even when visiting a customer the person representing the business can access the same data that is available when sitting at a computer in the office.

In addition, updates can be made to the data without a return to the office being necessary.

Accounting

The same can be said of accounts and expenses records. Hotel, meal and fuel receipts can be filed direct from a smart phone instead of filing, indexing and storing all of those annoying bits of paper that have tied us down in the past.

Introducing Power Apps

Accessing and updating data through Teams and ASPX pages is great and can accommodate most business needs, but sometimes data update through a smart phone is not as easy as it could be. Buttons and links are small and a field worker in a hurry may find it necessary to spend more time in order to be accurate.

To overcome this you can easily deploy a Power App that will deliver a simple smart phone screen, with large buttons, that will file the data directly to the SharePoint List.



The above screen shots display a simple Power App generated from a SharePoint List called Contacts for an Android or IoS phone.

The left screen displays all the customers in the list, these are searchable and sortable and the screen incorporates a find function.
Clicking the right arrow next to a customer name displays the details for that customer. 
A new customer can be added or detail can be updated provided that the user has the necessary permissions.

Generating a Power App.

This is the really good bit about Office 365. You hardly have to do anything at all.

On a PC, launch the SharePoint List 
and click the menu item to launch Power Apps.

Name the App and allow Power Apps a few minutes to build. Once done test the operation and then share it with users.
You can either email the share or launch it into Teams as a Organisational App.

The App can be used from a PC as well as from a phone, so the user interface is the same for both field and desk workers.

Wide Ranging Uses

You can do the same with any SharePoint List, so the range of potential uses is almost endless. 


The above images show an inventory control app that can be updated from a tablet or phone in the store room.

 We can show you how, or we can do it for you.


Comments

Popular posts from this blog

Acquiring Market Share. MD, MD, how does your business grow?

Gaining an increase in market share may become necessary for a number of reasons. You may need to shift focus from one product line to another in the face of a declining market, you may wish to expand to fend off a market place squeeze or you may just be growing towards your planned capacity. Whatever the reason, you will need to form an acquisition strategy. There are three ways to obtain an increase in market share – Earn it. Use competitive trading to buy it. Acquire a competitor. Each of the three approaches bring along its own strategy requirements and its own issues. Selecting the best approach depends entirely on circumstance. Outperform the competition. Earning market share by supplying a better product, better service, better support, better delivery is an honorable way of expanding a customer base. It is steady, progressive and undemanding in that production/purchasing is not subject to stresses caused by sudden up-shifts in supply/delivery. Even so, there are issues. Attaini...

The New Computer Age: Office 365 Vs Google, Dropbox and Others

Differences in Software as a Service ( SaaS ) This is the 21st century, the New Computer Age. Cloud services and SaaS are available for all to use. Word on-line, Excel on-line and Power Point on-line are just such services. They are available to all who want them, they are free, if taken via One Drive Live, and they enable the creation, editing and viewing of Word documents, Excel spreadsheets and PP presentations on ANY device that has a browser installed. This without any need to install software on the device used. The on-line software that is used to create the files is the same on-line software used to view them. There can be no incompatibilities and no missing fonts. Open Document Standards, to which these most office applications conform, requires that any document file should contain the properties of style, layout, font etc. These elements are the property of the document file and will travel with it wherever it is stored or sent. However, issues can still aris...

O365: Mobile Apps - the easy way

 O365: Mobile Apps - the easy way See also -  Other Office 365 Posts Anyone following these posts will now know how easy it is to create data stores in SharePoint for documents and files and for listing data, such as customer details. We've also looked at making this data easily findable, how to flag items for the attention of individuals and teams within the Office 365domain and moving work through the system in a controlled manner. We've also seen how we can access this content when away from the office via mobile apps for Teams, SharePoint and OneDrive. Occasionally the standard apps aren't really convenient and fail to lend themselves to mobile use. I'm thinking here of functions like stock lists, customer contact lists and the like, when the standard app delivers too much detail for a small screen, or where links and buttons are small and difficult to use. For these functions it would be better to deploy an app that is designed for fast, effective use on a mobile. ...