Explore

Add Row with Child Add Row

Summary

When chaining AddRow actions, the OpenRow() or Activate() formula open the first row added instead of the one that it is added to.

This is true even if you use an intermediary Relations canvas control, where you can see that the Action formula results in a chain of new rows.

Video Walk-Through

Sorry about the choppy audio!

⁠

Scenario

Each button adds “Peach” to the

Character List⁠

table and then “Purple” with a reference to [Peach] in the

Character Creation⁠

Goal

Our goal is that:

The record added to

Character List⁠

is referenced in

Character Creation⁠

⁠

If we add “Peach” multiple times it will be the most recently added “Peach” that is referenced in

Character Creation⁠

⁠

Open the newly created “Purple Peach” in

Character Creation⁠

Buttons and their issues

Basic: add each row in order and associate them by Display value. This approach fails because if you click it twice it will select the first Character in

Character List⁠

that matches “Peach” instead of the newly added record.

Bug: we chain AddRow. We add “Peach” to

Character List⁠

as the value for the Character column in

Character Creation⁠

as we add the row “Purple” to

Character Creation⁠

. The Activate() formula incorrectly opens the “Peach” row in

Character List⁠

instead of the “Purple” row in the

Character Creation⁠

table.

Bug Set Control: we use a Relations canvas control to show how the approach used in the Bug column creates a chain of records, but Activate() cannot be targeted to open the most recently added row.

None

⁠

Table Save State: we store the newly created “Peach” character from

Character List⁠

in the Save State column and then use that value to create the “Purple” row in

Character Creation⁠

with “Peach” assigned. This approach works but has two issues:

If multiple users click the button at the same time it might associate the wrong records

It creates duplicate columns for any Add Child Row you need

Set Control Save State: our final solution. We can create the records, but temporarily store it in a Relation canvas control that references a single cell table

Save State⁠

[ ]

⁠

and is set to Personal so it is only modified for the current user.

Test it out

Try the different buttons below. You can

Delete Purple Peach rows

⁠

between each attempt.

Character Creation

Character Creation

Name

Character

Basic

Bug

Bug Set Control

Table Save State

Save State

Set Control Save State

Blue

Bowser

Add or modify rows

Add row

Add or modify rows

Peach

Add or modify rows

Rabbit

Luigi

Add or modify rows

Add row

Add or modify rows

Shark

Mario

Add or modify rows

Add row

Add or modify rows

Purple

Peach

Add or modify rows

Add row

Add or modify rows

There are no rows in this table

⁠

Character List

Character List

Name

Mario

Luigi

Bowser

Peach

There are no rows in this table

⁠

Save State

Save State

Name

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.