I'm thinking of using Zoho Creator to give my vendor-clients the ability to manage a publich facing profile that our customers can view. In some ways I envision it being something like facebook, but without all the permissions issues. I simply need to create a long form that all vendor-clients complete, and maintain.
We currently track about 100 different attributes about each vendor (like whether they have upgrades, cost, bolt on products and such) and with over 200 vendor-clients I'm looking for ways to automate our currently manual process of updating and tracking those attributes.
The problem I see right now is that if I create one form, I cannot seem to figure out how to give each record (vendor client) access to just their record. I don't want them to see the records for all of the other vendor-clients we have in our network. Do I need to maintain a separate form for each vendor-client? And, if so, how can I manage global additions/deletions to the attributes list we track?
Looking for recommendations on how to build this.