Override _owner ID with original member's ID

Ask the community
, , ,
1

Hello! I am currently designing a Real Estate website. Members are able to send property forms to a beforeverification dataset. Then I check and correct them from an admin dashboard i designed for this purpose and once finished I press a button to send that propertie from the beforeverification dataset to the final dataset which displays all properties in the search dynamic page. However, when I correct and send the property from one dataset to another the _owner field changes to my owner ID. Which code could I use in a beforeInsert hook to override my owner Id with the original member’s ID?

I have read EVERYTHING posted so far in the corvid forum however haven’t find a solution for this especific case yet since I stuggle with code.

Thank you in advance!

2

What are you moving from database to database?
Why don’t you add a status field, and when you confirm, change the status to true and filter a site that will only display those whose status is true.
It’s the simplest way with only a small drawback, if you have concerns about malicious users breaking into the site and entering information with true status

3

Thank you very much for your quick response. I move the row of the property a member send from one dataset to another when corrected (thats a way I found in another corvid post). I thought about the option you propose as well, however I dont know how to do it. Would appreciate a lot if you could help me with the code. I imagine I’d had to do an onClick function for a button? Thank you again

4

How do you upload the information to a database? In the code?

5

I designed a form for members to submit their houses to the dataset, and I designed as well other forms in my dashboard to 1. View (read) 2. Modify (read & write) 3. Send houses to the dataset myself as admin (write) and 4. Verify member properties (read & write)

6

I’m having a little trouble understanding what you just did.
You will add a field in the boolean database
And this field do not let the surfers enter, and only on your management page will you edit these fields and add an input field to that field.
Then on the page when you view the database, you will add a filter to this field if you have difficulty creating the code for the filter I will prepare for you.

7

I apologyze for the confusion. I was trying to explain the different ways I use to upload info to the dataset. Anyway, yes I would like to proceed with your option. I already added a boolean status field in my database which only I can access from my management page. So indeed, what i need help with now is the code to display only the rows which have the status field set to true :slight_smile:

8

If I understand correctly that you are using a dataset then you do not need code for the filter, you can enter the database settings on the display page and then make a filter there.
Anyway, you also attach code to filter it.
You will of course need to match the name of the field

import wixData from 'wix-data';
$w.onReady(function () {
    $w("#dataset1").setFilter( wixData.filter()
  .eq("status", true)
);
});
9

Thank you! I will try it out!