How to make your own service log mobile app, for free


(Arthur Pappas) #1

THE WHY

Are you looking for an easy way to record the service work performed on your bike? Are you tired of scribbling illegible greasy notes into a notebook that is never found again? If so, keep reading.

THE WHAT

So, uh, what are we talking about here, exactly? We are going to take a spreadsheet and turn it into an easily accessible smartphone app (Android or iOS). You’ll be able to quickly add (or edit) any service work you (or others) have performed on your bike(s), boat, car, generator, etc.

THE COST

Zero dollars.
About 30 minutes of your time.

THE RESULT

Apologies in advance if this tutorial seems overly basic, some of my friends have no idea how to use a computer. Hell, some of them own years of helmet cam footage that has been seen by exactly no one. Why? Because they have no idea how to use a computer. But, I digress…

PART 1 - CREATE SPREADSHEET (Google account required)

  1. Login to your Google account and go to Google Drive.
  2. Create a new spreadsheet, and name it whatever works for you. The spreadsheet can be as simple or complex as you like, but the only thing on the sheet(s) you’re going to add is column headings – nothing else. Add headings for items that you want to log. You can add a new sheet/tab for each machine you want to log. I keep my column headings the same for all machines, but I do this only to keep things simple. You can mix things up if ya like. See my example, here:

PART 2 - IMPORT SPREADSHEET INTO APPSHEET

  1. Go to https://www.appsheet.com/Home/Start
  2. Click ‘Google Sheets and Forms’ and connect/authenticate to your Google account, and select ‘Allow’ when prompted.
  3. Click on ‘Make a new app’
  4. Name your app and select a Category. I can’t remember what category I used but I think it was either ‘Field Service’ or ‘Other’ – it doesn’t really matter.
  5. Click on ‘Start with my own data’ > Google > then select your newly created spreadsheet.

PART 3 - APPSHEET DATA TABLES

  1. You should land on the ‘Data’ section in Appsheet. Here’s what you should see once your spreadsheet has been imported:

  1. Click on ‘Tables’ at the top. Now, if your spreadsheet has more than one sheet/tab then ‘add’ them to your app as seen here:

  1. Click the ‘Columns’ tab and take a look at my settings. Pay close attention to the ‘Type’ column. Make sure you click the blue popup ‘Save and verify data’ if you made change. See here:

PART 4 - APPSHEET UX

  1. Click on the ‘UX’ tab then ‘Views’ at the top.
  2. Click on your ‘machine’ to expand the table.
  3. Under ‘View Type’ select ‘Table’ because it’s the best view for our purpose.
  4. If you have more than one ‘machine’ then you can select where it is displayed under the ‘Position’ section. In my example, I have the Gator positioned left, boat at center, and my generator at the right. See here:

  1. Choose an icon if you see something that fits, then ‘Save & verify data’ after making your changes.

  1. Staying in the UX section, click on the ‘Brand’ tab at the top and make whatever customizations you want. Remember to ‘save and verify data’ when you’re done. I can’t remember if all options are available on the free plan, so you’ll just have to experiment.
  2. Still in UX, click the ‘Options’ tab and make any additional customizations if desired. For example, you might want column headers shown, hide the share button, etc. We have no forms in this example, so nothing related to forms applies for us. Again, feel free to experiment, but remember to save/verify your changes. If you don’t understand what a setting is then I suggest leaving it alone.

Save/verify your changes.

PART 5 - APP INFO

  1. Go to ‘Info’ > ‘Documentation’ and turn on ‘personal use only’. Now go to the ‘Properties’ tab and add a description for your app, if you like.

Save/verify your changes.

PART 6 - SYNC

  1. Turn off ‘offline use’, ‘delayed sync’, and ‘delta sync’ (they are not available for the free plan).
    UPDATE: You might be able to leave these settings enabled. You will see (red) warnings listed in the next step (deployment), but try and deploy your app anyway (that is, ‘deploy wither errors’) to see if offline sync works. If it does not, simply go back and make the changes recommended for this step.

