Method Community

 

Looping through a table

Last post 12-06-2012 9:11 AM by Method_Adam. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 12-05-2012 10:30 PM

    Looping through a table

    I'm doing some testing to make sure I understand how the looping through a table works, and it doesn't seem to be doing what I think it should do.  Hoping someone can help me.

    I am on the invoice screen, in the invoice line table.  I have set up a series of actions in step #5 of the wizard, where after an Edit (clicking the update button), the action to Start looping through a table is called.  I am using the InvoiceLine table, where the RecordID is equal to Type In ">0" as the instructions at the top say to do.  I have left all other fields blank.

    The next step is to Start a Conditional Statement where the Value from Row - Item is Equal to the typed in value "102" (no quotes used in the actual coding)

    If the above is true, I want to Enter a Value into a Field on Screen (I have just set up a test label field for this exercise), where the number 999 would be typed into that field.

    Then I end the conditional statement, and end the loop.

    When I go to the invoice screen, I create a new invoice.  I enter the customer, and then go down to the invoice line items.  I enter the first item (102), enter QTY, and then click Update.  I would expect to see 999 in the test field, but it just stays blank.  

    What am I missing?

    Thanks!

    Karen

  • 12-06-2012 5:40 AM In reply to

    Re: Looping through a table

    Karen

    its loop through invoiceline table where the field InvoiceRecorcdID = Value from screen RecordID.

    Mark Crews
    Cloud Consultancy
    Principal and Developer


    • 2012 MethodCRM Partner of the Year

    • 2012 MethodCRM Community Excellence Award

    • 2011 MethodCRM Community Excellence Award


    Visit our website to find out about our training, support, and customization services.
    website: cloudconsultancyllc.com
    blog: cloudconsultancyllc.com/blog/
    ph: 434.326.1601
    e: support@cloudconsultancyllc.com

    What is Method?
  • 12-06-2012 7:24 AM In reply to

    Re: Looping through a table

    It's still not working :(

  • 12-06-2012 9:11 AM In reply to

    Re: Looping through a table

    Answer

    Karen,

    Is the service date blank on the screen? Try inputting a service date.

    - Adam

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