Data: set the values of some columns in this row

Hello,

I have one of a pair of actions in the survey table that’s driving me nuts… Hoping someone can help out… :slight_smile:

Action 1
Data: set the values of columns in this row
Name: AMEND survey_asset_id and UPDATE survey_asset_amended (ROW)

I’m having difficulty with Action 1

  • It works fine when I only have one column [survey_asset_amended] in the action.

  • The problem is that when I add the second column ([survey_asset_id]) to the action it runs without error but does not appear to execute the expression and populate the data…?

  • [survey_asset_id] expression: [survey_asset_id] - [_THISROW].[assets_to_abort]

  • [survey_asset_id] & [assets_to_abort] are both EnumList type Ref columns to the asset table.

  • I’ve tested the above expression in a VC where it works as expected.

  • Also, the form that feeds [assets_to_abort] is in a survey table slice called Review Slice which is set to “all columns”

Action 2
Data: execute an action on a set of rows
Name: AMEND survey_asset_id and UPDATE survey_asset_amended (ROWS)

  • The Reference Rows expression for Action 2 works OK…
    .
Reference Rows expression for Action 2
SELECT(
	survey[id],
		AND(
		[lcs] = [_THISROW].[lcs],
		[select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey],
		[_rownumber] >=
			MIN(
			SELECT(
				survey[_RowNumber],
				AND(
				[lcs] = [_THISROW].[lcs],
				[select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey],
				[select_asset_type] = [_THISROW].[select_asset_type],
				[sub_asset] = [_THISROW].[sub_asset],
        [survey_number] = [_THISROW].[survey_number],
        NOT([survey_status] = "Aborted")
				))),
				ISNOTBLANK(
				INTERSECT(
				[survey_asset_id], [_THISROW].[assets_to_abort]
				)),
        NOT([survey_status] = "Aborted")
		)
		)

Thanks in advance… :slight_smile: