Method:Classic General Q&A

Re: update field in table

Method_Michael — Fri, 25 Mar 2011 13:43:22 GMT

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

Re: update field in table

ian — Thu, 24 Mar 2011 19:56:44 GMT

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.

Re: update field in table

ian — Thu, 24 Mar 2011 19:53:09 GMT

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.

Re: update field in table

Method_Michael — Thu, 24 Mar 2011 19:44:01 GMT

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

Re: update field in table

ian — Thu, 24 Mar 2011 19:18:33 GMT

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

Re: update field in table

Method_Michael — Thu, 24 Mar 2011 17:47:20 GMT

Hi Ian,

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

I tried the following:

This updated everyone but Amy Smith.

-Michael

update field in table

ian — Thu, 24 Mar 2011 17:22:36 GMT

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.