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.
Further question details We are a growing accounting firm that is focused on providing our clients with the best bookkeeping and tax experience possible, we are paperless, tech-savvy and we think outside the box. We operate with a start-up mentality where we constantly adapt to our clients and move very quickly. We’d love to automate …
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 …
It’s been interesting looking at the systems behind gift cards, gift vouchers and generally sending some kind of credit to someone else through your website. It looks like your main options for allowing people to order gift vouchers or cards through your website are: They fill in a custom form (built using a custom form …
This is such a huge need for real estate and insurance professionals, to be able to grab a map and pin content onto the map. You might even want to upload an image or map and then mark out areas that display a pop-up when you hover over the image. The software that I’d recommend …
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
What software can I use for automating our Operations department?
Further question details We are a growing accounting firm that is focused on providing our clients with the best bookkeeping and tax experience possible, we are paperless, tech-savvy and we think outside the box. We operate with a start-up mentality where we constantly adapt to our clients and move very quickly. We’d love to automate …
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 …
How to manage gift vouchers online?
It’s been interesting looking at the systems behind gift cards, gift vouchers and generally sending some kind of credit to someone else through your website. It looks like your main options for allowing people to order gift vouchers or cards through your website are: They fill in a custom form (built using a custom form …
I need to make a map interactive and add pop-up labels to it
This is such a huge need for real estate and insurance professionals, to be able to grab a map and pin content onto the map. You might even want to upload an image or map and then mark out areas that display a pop-up when you hover over the image. The software that I’d recommend …