I am using salesforce to create portal for a school. I am using students and parents as contacts and staff as users. When I am creating students I need to make it manadatory to collect certain documents. For example: for a KG kid I need to collect birth cirtificate or passport copy. And in case of grade 1 or higher I need to collect Transfer cirtificate in addition to standard Date of birth and ID proof. I see a option to attach documents to contact is there a way to link and mandate these documents? Also can I directly save them to google drive since we have limited space on salesforce wheareas the amount of space ,on google drive, is unlimited for educational institutions.
Also incase of users I want to lock their accounts until required documents are submited. I am also building recruitment module so once they are hires I want to create users autmatically. But I want to make sure their account will not be active until their documents are submited.
THe best solution I came up with is creating a seprate table and having picklist for type of document and upload with rich text field. Is there a better standard to do it?