Skip to content
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
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()
Connor
The first connor
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=r3&Method=Form%20Link%20with%20r%20%2B%20RowId()
Connor
The second instance
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ?Person=r5&Method=Form%20Link%20with%20r%20%2B%20RowId()
Someone Else
​
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
Form Link with thisRow.EncodeForUrl()
This gets monstrously close to what I need.
Formula was:
Hyperlink([Order Form Url] + '?Person=' + thisRow.Url().EncodeForUrl())
Form Link with thisRow.Name
​
Form Link with thisRow
This would be the easiest for most people
Formula was simply:
Hyperlink([Order Form Url] + '?Person=' + thisRow)
Form Link with thisRow.RowId()
​
There are no rows in this table
⁠


Order Form Url:
https://coda.io/form/Untitled-Form_ddJMB3kPZpQ
⁠
⁠
Menu
There are no rows in this table
⁠
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.