Generous Work
  • Home
  • Service Packages
  • Training
  • Testimonials
  • 1%
  • Blog
  • Contact
  • 0

I need a database created for field inspections

By Rich Peterson on August 8, 2018

Further details of question

I’m thinking of creating a Microsoft Access Data Base to record site records for field inspections. Is this the best option?

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

You could set up your files in Access or using Airtable but you may also want to look at setting it up using a tool like iAuditor to automate the report-creation process. You should be able to do what you want on the free plan and you could have reports sent to your Dropbox via email upon completion. Final option would be to have a custom app set up in Podio with the output being a pdf document created using Globiflow or having the information flow, via Zapier, to Webmerge to pre-fill a Word document.

airtableglobiflowiauditorpodiowebmergezapier
Posted in 🌅 Now.
Share

Search Blog

PreviousWhat’s the best modern recruitment agency software to use?
NextThe near-perfect onboarding outreach email

Related Posts

  • weebly developer australia
    November 17, 2016

    Why be a Weebly Designer in Australia?

    I recently put together a short course on all the top hosted website builders that you can use to develop your website. The main reason for creating the course was to save people time in evaluating the hundreds of options for developing an easy-to-manage website. Some of my main findings were: You often have to compromise on …

  • getting things done
    June 19, 2018

    Fundamentals: Next Action Step

    David Allen, the author of Getting Things Done, coined the term to describe one of the core steps of his “fundamental process”: Write down a project or situation that is most on your mind at this moment. Now describe in a single written sentence your intended desired outcome for this problem or situation. What needs …

  • lingoasset 2
    December 21, 2017

    I hate email marketing but want to publish a free newsletter

    I feel your pain on this one. Although it’s become so much easier to create and send out email newsletters using tools like Mailchimp, Mailmunch, Convertkit and Drip, it’s still quite fiddly to look through all the specs, work out the pricing (do I pay per list or per subscriber?) and then look at the …

  • woman sitting on brown stool 374054
    October 12, 2019

    Paint two pictures

    Paint two pictures. The business x10 with your current systems and the business x10 with different systems choices. There are some insightful tools that a systems adviser uses to help you see your business from different angles and perspectives. Using these tools, they can give you a snapshot of how your whole boat sails today …

  • 🏠 Home
  • 💁 Training
  • 📱Contact
  • © 2023 Website built with ♥ in 🇦🇺
  • Home
  • Service Packages
  • Training
  • Testimonials
  • 1%
  • Blog
  • Contact