Trouble creating a workflow to update Data

AppSheet AppSheet Q&A
1

Hello,
I am using this guide to try an update columns in Table B based on input from Table A.
All the columns in question are of Decimal type but when I attempt to construct the “execute an action on a set of rows” My ref row expression keeps returning a column type error message. My expression is as followsSELECT(Incoming RM[Quantity Out],[RM Inv Id]=[_THISROW].[RM Inv Id]). I can’t figure out where the discrepancy is in column type.

Any help would be appreciated

2

Hi Eli,

Is “Quantity Out” the key for table “Incoming RM”?
The “Referenced rows” property must return a set of key values.

3

Just realized that now. Thanks for the clarification