Share
Explore

Form Lookups Example

Connor McCormick
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
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
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=https%3A%2F%2Fcoda.io%2Fd%2F_d9ULh8DmGOh%23_tuswo%2Fr3&Method=Form%20Link%20with%20thisRow.EncodeForUrl()
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=Connor&Method=Form%20Link%20with%20thisRow.Name
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=grid-oz9ed3dswo/i-IZ5ANI4fHC&Method=Form%20Link%20with%20thisRow
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=3&Method=Form%20Link%20with%20thisRow.RowId()
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=r3&Method=Form%20Link%20with%20r%20%2B%20RowId()
2
Connor
The second instance
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=https%3A%2F%2Fcoda.io%2Fd%2F_d9ULh8DmGOh%23_tuswo%2Fr5&Method=Form%20Link%20with%20thisRow.EncodeForUrl()
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=Connor&Method=Form%20Link%20with%20thisRow.Name
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=grid-oz9ed3dswo/i-n5GUWYAmZG&Method=Form%20Link%20with%20thisRow
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=5&Method=Form%20Link%20with%20thisRow.RowId()
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=r5&Method=Form%20Link%20with%20r%20%2B%20RowId()
3
Someone Else
​
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=https%3A%2F%2Fcoda.io%2Fd%2F_d9ULh8DmGOh%23_tuswo%2Fr4&Method=Form%20Link%20with%20thisRow.EncodeForUrl()
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=Someone%20Else&Method=Form%20Link%20with%20thisRow.Name
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=grid-oz9ed3dswo/i-FD6Q9EHo6O&Method=Form%20Link%20with%20thisRow
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=4&Method=Form%20Link%20with%20thisRow.RowId()
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=r4&Method=Form%20Link%20with%20r%20%2B%20RowId()
There are no rows in this table
⁠

Order
0
Order
Dairy Free?
Person
Method
Note
1
Burger
Connor
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.