Execute an Action on a set of rows

AppSheet AppSheet Q&A
1

Hi I am using the above action to achieve the following. Retrieve the value entered in the [Fabrication Time] column of the Routings_Master Table and set that value for the [Fabrication Time] column in the PMF_Associated_Data Table. The following steps are what I have done but the action is not setting the value in the PFM_Associated_Data_Table.

I am obviously missing something so I am hoping someone can advise what that might be.

Created GET RMF Values

3X_3_7_37adad3b39ed8aef55c4e8df9ff4b8050b49f11d.png
3X_3_7_37adad3b39ed8aef55c4e8df9ff4b8050b49f11d.png1151×560 35.3 KB

Expression for [Fabrication Time] is
ANY(
SELECT(
Routings_Master[Fabrication Time],
AND(
ISNOTBLANK([Product Code]),
([Product Code] = [_THISROW].[Product Code])
)
)
)

and is yielding the following test result for the [Product Code] in question

3X_1_8_189a16c1d5971768550b74672f45d2907e5de5f0.png
3X_1_8_189a16c1d5971768550b74672f45d2907e5de5f0.png1683×154 10.3 KB

Create Set PMF Associated Data Values

3X_9_4_94dc6473d4727874ee284d70bb7ce493b686460a.png
3X_9_4_94dc6473d4727874ee284d70bb7ce493b686460a.png1107×641 44.1 KB

Expression for Referenced Rows is
FILTER(
“PMF_Associated_Data”,
AND(
ISNOTBLANK([Product Code]),
([Product Code] = [_THISROW].[Product Code])
)
)

and is yielding the following test result for the [Product Code] in question

3X_d_6_d6410e89c17141725715b1e904882ab51867df9a.png
3X_d_6_d6410e89c17141725715b1e904882ab51867df9a.png1678×173 11.7 KB

Set ‘Form Saved’ ‘Event Action’ for Routings_Master Form

3X_f_3_f38b796afe156493b980200b1f266112a2d76b31.png
3X_f_3_f38b796afe156493b980200b1f266112a2d76b31.png1153×683 28.9 KB

The only other thing I would add, and not sure if relevant, is that the Routings_Master Table IsPartOf another table called Works_Orders_Master through [Record ID].

Hope this provides enough information. Any help would be great, thank you.

2

For testing, in the GET RMF Values action, set the Fabrication Time column to a fixed value, like 3.14, just to test that the action is performed at all. If that value doesn’t get set, we should try to determine why the action isn’t firing at all; otherwise, we need to find out why the SELECT() expression isn’t working.

1 Like
3

Thank you @Steve. Setting the [Fabrication Time] to 3.14 yields the following result.

3X_6_b_6bf9a21bdc256a2b405aa71cda05af2b30e9e5da.png
3X_6_b_6bf9a21bdc256a2b405aa71cda05af2b30e9e5da.png1544×513 18 KB

4

MauriceWhelan:

the action is not setting the value in the PFM_Associated_Data_Table.

Test that.

5

It didn’t set the PMF_Associated_Data Table with the fixed value either.

6

You’re going to need to debug step-by-step, then. Break the process down and test each step, starting with the very first one, until you find the step that doesn’t work as expected.

2 Likes