Share
Explore

icon picker
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!
⁠
Loading…
⁠
⁠

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
0
Name
Character
Basic
Bug
Bug Set Control
Table Save State
Save State
Set Control Save State
1
Blue
Bowser
Add or modify rows
Add row
Add or modify rows
Add or modify rows
Peach
Add or modify rows
2
Rabbit
Luigi
Add or modify rows
Add row
Add or modify rows
Add or modify rows
​
Add or modify rows
3
Shark
Mario
Add or modify rows
Add row
Add or modify rows
Add or modify rows
​
Add or modify rows
4
Purple
Peach
Add or modify rows
Add row
Add or modify rows
Add or modify rows
​
Add or modify rows
There are no rows in this table
⁠

Character List
0
Name
1
Mario
2
Luigi
3
Bowser
4
Peach
There are no rows in this table
⁠
Save State
0
Name
1
​
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.