Method Community

I have a custom table with a status column. I want the select option to open one pop-up based on the value of that column and another for other values.

I have a "Start Conditional Statement" action with value 1 being "Value From Row" with the "status" column selected "Equals to" Type In of "Approved". When I try it however I get the following error:

Unable to locate value from row for column status

Thoughts?

--Michael

Hi Michael,

"Value From Row" is used inside a loop through a grid/table, which is why you are getting the error message. You should get the value to compare in the conditional statement with "Assign Value to Action Result".

You can get the record's RecordID using Value From Screen, using Grid:RecordID (where Grid would be the name of your grid). Then using the "Retrieve Value From Table", get the Status field from the table, where RecordID is the previous action result.

You can store that in an action result, then proceed with your conditional statement. If you have any questions about this just let us know.

-Russell