Returns a deep link (
App value) to a form to create a new record in an app (the current app, if not specified) with at least one column preset to a value.
LINKTOFORM("Order Details_Form", "Order ID", [_THISROW]) creates a deep link to an
Order Details_Form with the
Order ID column preset with a reference back to the current row (making the new
Order Details row a child of the current row).
LINKTOFORM("Orders_Form", "Customer ID", [_THISROW], "Delivery Address", [Customer Address]) creates a deep link to an
Orders_Form, with the
Customer ID column preset with a reference back to the current row, and
Delivery Address preset with a copy of the customer's address.
LINKTOFORM(view, column, value, [column, value...], [app-id])
view- An expression that returns the name of the target view. The view named must be of type
column- An expression that returns the name of a column of the target table.
- value - An expression that returns a value for the column named by the immediate-preceding
app-id- An optional expression that returns the ID of the app containing the target form.
AppSheet does not validate
app-id. If invalid (such as, misspelled or otherwise referring to a non-existent app), no error will be displayed.
app-id may be of any type, are interpreted as
Text values, and will be encoded (as with
ENCODEURL()) for use in the deep link.