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 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 …
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 …
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 …
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 …
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
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 …
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 …
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 …
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 …