Constructed deep link to form

Returns a deep link (App value) to a form in an app (the current app, if not specified) with at least one column preset to a value.

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.


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. 


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 columnvalue, 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)






Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center