How can I automatically link a database to site contacts so I know who added information?

Ask the community
, ,
1

Hello,

I am creating a website where I spotlight artists from my area. I have two types of memberships:

  1. Patron - I’ve used Wix’s built-in membership area for the basic login functions. I don’t believe Patrons will need more than this.

  2. Artist - Artists not only get a built-in membership area, they also get a special portfolio page that I’ve made a dynamic page for - separate from the Members Area. This is the problem.

Upon sign-up, artists fill in their information such as a bio, links to their portfolios and Instagram, etc with a Custom Form page. This page is connected to the ArtistPortfolio Database I’ve created.

The ArtistPortfolio page does techically track the database authors, but I have no idea what to do with a _owner ID. It looks like a big, randomly generated string of numbers and letters. I don’t know how to use it. This is a problem, because I was previously using Google Forms to collect info from artists. I need to upload pre-existing members to the ArtistPortfolio database, then link each one with site logins that the artists makes??? I don’t know how to do this with the current system.

I tried adding a Reference Field to the login database to connect the two, but it doesn’t automatically update with each user. I would have to manually choose who owns the line in the database using a drop-down menu that shows everyone who has a login, which is inefficient.

I tried adding the portfolio page to the Members Area but for some reason I can’t get the custom members pages to display the portfolio images and inputs…

I’m really struggling with this because I don’t know any coding. I really wish I could pay someone to do this for me but I don’t have any money, and the site is going to be for a non-profit :confused:

2

I can help, Certified Velo Developer here…

Hit me on workspace.psr@gmail.com

Have a Good Day :slight_smile:

3

Thank you for replying. I appreciate your time and expertise.

EDIT: I edited this comment to clear up a misconception I had about Priyraj being a possible scammer. I’ve been on high alert lately due to a high number of scam artists reaching out to me on Instagram, among other websites, and I jumped to some conclusions during an email chain with Priyraj.

4

To automatically link the database entries in the ArtistPortfolio to the site contacts and identify who added the information, you can follow these steps:

  1. In your ArtistPortfolio database, make sure you have a field that stores the unique user ID or email of each artist. This will be used to link the entries to the respective site contacts.

  2. In your Custom Form page where artists fill in their information, include a hidden field that captures the user ID or email. You can use Wix Code or JavaScript to populate this field with the current user’s ID or email upon submission of the form.

  3. After artists submit the form, the hidden field will contain the unique identifier for the artist. You can now establish a connection between the ArtistPortfolio entry and the respective site contact using this identifier.

  4. In your ArtistPortfolio dynamic page, create a dataset connected to the ArtistPortfolio database.

  5. Add a filter to the dataset to only display the entry that matches the current user’s ID or email. You can retrieve the user ID or email from the hidden field on the page and use it as the filter condition.

  6. Now, when an artist logs in and visits their portfolio page, the dataset will display their specific information from the ArtistPortfolio database entry that matches their user ID or email.

By implementing these steps, you can automatically link the database entries to the respective site contacts, ensuring that you know who added the information.

Additionally, you can populate the hidden field in the Custom Form page dynamically with the current user’s ID or email, making the process more efficient.

Regarding the issue you mentioned with displaying the portfolio images and inputs on the custom members’ pages, it’s important to check the specific settings and configurations of the dynamic page and the dataset.

Ensure that the dataset is correctly connected to the ArtistPortfolio database and that the necessary fields and elements are properly mapped.

If you encounter any difficulties or require further assistance, you can reach out to the Other Community Members. @irelblu

5

Dear Blue,

I apologize for any confusion or inconvenience caused during our previous interaction.

I genuinely intended to help you with your concern, but due to my busy schedule on the Velo Project (Link:https://www.wixcoaching.com/quiz-system), I may have overlooked some details.

I understand your frustration about having to explain everything again, and I sincerely apologize for that. That’s why I simply asked you to resend the forum post so that I could gather all the necessary information to provide accurate assistance.

I want to assure you that I am not involved in any fraudulent activities.

My intention has always been to offer genuine support and help resolve any issues or questions you may have.

If you still require assistance, you can reach out to other Community Members.

Thank you for bringing this matter to my attention.

To anyone who wants to see the Velo Project I was working on, you can. Checkout this App that I’ve completed recently.

Quiz App: www.wixcoaching.com/quiz-system

1080×2159 224 KB

Alternate Link: (for Quiz App) https://psrathore108110.wixsite.com/custom-solutions/quiz-system

Other Projects: https://www.wixcoaching.com

Best regards,
Priyraj Singh
(Certified VELO Developer)

1358×1080 116 KB