Save/verify your changes.

PART 7 - DEPLOYMENT

  1. Click on the ‘Manage’ section. now at the top click the ‘Deploy’ tab then ‘Deployment check’.
  2. Uh oh, do we have errors?

  1. If you see this warning go to the ‘Security’ > ‘Require Sign-in’ and turn off ‘authentication’ and turn on ‘public’.
  2. Go back to ‘Manage’ > ‘Deploy’ and run the deployment check again. Don’t worry about any ‘Description’ warnings. At this point we don’t care that our app uses the default icons. You can deal with this another time.
  3. Run the deployment check again. Hopefully, we only see the yellow warnings and no red warnings.
  4. Click the blue button ‘move app to deployed state’.

PART 8 - SMARTPHONE INSTALLATION

  1. Open the app store on your phone and install Appsheet. Open the app and login with your Google credentials. Your app should be good to go.

MISCELLANEOUS

  1. You can add images to your app simply by changing the ‘type’ as described above in Part 3.3 to ‘image’. You should make sure you have a corresponding column in your spreadsheet.
  2. You can create multiple ‘apps’ linked to various spreadsheets.

CHANGES TO THE APP OR YOUR GOOGLE SPREADSHEET

What happens if I make changes to my Google spreadsheet?

No problem, just login to Appsheet and go to ‘Data’ > ‘Tables’ and click on ‘Regenerate’ for each tab (or ‘machine’) of the spreadsheet that you modified. You might also need to run a manual sync on your phone


(Bryon Enns) #2

This looks good. Gonna be all over it when I am back home. thanks.

Oh and I have heard some of your friends theaten to post incriminating video of me but we all know it ain’t gonna happen. LOL.


(Arthur Pappas) #3

Have fun with it. You can go all out and add options to include photos, etc, in your log if you feel up to it (screenshot at Part 3.3 ‘Types’).

I hope one day my version of the app shows ‘bike’ at the bottom of the screen…


(Bryon Enns) #4

Can’t get rid of the account error

Public Name	App Name	Status	Usage	Log	Minimal plan needed
KTM 690 Service Log - Bryon	KTM690ServiceLog-Bryon-520302	   	0 monthly users	Log	PREMIUM , PUBLISHER_PLUS

It looks like I need a monthly plan to run this app.


(Arthur Pappas) #5

Can I have a peek at your spreadsheet? Also, post a screenshot of your deployment screen errors.


(Bryon Enns) #6

hey, maybe it’s because I used my existing KTM spreadsheet that has data in it? I tried without the data and same result.

Readiness
Account status
ERROR
Invalid subscription plan: KTM690ServiceLog-Bryon-520302: Plan type FREE is not allowed because: Offline access not allowed with the FREE plan, KTM690ServiceLog-Bryon-520302: Plan type FREE is not allowed because: Advanced sync options not allowed with the FREE planMORE INFO
You can test, distribute, and start using your app right now. Once the app is past the testing phase, please upgrade your account subscription plan


(Arthur Pappas) #7

Your issues are related to the sync settings. I will post a screenshot of my settings in an hour or so when I’m back in front of my computer.


(Arthur Pappas) #8

Go to Behavior > Offline/Sync and make sure the only setting that is turned on is Sync On Start.

Also, you might want to add the option of including images. This might be a good way to photo-log any issues, wiring harness routing, worn parts, shit you take apart and need to remember how it goes back together, etc. To do this:

  • Add the following column headers to your spreadsheet:
    • Image 01
    • Image 02
    • Image 03

The above will give you the option of adding up to 3 images with each log entry. Just add more column headers if you want the option of adding more images.

Now go to Data > Tables and regenerate the table.

Here are some table examples of a couple apps I have. Notice that I use the Decimal Type to record hours. You can also make use of the Yes/No Type to make finding any issues (“Yes”) quickly. Make sure to regenerate the table after making any changes. The changes will be propagated to your app the next time you open it.

Lemme know how it works out for you.