Enter values based on previous value. [_THISROW_BEFORE] error

[TeslaDom]

I am working on something where I previously asked to add multiple rows dependent on another table.

Multiple Rows Dependent of another table Questions

Hello. I will like create several rows based on a number previously defined in another table. I have TABLE_A in that table I save a number could be, for example 3, and I have another table TABLE_B. I will like to create 3 new rows in TABLE_B table when I create a new row of TABLE_A. (Based on example of 3) The TABLE_B table will have information from TABLE_A and own information. Any help is appreciated. Thank you!

They answered my question with the following post, And it works perfect.

FAQ: Add a number of rows Tips & Tricks 💡

Add an arbitrary number of rows to a table based on a column value of type Number. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: Finish Count (…

Continuing with the same application I want to be able to enter values in the cell based on the previous value of the same cell.
I am trying with this code but it results in the error that I show below.

ifs(
(and(([TYPE]=2),([Add Count]<=1))),
([INITIAL_DATE]+[Add Count]+1),
([TYPE]=2),
(date([_THISROW_BEFORE])+[Add Count]+1)
)

Unable to find column ‘_THISROW_BEFORE’

Thank you.

[Steve]

Please post a screenshot of Expression Assistant showing the complete formula and the error message.

[TeslaDom]

Sorry about the name change. The name of the columns is different because they are in Spanish. As they appear in the image are the real names in the App.

[Steve]

Instead of just this:

[_THISROW_BEFORE]

try this:

[_THISROW_BEFORE].[FECHA_CUOTA]

[TeslaDom]

It results in the same error. Also if I save after placing [_THISROW_BEFORE]. [DATE_CUOTA] gives this error.

[TeslaDom]

somebody have any idea?