Database help

Ask the community
, ,
1

Hi,

Three questions:

1)When you create a member platform, and a member submits a form, how can you make sure the form is linked to their user ID, without the member having to input that information?

  1. If a member A submits a form asking for a lesson from another member… how can I create an input, where the dropdown information is a list (or allows you to search) for the other members. I want member A to only be able to select the name/email/or some unique identifying factor of another member. And how might I do this if I have 2k members?

3)How do I link a form submission to a members ID? So, for example, if a member A submits a form registering for a lesson provided by member B and 2 weeks later member A submits a form registering for another lesson from member C , I want to be able to track each of these exchanges in the database, but I want to make sure the database is inputting the data based on the users ID.

Many thanks!

2
  1. this is done automatically. If a member submits data, his Id is set in the field _owner (Content Manager, show hidden fields)
    2)you will need to add a “members area” page to your site. This will automagically add a collection “PrivateMembersData” to your left db-pane. This, you can query.
    3)do not understand
3

Thanks Giri!

  1. To confirm, if I am logged in as a member, and I submit a form, the form automatically tracks that I am the one that submitted the form? Or is there something I need to do to ensure that the form is linked to the member ID.

  2. I have a member only page. When you log in, you fill out a form. One of the elements of the form is a drop down menu. I want the drop down menu to let you select from a list of other members. How do I do this?

4

1)part 1: yes. Part 2)no. If there is a logged in member, Wix wll put this id into the _owner field. IF user in not logged in, field will be blank.
2) as I said. If you add a Members Page to your site, this will also add a “PrivateMembersData” to your left db-pane. It´s a read-only collection of your Members. which you can query using wix-data “query”.
If you don´t want the Members page showing up on your site, just menu-hide it.