I then grabbed my old Canon imageFormula P-215 document scanner that I’ve had for years. I did some amount of back entry this way but decided that this just wasn’t going to fly. This was also a little time consuming to get a copy of the image and then also make sure it was fully legible. It meant that the photos were never well cropped and I ended up having to take them on dark backgrounds to make it a little clearer. This worked ok but wasn’t the greatest experience. Initially what I was doing was using my phone to enter the data and also then take a photo of the receipt. The last piece is of course an image of the receipt. Finally I decided to use a location field to track where I refuel. There was also a trip timer that I’d not tracked either that I now use to track time between refuels. Then I looked at the trip computer in my car and thought it might be interesting to keep a copy of it’s internal range estimates, average fuel usage estimation (MPG) and average speed (MPH). Then I realised I should probably track the odometer reading as a secondary data source to validate the trip counter reading. I thought that would be sufficient and my old receipts only had the trip reading. I have a timestamp field for when I refuelled, the gallons I pumped, the cost per gallon, total paid and the trip reading. I started out creating my fuel database using receipts as I created them, slowly fine tuning the database and adding various fields. This brought me to the next challenge: how do I quickly add my backlog of receipts? Then TapForms later added support for syncing to CouchDB which made it easy to quickly within my own network set up sync and then add data. With TapForms 5 the data storage layer moved over to Couchbase Lite with sync options being Peer to Peer and IBM Cloudant. In 2016 I picked up TapForms to replace Bento as my personal database tool that sync’d across Mac and iOS. For the longest time I’ve collected receipts from when I’ve refuelled my car however I’ve never had a good way of figuring out how to import them and retain the images.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |