Generous Work
  • Home
  • Blog
  • Contact
  • 0
  • 0
press Enter to search Showing all results: No products found.

    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

    About

    For the past 10 years, we’ve worked with hundreds of clients and tens of thousands of students to help them get a clear picture of how to systemise their business. We’re not fans of spam, cheap mass-marketing tactics or automating your business to within an inch of it’s life. We are fans of a customer experience where humans deal with humans, skills are appreciated, personality is maintained and where clients get more value than they expected. We’re also fans of automating any process that doesn’t deliver client-facing value in a simple, easy-to-maintain way.

    In a nutshell, we provide advice, implementation support & training to small to medium, service-based businesses to help them deliver a better customer experience & a more automated workflow. Everyone on the same page, moving in the same direction with a clear picture of who does what.

    Want a streamlined business?

    Subscribe to get our latest advice, courses and project updates in your inbox.

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

    Related Posts

    • July 17, 2018

      Software for display screens & digital signage in your office

      Have been looking at digital signage software options that are simple to use and don’t cost the earth. Before checking out the options, I thought that some simple options might be free with a reasonable upgrade cost being around $10 – $20 per screen per month or perhaps a once-off cost of under $200. Let’s …

    • July 25, 2018

      The ROI on a more automated onboarding experience

      If you’re a believer in first impressions then you’ll know how important it is to onboarding new staff members well. You want new staff to bond with current staff and to get a broad overview of what they need to do and how they’ll do it. The onboarding experience for new staff doesn’t have to …

    • September 24, 2018

      Results: Doubled online reviews

      How easy is it to double the number of online reviews your business has? Not as hard as you’d think when you fix the leaky bucket that is the current process for most businesses. For one of our clients, they’d been using a NPS survey to monitor their key staff and how well they were …

    • January 21, 2019

      Why you do mindless busy work

      Grab a coffee, it’s late Friday morning and you’re getting admin done. Scan the forms, update the spreadsheets, send emails and make some phone calls. There will always be some mindless busy work but, if you’re like 90% of the population, you’re doing too much. Your hourly wage isn’t producing a sustainable ROI and your …

    • 🏠 Home
    • 📱Contact
    • © 2021 Website: design, hosting, theme.
    • Home
    • Blog
    • Contact
    • Wishlist 0