I have a series of online forms and shared spreadsheets that I want to replace with a secure online system. Currently a mix of forms and sheets is used to gather required information to create a group profile and I want to give users the ability to change their information after they have submitted it - up until cut-off dates.
There should be 3 types of user. An administrator can create stages, groups, managers and users. A manager is linked to each stage and should be able to create a group account and send an invite to a user to manage it. The administrator should be able to set individual cut-off dates for each of the forms after which they cannot be edited. The user should be able to manage more than 1 group. A manager should be able to manage more than 1 stage.
The Group Profile is built up using the following:
The first form is a google form with Group BIO, contact and background information (including how members of the group there are). Once submitted this information can only be edited by the administrator.
The second form is marketing information, including links to social media sites and the ability to upload photos to Google Drive.
The third form is technical information with the ability to upload pdf documents to Google Drive. Currently a Google form is used.
The fourth is an accreditation list for group members based on the number of members listed in the first form. To date a protected shared spreadsheet is used to gather Names, Contact Details, Emergency Contacts and Roles.
A final spreadsheet is used to link each group to a stage and allocate a day and time slot. This is not visible to the user and should be done by the administrator.
The system will need to be able to accommodate 500 group profiles and 20 stages. The administrator / manager should be able to verify which groups have completed their information, or whos is outstanding. There needs to be export functions to google sheets/.csv (including hyperlinks to any uploaded files)
The system also needs a GDPR statement and ideally designed to be cloud based (G-Cloud, Amazon, etc)
34 freelancere byder i gennemsnit €201 på dette job
I am sure that I can finish your project perfectly with high quality code and short time. Please send me message so that we can discuss more. Thank you.