Bulk Add Children Records

Question

Hi,
We have a form with a basic parent-child relationship for users to add children records.
Sometimes, the users need to add up to 100 records.
It becomes very tedious to do this 1 at a time.

Does anyone know of a simple way to solve for this that allows users to upload bulk records? I have a fiew ideas, but none of them seem very user friendly and I want this to be something relatively intuitive for end-users who aren't in Quickbase all the time.

Thanks in advance for any ideas!------------------------------Curtis Middleton------------------------------

markshnier__you · Answer

Curtis,
New Forms do allow for adding children, it's just that they will not automatically connect them to the Parent record (ie they do not follow the behaviour of Legacy form in that respect.&nbsp; Certainly if you want a User experience which is easy and foolproof, the Juiced Add on seems like the best solution.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

Where do you propose the data comes form to fill out these 100 records. Are they blank ones (aside from Related Parent) or will they have data whihc needs to be entered as they are being created?

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

curtismiddleto1 · Answer

Thanks for looking at this, Mark!

They would likely have an Excel file. To give you some more context, the end-user has read-only access to a separate system that doesn't communicate with Quickbase. They can export a list of drawings they want from this system, then submit a request to our team to check out the drawings for them to complete edits. Prior, they would just attach this downloaded list to an email, but we are trying to get better tracking on these documents and the system they are held within can't manage a tracking funcitonality. Hence the need for a Quickbase solution.------------------------------Curtis Middleton------------------------------

markshnier__you · Answer

So I gather if you upload 100 documents within that hundred documents they need to be attached to different parents? Does the download know anything about the parents
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

curtismiddleto1 · Answer

Apologies, I may have miscommunicated.
User accesses system A to download a list of drawing #s and sheet #s; 2 fields total. They do not have permissions in this system to check out the actual drawings themselves, so they need to contact our team via Quickbase (previously done via email). To do so, they go into Quickbase filling out request details and then there is an "Add Drawing" button where they can add children records for each drawing they are wanting out of system A. Sometimes they only need a handful of drawings, so the "Add Drawing" button is sufficient. But occasionally the list of drawings can get to 100+ and that would be very tedious for them to add a child record 100 times. So I'm trying to figure out how to enable them to do a bulk import using their excel sheet (or a template provided to them) so they can create these 100 children records and have them all be related to the same parent.&nbsp;
The only inbetween solution I can think of is to make the children report a grid editable report. But if I remember correctly, the new forms in Quickbase do not support that feature currently.
I'd really like to avoid the bulk import if possible because that can just lead to a number of issues and would require instructions and training for users who are not familiar with Quickbase; which would be most of them. But I'm thinking that (or some variation of it) is the only solution, unfortunately.------------------------------Curtis Middleton------------------------------

Forum Discussion

Bulk Add Children Records

7 Replies