I'm trying to set up my initial value of a Lo...

(Sebastian Alvarez) #1

I’m trying to set up my initial value of a LongText column to be the previous row’s information.

For example if in Row #2 I wrote “This is a test”

When I open up the form which will go in Row #3, I want “This is a test” to show up for that column.

How could I do this?

(Steven Coile) #2

Set the column’s Initial value field to an expression that returns the previous records value. For instance, you might try:

=select(MyTable[Comment], ([_RowNumber] = max(MyTable[_RowNumber])))

replacing MyTable with the name of your table, and Comment with the name of the column.

(Sebastian Alvarez) #3

+Steve Coile Hi Steve, plugging this in I got an error because Select returns a List and the Initial Value box does not accept List formats. What I did to fix this was add TEXT() to your expression. So for me it was

=Text(select(MyTable[Comment], ([_RowNumber] = max(MyTable[_RowNumber]))))

replacing MyTable with the name of your table, and Comment with the name of the column.

Thank you for your help!

(Steven Coile) #4

@Sebastian_Alvarez Oops! I’d recommend any() instead of text(), but that should be okay, too.