I have a property content type. I'm wanting to add a property code column which will look up the codes from somewhere else on a SharePoint Online site, where it can easily be managed by end users.
I initially implemented this having a lookup column pointing to a custom list. The issue with this solution was:
- No search function (Within other browsers apart from Internet Explorer)
- Drop down menu so will become impractical when the property list becomes large.
As an alternative I set up a term set with the idea of using managed metadata. This seems like the perfect solution but the one issue that arises is adding additional terms. The property codes are going to be constantly added. The only way I've found to add additional terms to a term set is through the Term Store Management Tool, either manually or through a csv import. Both will be beyond the ability of the site users.
What are my options here? Are managed metadata term sets meant to have constantly changing data?
Any advice much appreciated.