Generous Work
  • Home
  • πŸ’° Advice
  • 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

  • custom crm developers
    May 16, 2018

    I need a custom CRM web app and database

    Further question details We currently manage large customer and prospect lists in multiple Google Sheets and Excel. We want to migrate this into a cloud database. We do not current have a database setup, so we will need to create one based on an example customer list and handle migration of our lists into the …

  • LingoAsset
    September 6, 2017

    Best Life Coach WordPress Themes

    Doing some research for a client and am looking into life coach WordPress themes that will suit their coaching business. Some of the best ones are: ABC Personal Trainer Theme (details + demo) – top choice for clean design & smooth scrolling WP Coach Theme (details + demo) – more boxy design but clean, minimal …

  • online quiz website courses
    May 14, 2018

    How do I create a membership-based website with online quiz content?

    Further details of question I’d like to setup a website on WordPress but am unsure how to do it myself. The website will have multiple quizzes and members will have to pay to access these, there will be a new one added 3/4 times a year. Members will be able to sign up for a …

  • July 17, 2018

    Business Assets

    From the book, 24 Assets by Daniel Priestley Broadly speaking, people want to buy companies that have a good mixture of assets in seven categories: Intellectual property The business lays claim to, or is known for, valuable ideas, methods or defensible intellectual property rights. Brand assets The business is known, liked and trusted by a …

  • 🏠 Home
  • πŸ’ Training
  • πŸ“±Contact
  • © 2023 Website built with β™₯ in πŸ‡¦πŸ‡Ί
  • Home
  • πŸ’° Advice
  • Training
  • Testimonials
  • 1%
  • Blog
  • Contact