Here is the current working formula:
It's copying the details correctly but I want to take it a step further. I want it only to create those details IF a checkbox field is true.
Any ideas? Thanks!
IF you need my first answer, here's that:
Making the change to the formula you mentioned should be a pretty straightforward change. I'd suggest something like this:Now, if you're looking to have a checkbox drive which child records should be copied, unfortunately the Copy Master/Detail process can't accommodate this. Fortunately, however, there IS a solution! Using a combination of formulas, the API, and saved Imports from a Table, you can setup a process that is very similar to the Copy Master/Details process, but that will allow you to identify only certain records to be copied.
By using the IF statement:
IF(Criteria,Do This,Else Do This)
you can use "" in the ELSE section to denote a Null value. When the formula is evaluated by QuickBase and the result is Null, the button is not generated. Essentially, it keeps the button from being used, no matter what form or report the field is used on!