In case anyone is looking at this post - the simplest way is:
In your single Excel/Google column, use a comma to separate your tags (eg family violence, child protection) - don’t have tags with commas in them and trim whitespace so you don’t have ext...
I agree that some form of data validation is really necessary, especially for the email/phone number fields. Another use case I have for it is to ensure that people accurately put in the dates/times (eg, when filling in a timesheet, that they cannot ...
I agree with all the comments above. My use case is that I have a directory of services for our organisational members. I want to give them access to edit some, but not all of the data. Like most of the others, I think simply allowing the ability to ...