Hi
I need to create a form (either in word or in excel) to collect the findings of confidential safety reports, that will feed directly into an excel spreadsheet. Anyone in the organisation should be able to click on the form, fill it in with thier particular report and then submit it, so that it is entered directly in to the confidential database (hidden from thier view).
This would be relatively easy if they didn't need to recall the information back out... However ...
- often these reports need to have information added and changed by each individual author..AND,
- They should only be able to view and edit the information that they themselves have submitted as each report is confidential.
I hope this makes sense?
I was wondering if this is within the realms of word and excel? If it is not possible - i need to start looking for other solutions.
Many thanks in advance.
I need to create a form (either in word or in excel) to collect the findings of confidential safety reports, that will feed directly into an excel spreadsheet. Anyone in the organisation should be able to click on the form, fill it in with thier particular report and then submit it, so that it is entered directly in to the confidential database (hidden from thier view).
This would be relatively easy if they didn't need to recall the information back out... However ...
- often these reports need to have information added and changed by each individual author..AND,
- They should only be able to view and edit the information that they themselves have submitted as each report is confidential.
I hope this makes sense?
I was wondering if this is within the realms of word and excel? If it is not possible - i need to start looking for other solutions.
Many thanks in advance.