Device Magic - Updating Customer Machine Build and Contact Details

How to update the details for customers, build numbers and email contact details on the Device Magic forms

Device Magic, Forms Device_Magic_-_Updating_Customer_Machine_Build_and_Contact_Details_Device_Magic.png

Version Information

This procedure simplifies and standardises the background resources for the forms data and supersedes any procedures before 16/11/2020. The form data is now stored on a Google Sheet that is simple to maintain and update

Form Data Location -Google Sheet

The data is located here

Device Magic Data v2

The sheet is password protected by Google account, so you need to be logged on to Google as stugaservice@gmail.com. the password for this account is available from the service coordinators. The easiest way to be logged on is to ensure you have Chrome installed, and log onto chrome with the stugaservice account.

If you are clicking the above link, you will need to ensure it is then opened in Google chrome.

There are lots and lots of variations on the process of being logged in, but the main point is that you will have to be recognised as stugaservice@gmail.com to be able to edit any of the data.

The data is stored on a series of tabs accessed along the bottom of the spreadsheet

Customers Tab

The first tab is a list of the customers.

Customer Tasks

Task	Notes
Add a new customer	Insert into the list in alphabetical order
Change a Customer name	If the name is changed on this tab, you MUST update the associated fields on the Builds and Contacts Tabs

Builds Tab

The builds tab lists the fleet of machinery that Stuga looks after and should be identical to the "Machines" board in the Monday system. This link is made here between the Customer who owns the machine and the machine type.

...The machine Type is important because this dictates the steps of the Planned Maintenance form

...Note that the Machine Type and Customer columns have a little triangle at the end denoting a drop-down list. This is crucial in maintaining the accuracy of the data for the device magic app

Builds Tasks

Task	Notes
Adding a new machine build	First, copy a line that is there already to maintain the dropdown list integrity Insert / Add the copied line in the list of machines in the correct ordered position. - For a new ZX5 build, you will be adding it to the end Update the Build Number Update the Machine type Update the customer ...If this is a new customer, you will have to add them to the Customer Tab first
Moving a machine from one owner to another	Find the build number in the list Update the customer ...If this is a new customer, you will have to add them to the Customer Tab first. If the machine has been bought by Stuga, change the customer to "Stuga Machinery LIMITED"

en none 0

Draft