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.
Looking into sales dashboard software that can connect to various data sources. Some options include: Geckoboard Klipfolio Blitzrocks Plecto Boxiqq Comparing a wide range of sales dashboard options showed me that it’s hard to find a simple software program that isn’t enterprise in pricing or look, that has the basic features + a few extra …
For context, I was looking at CRMs for clients and thought I’d found the best CRM for my needs in a flashy, expensive CRM that did everything including walking your dog and making your breakfast. It wasn’t until I’d dived into the software that I found it didn’t fit my style and visibility needs. Too …
If you’ve ever done an internet search for “beautiful project management software”, you’ve probably come across Asana. It’s one of our top 12 project management software systems in terms of design alongside Basecamp, Solo, Airtable, Process St, Roll, Pipefy, ClickUp, Flow, Sunsama, Ora and Roadmap. All beautiful software that your designers, and your eyes, will love. …
Further details of question We currently manage a large database of property developments in an excel file, but we need to migrate this to a bespoke database, which will give us more flexibility to build our business processes around the data, and to add more columns and related items, such as photos, files, notes, version …
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
Business Dashboard Software For Tracking Sales Commissions Comparison
Looking into sales dashboard software that can connect to various data sources. Some options include: Geckoboard Klipfolio Blitzrocks Plecto Boxiqq Comparing a wide range of sales dashboard options showed me that it’s hard to find a simple software program that isn’t enterprise in pricing or look, that has the basic features + a few extra …
The near-perfect onboarding outreach email
For context, I was looking at CRMs for clients and thought I’d found the best CRM for my needs in a flashy, expensive CRM that did everything including walking your dog and making your breakfast. It wasn’t until I’d dived into the software that I found it didn’t fit my style and visibility needs. Too …
People love Asana: Is it right for your business?
If you’ve ever done an internet search for “beautiful project management software”, you’ve probably come across Asana. It’s one of our top 12 project management software systems in terms of design alongside Basecamp, Solo, Airtable, Process St, Roll, Pipefy, ClickUp, Flow, Sunsama, Ora and Roadmap. All beautiful software that your designers, and your eyes, will love. …
What software should I use to build an online property development database?
Further details of question We currently manage a large database of property developments in an excel file, but we need to migrate this to a bespoke database, which will give us more flexibility to build our business processes around the data, and to add more columns and related items, such as photos, files, notes, version …