Thanks so much for your help Ahmad.
I’m familiar with server modules and have tried the code don’t it quite suits my application. I don’t think I’m explaining myself properly. Let me give it another go.
SCENARIO:
I have a collection called “additionalProfile”. This collection will be use in a public (visitor) facing table.
To access the form to complete each field in the “additionalProfile” collection, each person will need to sign up as a member to my site. To do this I have set up the native wix member area (PrivateMembersData). Once a member they will need to navigate to a custom private page (“Additional Profile”), setup in the members area. Here I would like them fill out and the form which will submit to the “additionalProfile” collection.
PROBLEM:
Naturally I would only like the current member to add and edit their the item that is associated with their userID (when creating a new item). Additionally I would like the form to be READ/WRITE. The issue is the member can’t begin the form because there is no item in the collection associated with their userID. Hence all the disabled input fields in READ/WRITE mode.
SOLUTION:
I believe the solution would be:
On sign up, using the native wix member login. A function is called to create a new item in the “additionalProfile” collection. The new userID and .nickname is copied across into the item. This would now give a user reference in the collection and enable all the input fields to complete the form.
Unfortunately this extends beyond my coding skills but I really appreciate your input.
I’m not even sure it’s possible but it looks like your on the right track.
P.S. I did also have the idea of starting the “additionalProfile” dataset as WRITE and have some code check the the collection onLoad for an item with the some userID as the logged in user. Then change the dataset to READ/WRITE if true.
Though I suspect this would reduce load speed when the collection gets bigger.