When making an action by adding new rows for a recurring event, how to take a value from the previou

[rybnz]

When making an action by adding new rows for a recurring event, how to take a value from the previous row?

Eg.

My first row has a calculated date value in column D

My next row will be inheriting that date value into Column B.

All these will be done in Actions.

Anyone has any suggestions?

Thank you 

[Marc_Dillon · Accepted solution]

https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216

[Marc_Dillon · Accepted solution]

https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216

[Uk · Accepted solution]

Maybe you can use the following steps:

1. Create an action that adds a new row to the table.

2. In the "Set these columns" section of the action, set the value of the date column (let's say Column B) to the value of the date column in the previous row (let's say Column D).

3. To get the value from the previous row, use the following expression in the formula section of the "Set these columns" section:

INDEX(Table[Column], MAX(SELECT(Table[KeyColumn], [KeyColumn] < [_THISROW].[KeyColumn])))

Replace "Table" with the name of your table, "Column" with the name of the column you want to get the value from (in this case, Column D), and "KeyColumn" with the name of your key column.

Save the action and test it out by adding a new row to the table.

[rybnz]

Thank you