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.
Great question. It can be hard to run a marketplace for expensive items as I feel like people have a threshold for the amount of money they’re comfortable risking online through payments. Most people started with buying books online then built up their tolerance to risk through more successful transactions. Credit card refunds and Paypal …
Getting quality reviews is notoriously hard. Getting a large quantity of great reviews is even harder. Most review websites showcase the extremes – the customer who had the outstanding experience and the once-off, disgruntled customer who will never come back to your business again. We started thinking about this problem by asking the following questions: …
Looking for an easy way to plan out your sales meetings for the week and avoid traffic? One system we set up was using a combination of a route planning app and a appointment calendar app (in this case, Acuity Scheduling) to cut down on the time that sales staff were spending in traffic. The …
I need a database created for field inspections
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:
Each site item will have:
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.
Related Posts
How can my marketplace build trust when selling expensive services?
Great question. It can be hard to run a marketplace for expensive items as I feel like people have a threshold for the amount of money they’re comfortable risking online through payments. Most people started with buying books online then built up their tolerance to risk through more successful transactions. Credit card refunds and Paypal …
Are you looking for better online reviews for your business?
Getting quality reviews is notoriously hard. Getting a large quantity of great reviews is even harder. Most review websites showcase the extremes – the customer who had the outstanding experience and the once-off, disgruntled customer who will never come back to your business again. We started thinking about this problem by asking the following questions: …
How do I plan out my sales appointments to avoid traffic?
Looking for an easy way to plan out your sales meetings for the week and avoid traffic? One system we set up was using a combination of a route planning app and a appointment calendar app (in this case, Acuity Scheduling) to cut down on the time that sales staff were spending in traffic. The …