Skip to main content
Question

Pipeline to create 'new' record in same table, but different 'sessions'

Forum|alt.badge.img+7

Hi everyone,

I'm trying to figure out how to create a table of workshop sessions, where if you register for the "first" session, you're automatically registered for all of them. 

I can get a Pipeline to create a new record when you tick the box to register for all sessions in a series, but how do I tell Quickbase to create records associated with that series' of workshop sessions?  I've spent a few hours now in Pipelines reading through the logic sequence, and honestly, my head is starting to hurt trying to make sense of the logic tree.  At no point can I specify 'if box is checked, search for matching session ID, create additional records for all sessions with matching session ID'.

Any suggestions? I realize it's late Sunday evening, and so it's possible I'm overlooking the obvious answer.

Thank you!



------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    I would set up a template table list of all the possible Workshop sessions, each course tagged with the series that they they belong to.

    Then I would trigger a pipeline when a workshop child record is created for an attendee and where the number of Workshop for that attendee is 1. In other words we only want to trigger when the attendee registers for their very first workshop.

    I would search the standard table of workshops looking for records from the same series as the trigger record but where the workshop is not the one that the attendee just registered for.  

    Then a For Each Loop create child workshop sessions for that attendee being sure to connect the attendee workshop records with the attendee from the trigger record so they don't end up being orphans and then populating the workshop name and I guess the Series value.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement