6 Replies Latest reply on Dec 11, 2015 7:29 PM by mikebeargie

    Insert Custom Field Values during Import from Excel


      I have limited experience with FM but am not new to data. 


      How would one go about designing a solution to support a data import workflow (for fields a, b, c) such that fields x,y,z could be assigned values by the user at the time of import?


      For instance, using the following fields...


      Field a = product id

      Field b = qty sold

      Field c = price


      Field x = customer

      Field y = season

      Field z = event name


      I need to populate an existing FM table such that each row becomes:

                      product id  |  qty sold  |   price  |   customer  |  season  |  event name


      Ideally, the values for Fields x, y, z would be entered using a dropdown box which receives its data from tbl.customer or a LOV.


      I do appreciate any guidance!