I’m trying to figure out a solution, most likely by combining multiple Google Sheets, for creating an accessible user database that also protects anonymity. Here’s what I have/need
Right now, the user database auto populates from a Google form (survey) online that people manually fill out. It includes name, phone number, email, and a variety of survey questions. Different projects have their own form and each form populates its own sheet
I want to combine all the data in a publically accessible/editable spreadsheet that does not have user names, emails or other identifying info
Each row (user) is continually updated with new columns as the user takes actions or we contact them. Different sheets will not always have the same columns (though they could)
If i use the IMPORTRANGE function to combine sheets, I'm worried it wont work as i move around and add columns from different sheets feeding into the single public one.
I would use Airtable or some other typical user database, but I want it to be easily edited/viewed by non data scientists, so a more traditional database wont work.
Is there a way to dynamically combine sheets? or use one sheet that can protect/hide some columns?
Thanks and let me know if i can make this question more clear.