Method Community

 

Insert records into Table action loses values when it follows loop through grid

Last post 10-20-2015 10:20 AM by mahlonf. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 11-25-2014 1:55 PM

    • mahlonf
    • Top 10 Contributor
    • Joined on 09-28-2012
    • Stevens, PA
    • Posts 879

    Insert records into Table action loses values when it follows loop through grid

    The insert record into table action loses the "value from loop" values when when you come back into the action to edit something.

    To correct this, I need to Open the Loop through grid action then come back into the insert record into table action an update the values. 

    This can be a bit of a pain when you have a number of fields.

     

    Mahlon L Fisher
    Computer Bookkeeping Solutions
    www.combooksolutions.com
  • 11-27-2014 11:56 AM In reply to

    Re: Insert records into Table action loses values when it follows loop through grid

    Hi Mahlon,

    I've tried replicating this but have been unable to. I have a button that loops through a grid on screen and added an Insert Into Table action. The attached screenshot shows this insert action. I have run the screen and edited the Insert action several times without losing the value highlighted in the screenshot. 

    I'm assuming you have a more elaborate setup than I do, so perhaps that's playing a role. Can you give me more information about what's on your particular button, so that I can more closely replicate it?

    - Adam

    Adam Lyons
    Manager of Support
    Method Integration
    a.lyons@method.me
  • 11-27-2014 12:00 PM In reply to

    Re: Insert records into Table action loses values when it follows loop through grid

    Sorry, forgot to add the screenshot....

    Adam Lyons
    Manager of Support
    Method Integration
    a.lyons@method.me
  • 11-27-2014 4:35 PM In reply to

    • mahlonf
    • Top 10 Contributor
    • Joined on 09-28-2012
    • Stevens, PA
    • Posts 879

    Re: Insert records into Table action loses values when it follows loop through grid

    Try inserting at least 10 to 12 fields

    The screen I was working on had a variety of values...

    from Loop
    from screen
    from action result

    Mahlon L Fisher
    Computer Bookkeeping Solutions
    www.combooksolutions.com
  • 10-19-2015 9:18 AM In reply to

    • mahlonf
    • Top 10 Contributor
    • Joined on 09-28-2012
    • Stevens, PA
    • Posts 879

    Re: Insert records into Table action loses values when it follows loop through grid

    This is still an issue

    Mahlon L Fisher
    Computer Bookkeeping Solutions
    www.combooksolutions.com
  • 10-20-2015 10:15 AM In reply to

    Re: Insert records into Table action loses values when it follows loop through grid

    Hi Mahlon,

    Still unable to replicate this error.

    I have created a screen with over 12 fields, and multiple actions. The Loop value in a Insert to Table action does not lose its value.

    Anything else I can add to my screen you think that I am missing? I'll give it another shot.

    -- Mortaza

    Morty Barighzaai
    Customer Success Manager
    Method:CRM
  • 10-20-2015 10:20 AM In reply to

    • mahlonf
    • Top 10 Contributor
    • Joined on 09-28-2012
    • Stevens, PA
    • Posts 879

    Re: Insert records into Table action loses values when it follows loop through grid

    I discovered if I open the Loop first, then it is not a problem.

    I'll keep you postedwhen I encounter it again

    Mahlon L Fisher
    Computer Bookkeeping Solutions
    www.combooksolutions.com
Page 1 of 1 (7 items)