Support » Plugin: Participants Database » create relationships between users?

  • jasonjasonjasonjason

    (@jasonjasonjasonjason)


    Is it possible to create relationships between users? Imagine an Alcoholics Anonymous-type scenario where some members sponsor other members, and those sponsors also have sponsors. Some sponsors have multiple sponsees. Could this be set up in Participants Database?

    I’m imagining a field that titled “sponsor” that could be linked to another member. And another field titled “sponsees” that could be linked to multiple other members. But maybe that’s not how databases should be set up? Maybe an entirely different table needs to exist to track those relationships? Sorry, my database knowledge is pretty rusty.

    Thank you,
    Jason

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    The plugin doesn’t have this kind of capability built into it, you would need to create it yourself. It is possible, the plugin provides an API that gives you the hooks you need to expand the plugin’s functionality.

    For example, it is possible to build a selector that provides a list of other records in the database so that an association can be established. I have an article that explains how something like this can be done:

    Populating Selector Options from the Database

    • This reply was modified 3 months, 1 week ago by xnau webdesign. Reason: added the link
    Thread Starter jasonjasonjasonjason

    (@jasonjasonjasonjason)

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.