Admin adding collection rows on behalf of users

Discussion Ask a question
, ,
1

I find myself needing to insert rows on behalf of my users. I am selling a product, and each one needs to come with a unique identifier (UID). I want to be able to display the UIDs for each of their purchased products in the “My Orders” page of their account. I have surmised that I am able to filter database collections by “Owner:Logged In User”, so in that way, I would be able to use a repeater to display all UIDs associated with the logged in user. However, I cannot find a way, as an admin, to insert new database rows with custom Owner column values.

I cannot have my users submit forms to create these rows under their Owner ID, because that gives my users too much power. They can only have 1 UID for every 1 product purchased.

Do I create an admin-only page with a password, and create a form on there to insert database rows? If so, how do I set the Owner to someone other than me?

2

Or if there is a way so the admin doesn’t even have to do that, it would be great. I thought of trying to somehow take store orders as an input and assign UIDs to each item. But I would need to:

  1. Figure out how to hook into the store orders
  2. Add a field for the UID in that collection
  3. Some orders are for 3, 10, or 50 units. I would need to create rows for each unit, even though there would be only 1 row per order. So I would have to identify the orders of 3x, 10x, and 50x products, and then multiple those rows somehow
  4. After all that, add the UID. Then I would finally have a UID for each unit for each user, with their Owner ID assigned… And it would be all automatic which would save Admin a lot of hassle for scaling. If this is possible, please let me know! I look forward to learning from some seasoned Wix Code veterans.