I need a database created for field inspections

By

Further details of question

I was originally looking for a developer to create a Microsoft Access Data Base to record site records for field inspections but wanted to know if any apps could do the below.

Each Field Site item with have:

  • Location description
  • Location details
  • Provide for linking to site maps
  • Allow for 100 sites

Each site item will have:

  • A drop down Description
  • A drop down Condition
  • A date of inspection
  • GPS Location
  • Allow for 20 items per site
  • Provide for linking to photographic records
  • Provide for linking to documents
  • Provide site and item work history
  • Provide for history of person making amendments or adding data
  • Provide for record printing. i.e. summary site report

Answer

I’d recommend you look into using either an online database tool or use a project management tool that includes an app that can record GPS location data, images and additional notes. You could also look into integrating What3Words for easy to remember location details.

Get in touch with one of our Business Systems Consultants to discuss apps that can be used to streamline your field inspections and auto-create Word & PDF reports from the field inspection data.

Posted in 🤔 Advice and tagged , , .
Share

Related Posts

  •
    June 5, 2019

    Automating workflow in a photography business

    Additional details of question: I run a volume photography business, and I need a piece of software that will let me automate workflow. I need to start entries with a form, and take them through an editing, and then a QA workflow which requires I update the database through additional forms. I’d also like to …

  •
    July 18, 2018

    What is the best reusable checklist software?

    Plenty of software programs allow you to create project templates or manually create checklists from tasks that you need to do. What you’re looking for is reusable checklist software that can be used over and over to rerun checklists & processes. We’d recommend that you look into: Generous Apps Reusable Checklist List – the comprehensive …

  •
    May 4, 2019

    Turn your inbox from a to-do list into a place to triage

    For many of us, you’ve got some control over your inbox for the majority of your workweek but you sometimes resort to leaving messages in your inbox as a defacto to-do list. Kind of like how you leave your voicemails with their red dots, your text messages unread and leave things on the kitchen bench …

  •
    September 24, 2018

    Scheduling Appointments

    To decide whether to schedule appointments yourself or automate this process, you’ll need to look at whether this is a part of the business conversation where you’re adding value. Let’s look at a few factors to decide whether to do it yourself or automate. Add Value (DIY) If your current process is to have a …