Create one workflow to trigger a dynamic number of actions based on repeating group

fourcastcreative · 2024-11-16T15:53:39.906Z

I’ve created a repeating group that displays a dynamic set of questions, based on search results accounting for parameters like user and role. Each cell in the repeating group will have a question number, the question text, and then a field to enter the answer to the question. What I’d like to do is have one button on the page that creates a new data-item for EACH cell in the repeating group – which would include the user info, the topic of the question set (which will be noted at the top of the page), the question number, and the answer entered into the field. I should then be able to generate a different view to show a repeating group summary-report of how this user answered each question regarding the specific topic.

My question is – if there are input fields in a repeating group, is there a way to trigger one workflow to create a new separate data-item for each repeating group cell?

fourcastcreative · 2024-11-16T18:49:32.771Z

I realize more detail may help:
This is a job application questionnaire. I’m setting it up so hiring managers can go to a form submission page to create their own standard interview questions. The user enters the question text, then selects from a drop-down if the response should be a Yes/No, free-form text, or choose from a drop-down (and if so, a multi-value text field is available to enter the possible responses. All of this “per-question” data gets saved as a row of data in the table, along with the hiring manager’s ID. On a separate page, there is a list of applicants. clicking an applicant will navigate to a questionnaire page where that manager’s questions are displayed in a repeating group. Each hiring manager goes to the same page, but the questions displayed are different based on the search results for the manager’s own questions.

NOW, I’d like for the manager to fill in the answers to the questions using fields included in each repeating group cell, but this where I’m getting stuck. I’m thinking the greatest flexibility would be to have a data table to log the answer to each question, which includes the applicant and the manager as data points in each row. In other words, one row in the table per question. That could end up becoming a lot of rows, but will that be a problem? This issue with this model is I don’t know how to trigger one save workflow to create a new entry in the “question-answers” table for each question in the RG.

Alternatively, I could create a massive table with columns to hold up to about 50-100 responses, and then have a hard-cap on the number of questions each manager can create.

Or is there an even better way to accomplish this?