4 Replies Latest reply on Mar 26, 2015 1:22 PM by mitchesparza

    Using Apple Script to copy and paste from XL to new find request field

    mitchesparza

      Summary

      Using Apple Script to copy and paste from XL to new find request field

      Product

      FileMaker Pro

      Version

      12.0v4

      Operating system version

      OSX Yosemite

      Description of the issue

      I would like to copy the contents of one column of cells in an XL spreadsheet and paste them as individual find requests in File maker Pro using apple script. 
      I have Catalogues of product sent to me by distributors. 
      So I'd like to have an automated way of searching through catalogues to see if we have items in stock in our database based on a field like title or catalogue number.
      Ex:
      In excel copy cell A2
      In File maker paste contents from A2 to "catalogue number" field and conduct find.
      Then, repeat this dozens and dozens of times.

      Can anyone out there help me?

      Screen_Shot_2015-03-25_at_12.59.48_PM.png