📥Stop Creating Forms One at a Time: Bulk Creation in Requests, Testing and Audits
FeaturedNote: These tools are available to Data Admins
We all know how a new testing or audit cycle starts. You open a blank form, type the control ID, pick the assignee, set the due date, click create. Then you do it again. And again. By request forty, the details start blurring together and that's where the typos come from.
But did you know you can create an entire population of requests, or a full set of test forms, test phases, and review plans and audits from a single spreadsheet?
Bulk creation is already sitting behind the Create button in Requests, Testing and Audits. Here's how to put it to work this week.
🔒 Yes, You Get to Check It First
Importing hundreds of records at once only works if you can catch problems before they land. You can:
Preview and Edit: Every import gives you a preview step before anything is created. Double-click a field to fix it right there.
Errors, Isolated: Turn on Show rows with errors only to work through just the problem rows, plus sort and pin columns to keep your bearings in a wide file.
Permission-Gated: Bulk creation from spreadsheet in Requests is available in Controls Management solutions. In Testing, it's Data Admins only. With From existing, Data Admins see all existing requests; everyone else sees only what they have permission to.
📝Pro-Tip From Your CSM: Bulk creation from spreadsheet in Requests is available in Controls Management solutions; in Testing, it's Data Admins only.
💡 Put It Into Practice: Different Experiences, Some Easy Steps to Use It This Week
Look for Create in the toolbar of the Requests page or the Testing experience.
1. Import a Full Request Population from a Spreadsheet
The Use Case: Turn a sample selection you've already built in Excel into live requests, in one pass.
The Steps: Requests page › Create › From spreadsheet. Choose your audit program and test phase, Upload your file (or Download template first), then Continue. Preview and double-click any field to fix it, then Create requests.
📝Pro-Tip From Your CSM: Download the template before you build your file. Headings must match the listed headings exactly, and starting from the template is faster than reverse-engineering them.
👉Check out the full support article here!
2. Copy Last Quarter's Requests Into This One
The Use Case: Reuse requests that already exist in the workspace instead of rebuilding a recurring population from scratch.
The Steps: Requests page › Create › From existing. Search or filter, select the checkboxes, and Continue. Define the details — titles, assignees, approvers, due date, evidence dates, then Continue, choose your audit program and test phase, preview, and Create requests.
📝Pro-Tip From Your CSM: No spreadsheet required. If the population is stable quarter over quarter, this is usually faster than exporting, editing, and re-importing.
👉Check out the full support article here!
3. Get the Headers Right the First Time
The Use Case: Most failed imports are a header or format problem, not a data problem. Here's the full field list.
Required: Control ID · Title · Description · Request type · Assignees
Optional: Additional controls · Approver · Due date · Sample column · Sample selection · Evidence request start date · Evidence request end date · Notify others
Four rules that catch most errors:
- Request type must be set as general, population, or sample
- Dates must use the format MM/DD/YYYY
- Multiple values are separated using commas, use full names for assignees and notify others
- Approver accepts only one person
📝Pro-Tip From Your CSM: Control ID must be included for population and sample requests, and can be left empty for general requests if needed. Evidence request start and end dates are only required if the other one is set.
4. Create Test Forms, Phases, and Review Plans in One Import
The Use Case: Create all three layers of a test phase at the same time from a single .csv or .xlsx, instead of building them in sequence.
The Steps: Testing experience › Create › From spreadsheet. Choose test forms, test phases and review plans, Continue, then pick your audit program and Download template or Upload. Repeat for phases and plans, review in the All items tab or tab by tab, use Show rows with errors only to clean up, then Create.
📝Pro-Tip From Your CSM: Work top-down. Test forms must be selected in order to select test phases, and test phases must be selected in order to select review plans.
5. Know Your Test Form Headers
The Use Case: Same principle as the request template. Matching headers is what makes the import clean.
Test forms: Control ID* · Due date · Allowable exceptions · Budgeted hours · Folder
Test phases: Control ID* · Test phase type* · Start date · Due date · Period covered start date · Period covered end date · Sample size · Tester
Review plans: Control ID* · Test phase type* · Review order* · Review type · Review due date · Reviewer
📝Pro-Tip From Your CSM: All test phases default to the first workflow status in your system, so plan to advance them after creation rather than trying to set status in the file.
👉Check out the full article here!
6. Create a Year's Worth of Audits in One Paste
The Use Case: Planning season produces a spreadsheet of audits. Turn that list into real audit forms without opening a single blank form.
The Steps: Audits in the left menu › Create › Bulk Add › From Spreadsheet. Paste your data with ⌘-V or CTRL+V, then click Create.
The columns must match the layout: Audit Name · Location · Risk Rating · Budget · Objective · Lead Auditor
📝Pro-Tip From Your CSM: Once your audit forms exist, set them up by adding groups, phases, and procedures.
📝Pro-Tip From Your CSM: Check the permissions toggle before you click Create audit. Copying from an existing audit carries the original permissions over and makes you an owner. Leave that toggle off and you become the owner while every other permission is removed, which is usually discovered by the team member who can no longer open it. Worth noting too: comments, embedded spreadsheets, and attachments never copy.
👉Check out the full article here!
💬 Let's Trade Tips!
What's the biggest batch you've created in one import? Drop a comment with the workflow you'd most like to stop doing one record at a time.
👀 Already Created, Now Need to Change It?
Form templates let you reshape every related form at once, and bulk edit in Testing updates a whole phase in a single pass.
Have a look into our previous Form Edits post!
👀 Next Up! Make Your Report Show What You Actually Need: Working with Columns
In our next post we will see how you can make the most out of your reports! Reshape them, add to them and transform the way your data is presented!
👉Also, check out our in-app guides for more tips and walkthroughs! Find them by clicking the interactive icon ℹ️inside each experience.
Please sign in to leave a comment.
Comments
0 comments