Solved: How do I 'set the values of some columns in this r... - Page 2

Pratyay_Rakshit · 04-15-2020 07:05 AM

I have a referenced action running for one table.

And the action that is ‘referenced’ is of the set the values of some columns in this row type. The value that is to be set by the action lets us input expressions, so that’s hope for me.

So what I want is to set the value to the one that I input in a row of one of the columns of the parent table. What’s the expression to do that?

WillowMobileSys

It looks like there are some changes in column names from before, so I am a little confused on how you are matching up bill rows.

Bottom line is it doesn’t look like the LOOKUP() has the right column references in it to properly match rows.

It should be something like this:

LOOKUP([Column name of bill ID in "User bill submission"],
       "Supplier payment form",
       "Column name of bill ID in Supplier payment form",
       "Enter Amount" )

View solution in original post

How do I 'set the values of some columns in this row' with values from another table?