Import Records by “matching table and fields”

Idea created by mrwatson-gbs on Jan 6, 2016
    Active
    Score11

    Idea

     

    A new import option “matching table and fields”, which

     

    • dynamically sets the source and destination table names equal to Get( LayoutTableName )
    • matches fields by name

     

    In other words the import is based entirely on the context of the current layout.

     

    Benefits

     

    • Super-simplified scripts for updating solutions, for example:

     

    Go to Layout["Companies"]

    Import Records[$PreviousVersion ; matching table and fields]

     

    Go to Layout["People"]

    Import Records[$PreviousVersion ; matching table and fields]

     

    Go to Layout["Communication"]

    Import Records[$PreviousVersion ; matching table and fields]

     

    Go to Layout["Notes"]

    Import Records[$PreviousVersion ; matching table and fields]

     

     

    Use Cases

     

    • Import interfaces of every kind
    • Update Scripts

     

    This idea, which helps Make FileMaker more modular, was inspired by Context-free Exportations and Importations