JavaScript Required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Share
Explore
Form Lookups Example
CM
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
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
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
Order
0
Search
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
Menu
0
Name
1
Pizza
2
Burger
3
Salad
There are no rows in this table
Related Docs
$10k Work: How to increase your productivity using the magic of leverage
Khe Hy
Two-way writeups: Coda’s secret to shipping fast
Lane Shackleton
Peloton Analytics Tool for Workout Stats [+Template]
Al Chen
Mental Health Awareness Month
Jamie Forseth
Four Myths of Bundling
Shishir Mehrotra
OTF Planner (otfplanner.com)
Kenny
Random Quote Generator
Mark Davis
SpotRacer Database
kev null
Founders Mindset Bootcamp Shared
Nathalie Rafeh
1:1 & Career Development Template
Eric Glick
The Inbox-Zero Challenge: How long can you keep up your streak?
Shishir Mehrotra
Hiring List Template
SiNing Chan
BlockSplit Info
Block Split
Easy RSVP Tracker with the Gmail Pack
Kay Diaz-Ferrigno
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.