Method Community

 

Export to Excel (from an action), some extra fields are "RecordID"

Last post 03-13-2016 8:08 PM by Method_Adam. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 11-11-2015 5:12 PM

    Export to Excel (from an action), some extra fields are "RecordID"

    Hi,

    While export a Grid to an Excel file by actions, it seems that the system will add another "RecordID" column if one column is in "drop-down" type. Why add these extra RecordID column, seems a big error in the program. Please help to remove those columns.


    Here is an example:


    http://imgur.com/Lpv1BFB


    Vendor is the column that I want, however, "VendorName_RecordID" is redundant, same as "Location" and "LastLocation_RecordID"


    --

    Alex

    Chief Architect
    Yi Systems, Inc.
    alexhuang@yisystems.com
    www.yisystems.com blogs.yisystems.com
    Software.Web.Cloud.IT
  • 11-13-2015 12:46 PM In reply to

    Re: Export to Excel (from an action), some extra fields are "RecordID"

    Hi Alex,

    Ive tried to replicate this Issue on my end with no luck. Exporting a Grid with Linked Dropdowns was only displaying the fields it should be displaying for me.

    Are you able to send a screenshot of the Grid fields pre-export? The fields listed in Step 2 when editing the grid?

    As much context as you can provide would be hugely helpful. Thanks Alex

    Regards,

    Ben

    Ben Hargreaves
    Senior Support Specialist
    Method:CRM
    b.hargreaves@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 11-13-2015 2:36 PM In reply to

    Re: Export to Excel (from an action), some extra fields are "RecordID"

    Hi

    I capture part of this editing step (it is a long list.) 

    http://imgur.com/9qvOn82

    --

    Alex

    Chief Architect
    Yi Systems, Inc.
    alexhuang@yisystems.com
    www.yisystems.com blogs.yisystems.com
    Software.Web.Cloud.IT
  • 11-16-2015 9:50 AM In reply to

    Re: Export to Excel (from an action), some extra fields are "RecordID"

    Hi Alex,

    I might have to take this one Offline with you. Ive sent you an email requesting a few more details.

    Looking forward to getting this one resolved for you Alex.

    Regards,

    -Ben

    Ben Hargreaves
    Senior Support Specialist
    Method:CRM
    b.hargreaves@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 03-09-2016 7:49 PM In reply to

    Re: Export to Excel (from an action), some extra fields are "RecordID"

    Hi,

    Per discusson offline which is caused by a known issue, just want to know any progress/solution to this? It is really annoying to remove those extra ID column daily. Thanks.

    Alex

    Chief Architect
    Yi Systems, Inc.
    alexhuang@yisystems.com
    www.yisystems.com blogs.yisystems.com
    Software.Web.Cloud.IT
  • 03-13-2016 8:08 PM In reply to

    Re: Export to Excel (from an action), some extra fields are "RecordID"

    Hi Alex,

    We brought this up with the team back in November. Unfortunately, I don't believe we'll be addressing this in the Classic version of Method.

    We're sorry for any inconvenience this may be causing.

    - Adam

    Adam Lyons
    Manager of Support
    Method Integration
    a.lyons@method.me
Page 1 of 1 (6 items)