LINKTOFORM()

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.

To edit an existing record, see LINKTOROW().

Sample usage

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.

Syntax

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 form.
• 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 column argument. 
• app-id - An optional expression that returns the ID of the app containing the target form. 

Notes

AppSheet does not validate view, column, or app-id. If invalid (such as, misspelled or otherwise referring to a non-existent app), no error will be displayed.

Each of column,  value, and 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.

See also

App column type (deep link)

LINKTOAPP()

LINKTOFILTEREDVIEW()

LINKTOPARENTVIEW()

LINKTOROW()

LINKTOVIEW()