Can I filter the records to add when I use the Copy Master Detail wizard?

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
I would like to be able to filter the records to be added as children (i.e., add only a subset of the child records of the master, based on filter criteria).  Is this possible?
Photo of slloydavant

slloydavant

  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
This largely depends on how your application is set up, 

but most of the time you can add filtering criteria similarly to {FID.EX.Criteria}

So if your field that you want to match is field ID 10, and the match is 1. it would be {10.EX.1}

But you'd have to set up a template for it.

Just some ideas, I don't have a lot of experience using the default "Copy Master Detail" wizard
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
I do not think that there is an option when cinfiguring either the wizard or the API version of the Copy master detail to filter which child records get copied.

I think what I would do is to flag which records need to be deleted using the formula and then create some kind of your URL formula button on the parent which would be pushed after the copy Master Detail is done to mass delete the flag records. So it would be a two-step process.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
After you use the wizard and it creates a button.
What is the formula for that button?  You might be able to put the filtering there...