I want to set the previous entry as the initial value in a form.

Let me ask you a question.
I have the following structure
I have a table in appsheet with
(1)date
(2) name
I would like to display the result of the last entry of the initial value.
Please give me some guidance.

質問させてください。
私は次の構造の
appsheetにテーブルを持っています(1)日付
(2)名前
私は初期値の最後のエントリの結果を表示したいと思います。
私にいくつかのガイダンスを与えてください。

Solved Solved
0 2 126
  • UX
1 ACCEPTED SOLUTION

Try setting the following to the initial value of your target column..

LOOKUP(
 MAXROW("Your Table", "_ROWNUMBER"),
 "Your Table",
 "Key Column",
 "Column you want to copy"
)

View solution in original post

2 REPLIES 2

Try setting the following to the initial value of your target column..

LOOKUP(
 MAXROW("Your Table", "_ROWNUMBER"),
 "Your Table",
 "Key Column",
 "Column you want to copy"
)

Thanks for the quick response.
It worked fine.
Thank you so much.

Top Labels in this Space