Method Community

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.

 Hi Ian,

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

I tried the following:

This updated everyone but Amy Smith.

-Michael

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

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

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.

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.

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