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?
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.
+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!
@Sebastian_Alvarez Oops! Iโd recommend any() instead of text(), but that should be okay, too.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |