Method Community

 

update field in table

Last post 03-25-2011 8:43 AM by Method_Michael. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 03-24-2011 12:22 PM

    • ian
    • Top 100 Contributor
    • Joined on 07-13-2010
    • Posts 48

    update field in table

    I try to update multiple record about one field by using update field in table function, i saw the criteria can only perform in two way, one is "=", the other is "<>. When i using "<>" it actually same as no criteria, it update all record regarding to that field even i put a condition there, it does not work.

  • 03-24-2011 12:47 PM In reply to

    Re: update field in table

     Hi Ian,

    Are you getting an error message? What results are you getting?

    I tried the following:

    Update Action

    This updated everyone but Amy Smith.

    -Michael

    Michael Melo
    Product Manager
    Method Integration Inc.
    Website: http://www.method.me
    LinkedIn: http://www.linkedin.com/in/MichaelMelo
  • 03-24-2011 2:18 PM In reply to

    • ian
    • Top 100 Contributor
    • Joined on 07-13-2010
    • Posts 48

    Re: update field in table

    I did not get error message , the whole table has been updated including the value i entered.

  • 03-24-2011 2:44 PM In reply to

    Re: update field in table

    Ian,

    Can you let me know what information you filled in for the action or send me a screenshot of what you filled in to m.melo@methodintegration.com

    -Michael

    Michael Melo
    Product Manager
    Method Integration Inc.
    Website: http://www.method.me
    LinkedIn: http://www.linkedin.com/in/MichaelMelo
  • 03-24-2011 2:53 PM In reply to

    • ian
    • Top 100 Contributor
    • Joined on 07-13-2010
    • Posts 48

    Re: update field in table

    the value i entered in criteria is multiple invoice number and it joined with comma like "001121,001122" and I want to update a Yes/No field in those invoices. when i test it with "=", it show me an error message. when i using "<>", it update  field in every invoice to "yes" which is the value i entered.

  • 03-24-2011 2:56 PM In reply to

    • ian
    • Top 100 Contributor
    • Joined on 07-13-2010
    • Posts 48

    Re: update field in table

    I was wondering that is there way to make criteria accept like a list of value instead of single value. or there is anyway method can support regular expression.

  • 03-25-2011 8:43 AM In reply to

    Re: update field in table

    Answer

    HI Ian,

    The Update field in table action does not support built lists. You would have to use it in a loop and update one record at a time.

    The reason why you received an error message when using = is there was no match and no field was update since no invoice number = "001121, 001122" and when using <> it updates all record because no record is equal to "001121, 001122".

    One additional note, I would recommend not updating using Invoice number but instead using RecordID.

    -Michael

    Michael Melo
    Product Manager
    Method Integration Inc.
    Website: http://www.method.me
    LinkedIn: http://www.linkedin.com/in/MichaelMelo
Page 1 of 1 (7 items)