How to Copy Record and Copy Children
My QB has a table of "Invoices". Each month the users "copy" the invoice for the new month. Most fields stay the same, including a list of children "Lines". When they copy an invoice, the child lines...
Forum Discussion
When you go into the CopyMasterDetail "wizard" it will ask you how you want to set it up. You can either set it up so that you "copy" the record you're on and all the children from its relationships or you can set it so that it will copy a "specific" parent's child records.
In your case, I imagine that you will want to "copy" your Invoice from one month to the next with all the children in tow; and then just modify the Invoice details (like the Invoice # for example).
When you finish setting this up, QuickBase will create a button for you in your table (you get to name it as part of the setup). You then put this on your Invoices so you can copy them when you want to. If you choose "this" setup; I recommend also creating a dedicate text-field in your Invoices table called [Copy]. So when the feature copies your invoice and line items; that the "Copy of" text can go directly into this field instead of a valid-data field which it would otherwise do.
If you then need some kind of "dynamic" Invoice Numbering method; you will need this to work from some kind of formula which probably would reference/include the Date somehow and the Record ID# of the Invoice that gets created.
This is actually the perfect native solution for your needs; if you need help working through it in your App, I'm sure that Matthew, Mark or myself can help - I see that you were having trouble finding your Invoices table in the drop down.
In your case, I imagine that you will want to "copy" your Invoice from one month to the next with all the children in tow; and then just modify the Invoice details (like the Invoice # for example).
When you finish setting this up, QuickBase will create a button for you in your table (you get to name it as part of the setup). You then put this on your Invoices so you can copy them when you want to. If you choose "this" setup; I recommend also creating a dedicate text-field in your Invoices table called [Copy]. So when the feature copies your invoice and line items; that the "Copy of" text can go directly into this field instead of a valid-data field which it would otherwise do.
If you then need some kind of "dynamic" Invoice Numbering method; you will need this to work from some kind of formula which probably would reference/include the Date somehow and the Record ID# of the Invoice that gets created.
This is actually the perfect native solution for your needs; if you need help working through it in your App, I'm sure that Matthew, Mark or myself can help - I see that you were having trouble finding your Invoices table in the drop down.
Thank you. That might all work if I can find Invoices in this list.
It looks like your screen shot is different than mine. How did you navigate to that view? I navigated via: Home -> Settings -> App management. -> Copy master & detail records. Attached is what I see, which is different than what you've attached. Any ideas?