Create a column with a consecutive value

  • 101 Views
  • Last Post 15 August 2018
  • Topic Is Solved
Karen Reyes posted this 15 May 2018

Hello, i'm working in a FC11 project, we are processing information of a table (7 columns) and it works fine.

Now we need to create a new column (just for reading) that indicates the number of each row in the table, so it must begin in 1 and for each row it must increment in 1.

 Could you give me some ideas, i've looking for a method in the rows (something like prev, next) but i don't see how implement

Thank you

Order By: Standard | Newest | Votes
AlexeyEfremov posted this 17 May 2018

Hello,

The answer here is to setup the rule on a field that is not a part of a table. The thing is, when the rule belongs to the field that is part of the table or the table itself, you can access only the current row.

But if the rule belongs to the field that is not the part of the table, you can access different fields by the Items property, for example if the table has the column "price", you can access the data like this:

Context.Field("price").Items[i].Value

Unfortunately, this is by design.

 

 

 

 

 

  • Liked by
  • Karen Reyes
Karen Reyes posted this 15 August 2018

Hello, thank you, that was the solution, sorry i couldn't answer before.

Close