Share
Explore

Form Lookups Example

Fill out the form for a particular person and it should automatically link that row in the Person column of the [Order] table.
People
0
Search
Name
Value
Form Link with thisRow.EncodeForUrl()
Form Link with thisRow.Name
Form Link with thisRow
Form Link with thisRow.RowId()
Form Link with r + RowId()
1
Connor
The first connor
2
Connor
The second instance
3
Someone Else
​
There are no rows in this table
⁠

Order
0
Search
Order
Dairy Free?
Person
Method
Note
1
Burger
Form Link with thisRow.EncodeForUrl()
This gets monstrously close to what I need.
Formula was:
Hyperlink([Order Form Url] + '?Person=' + thisRow.Url().EncodeForUrl())
2
Salad
Connor
Form Link with thisRow.Name
​
3
​
grid-oz9ed3dswo/i-n5GUWYAmZG
Form Link with thisRow
This would be the easiest for most people
Formula was simply:
Hyperlink([Order Form Url] + '?Person=' + thisRow)
4
Pizza
5
Form Link with thisRow.RowId()
​
5
Salad
r5
Form Link with r + RowId()
​
There are no rows in this table
⁠


Order Form Url:
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ
⁠
⁠
Menu
0
Name
1
Pizza
2
Burger
3
Salad
There are no rows in this table
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.