1 Reply Latest reply on Feb 26, 2015 2:50 PM by philmodjunk

    Copy Paste Data Like Excel Form to and from Filemaker

    Charmalique

      Title

      Copy Paste Data Like Excel Form to and from Filemaker

      Post

      Hi,

      How do I create a field or fields or table of where I can copy paste multiple cells in an excel file to Filemaker and Vice Versa.

      Example: I have data of Persons with multiples columns like. e.g gender, age, and email address.
      I would like to set it up like an excel so that I can easily copy past if from excel to Filemaker.

      What is the better way to create the fields and set-up to behave as per above.

      Thanks

        • 1. Re: Copy Paste Data Like Excel Form to and from Filemaker
          philmodjunk

          FileMaker does not support that type of paste. You'd need to paste all the data into a single field--possibly a global text field and use a script to parse the data into designated fields/records of your FileMaker File. It's simpler to designate the cells as a range and then import that range using Import Records.

          Keep in mind that FileMaker is not a spreadsheet application and was not designed to function like one.