Discussions

Expand all | Collapse all

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

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

    Posted 04-04-2017 21:24
    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?


  • 2.  RE: Can I filter the records to add when I use the Copy Master Detail wizard?

    Posted 04-05-2017 05:05
    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


  • 3.  RE: Can I filter the records to add when I use the Copy Master Detail wizard?

    Posted 04-05-2017 09:13
    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.


  • 4.  RE: Can I filter the records to add when I use the Copy Master Detail wizard?

    Posted 04-07-2017 04:43
    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...