I need a database created for field inspections

By Rich Peterson
In 🤔 Advice
1 Min read
I

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.

About the author

Rich Peterson

I've spent the last 10 years planning, mapping & reimagining the processes of hundreds of SMBs. Whether the goal is more money, more time, more clarity or more customer smiles, my insightful process is worth every minute for my successful clients.
-----------
Disclaimer: I use affiliate links on my website and only recommend what I use, have used or have vetted in the best interest of my readers. I may earn a commission if you click on an affiliate link, but it won’t cost you extra.

View all posts

Read more

Creating A NameCheap Domain Name Parking Page

By Rich Peterson
In 🤔 Advice
3 Min read
C

📚 ContentsCreate your own Namecheap Domain Name Parking PageSelling your domain through NamecheapCreate your Namecheap Seller PageBonus Points Create your own Namecheap Domain Name Parking Page So, you’ve got too many domain names registered through Namecheap and you’re looking to start selling them. You want to have them listed for sale but would love to have someone looking for your...

Read onRead later

Seth Godin’s WordPress Theme?

By Rich Peterson
In 🤔 Advice
1 Min read
S

So you want to design your blog like Seth Godin’s new WordPress theme? First, the backstory, Seth Godin had his old blog on Typepad for years before moving to WordPress and setting up his website with a minimal WordPress theme, including a simple left sidebar with widgets. Seth’s website design was done by Noah Grubb. Want something close? Try this. Theme Burger Factory (free) by Alex...

Read onRead later

Naturopath Freelance Writer

By Rich Peterson
In 🤔 Advice
4 Min read
N

Question: I’d like to do freelance writing in the naturopath space, any advice? Answer: Sounds fun! I’ll split up my advice into the work you can do for others and the work you can do on your own website. 📚 ContentsNaturopathy freelance writingYour own Naturopath websiteWhat content can I write? Naturopathy freelance writing Some basic steps to getting started in freelance writing as...

Read onRead later

Need Help Setting Up An Interactive Email Campaign System

By Rich Peterson
In 🤔 Advice
1 Min read
N

Question: We’re content creators who are looking to produce ongoing, interactive emails and would like for you to help us set up a more automated system. Some subscribers may join in on an ongoing campaign while others may always start at the beginning of a series. We’re looking for someone who has experience integrating with systems like Typeform, Formfacade and other google...

Read onRead later