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

Question

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.&nbsp;
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?&nbsp; 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.&nbsp; 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 FamilySmartBC, Canada------------------------------

markshnier__you · Answer

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.&nbsp;&nbsp;

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.&nbsp;&nbsp;
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jenniferjuhasz · Answer

Thank you Mark!&nbsp; I'm relieved that I was on the right track with how to set up the different tables.&nbsp; I'm hoping to puzzle this out today; I had everything up to the 'Search' step.&nbsp;
I have a parent table for standardized workshops
A child table where I have the workshops set by schedule with their individual sessions set up and created a check box to mark which 'session' is the 1st one that we register for.
My Pipeline is set to trigger when we register a guest for the first session in a workshop series.
I think I even set up the search correctly, but then wasn't sure how to take the next step 'For Each Loop' create child workshop sessions for the attendee.&nbsp;
I'm hoping to puzzle this out this afternoon - and will likely come back with more questions. :)
Thank you as always for your guidance!&nbsp;
Take care,
Jen------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------

markshnier__you · Answer

Ok, when you come back with questions or else even now can you say what your relevant tables and their relationships, like which is the One and which is the Many.

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

jenniferjuhasz · Answer

Hi Mark,

Well - yay - I got it to work... a&nbsp; little too well...&nbsp; How do I end the 'loop'?&nbsp; It just kept creating new records.&nbsp; I can't seem to get the option to 'Stop Pipeline' to come up as an option for any of the steps.
You asked me to explain my table hierarchy/relationships.

PARENT TABLE 1: Workshops (Here is the name of the workshop and the 'schedule' such as Tuesdays/Thursdays 12-1pm) is parent table to &gt;&gt;
PARENT TABLE 2: Session Name (A simple list of the different individual sessions or topics for each workshop, not scheduled, just the names) - There can be many Workshops with these sessions.
PARENT TABLE 3: Facilitator Names (staff names) who lead the workshops. - There are many Workshops for each facilitator.

CHILD TABLE - ** Workshop Sessions (this is the breakdown of the individual sessions for each workshop), there is a Workshop Series ID, these are scheduled.&nbsp; &nbsp;The 1st Session of each series is marked with a checkbox as the 'start' of the series.&nbsp; For each Workshop there are many sessions.
So for example: Workshop A has 2 Sessions, and 1 Facilitator, occurring on Tuesdays at noon in August, August 1st and 7th.
Workshop B has 2 Sessions and 1 Facilitator, Occurring on Wednesdays at 6pm.
Workshop C has 4 Sessions and 1 Facilitator, Occurring on Tuesdays at 9am.
These will repeat each month - so a new Workshop Series is then scheduled each month.

Finally - we have the Child-Child Table - this is the actual registration table.
Staff complete a form to register a family for a workshop.&nbsp;
They tick the box 'Register for the series'.
on 'Save and Submit' the Pipeline is then triggered to create additional records in the registration table for the remaining 'Sessions' of the Workshop Series.

However - I can't figure out how to tell the Pipeline when to stop.
In the screenshot below, you can see I've tried to create a condition that says "IF the Workshop Series ID equals A and B; AND IF the Session Name equals in A and B...&nbsp;
Then I want it to STOP.
but the option to STOP does not come up.&nbsp; Why?

------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------

jenniferjuhasz · Answer

Hi Folks,

Just thought I'd try again - does anyone know why the option to 'Stop' the Pipeline isn't appearing for me?&nbsp; I assume it's something really minor, that I've just missed a step somewhere, but I'm not seeing it.

Thanks, in advance for any guidance!------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------

Forum Discussion

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

5 Replies

Related Content

Pipeline API Post

Same reference field, different selections within the form

Pipeline Make Request - Return Make Request JSON Output into fields

Pipeline Excel Export Treating Numbers Differently

advanced query in a pipeline

Recent Discussions

Current URL Display without JavaScript

Remove the save button when from new forms format when applying I-forms (IFV=1) #354382

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting

APP - Communications

Kanban WIP Limits