Random Pairing in Custom List?

Forums Dynamic Forms for SharePoint Random Pairing in Custom List?

Tagged: 

Viewing 6 reply threads
  • Author
    Posts
    • #24993
      Cassandra Cronsell
      Participant

      Hello,

      I created a Custom List in SP 2013 and use DFFS to customize, that is being used as a sign-up/registration form. The fields it includes are Status (Choice), Participant Name (person lookup) and ID.

      I want to randomly pair Participant Names and want to send an email to them with the pair information once it’s selected. Is this possible?

    • #25005
      Alexander Bautz
      Keymaster

      I’m not sure I understand exactly what you mean. Should for example participant #1 (Cassandra) be matched with #2 (Alexander) and the email tell that Cassandra and Alexander is paired – and write the pairing info to both #1 and #2 so you can see it in the list?

      If this is correct, should the pairing just look for the first unpaired participant so the participant #1 is unpaired until #2 registers and is paired with the first unpaired (#1) and #3 is unpaired until #4 registers and is paired with the first unpaired (#3)?

      Alexander

    • #25007
      Cassandra Cronsell
      Participant

      Yes, that would work.

      For my list, participants could be enrolling (creating a list item) throughout the month so ideally, we would pair them all randomly once per month; but I did not consider pairing automatically as they come in.

    • #25078
      Alexander Bautz
      Keymaster

      Hi,
      Sorry for the delay. It is possible to create this, but unfortunately I’m a bit busy and cannot help you right now, but I might be able to do it next week.

      I guess a solution would be to create a script to put in a web part page where you can hit a button that gets all the list items from the list, randomly pairing them and then writing the pairing information to a second list were you keep track of the pairs. You can then use a workflow / flow sending out emails.

      Let me know if you have any more details and I’ll estimate how much time this will take to make.

      Alexander

    • #31101
      Brett
      Participant

      Hi Alexander,

      I’ve just had this same request from a work colleague.
      Did you end up writing this script to match pairs of list items?

    • #31111
      Alexander Bautz
      Keymaster

      No, I never got around to make this solution.

      Alexander

    • #31119
      Brett
      Participant

      Thanks Alexander, it’s not a priority and I don’t think there will be much response from people to register their interest, like a random pairing meet n greet type scenario, so it was only if you had it ready to go.
      Thanks.

Viewing 6 reply threads
  • You must be logged in to reply to this topic.