LINKTOFORM() not pre-filling value if column has Initial Value or Formula

AppSheet AppSheet Q&A
, ,
1

I’m using LINKTOFORM() to add a new record with some fields pre-filled from the existing row. The new record is not copying “Book ID” from the existing row, instead, it is generating a new value using the formula present in the Initial Value.

LINKTOFORM(“Plan Form”,
“Book Name”,[_THISROW].[Book Name],
“Book ID”,[_THISROW].[Book ID],
“PID”, (MAX(SELECT(Plan[PID],([Book ID]=[_THISROW].[Book ID])))+1))

I tried to move the formula from Initial Value to Formula but that didn’t work. how can I make it work?

2

Remove extraneous references to [_THISROW] and the spurious comma:

LINKTOFORM("Plan Form",
"Book Name",[Book Name],
"Book ID",[Book ID],
"PID", (MAX(SELECT(Plan[PID],([Book ID]=[_THISROW].[Book ID])))+1))
2 Likes