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
⁠
Related Docs
A framework for radical focus.
$10k Work: How to increase your productivity using the magic of leverage
Khe Hy
Three simple tips to ensure you're driving results from written documents.
Two-way writeups: Coda’s secret to shipping fast
Lane Shackleton
A tutorial on how you can sync and analyze your Peloton workout stats into Coda with custom dashboards using the unofficial Peloton API.
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
This generator randomly pulls from my collection of favorite quotes, just over 397 as of February 2022. Come back every so often to copy new additions.
Random Quote Generator
Mark Davis
SpotRacer Database
kev null
Founders Mindset Bootcamp Shared
Nathalie Rafeh
Framework for better 1:1 meetings & tracking progress to goals
1:1 & Career Development Template
Eric Glick
My guide to achieving and maintaining Inbox Zero.
The Inbox-Zero Challenge: How long can you keep up your streak?
Shishir Mehrotra
Here's a list of amazing people affected by the recent layoffs.
Hiring List Template
SiNing Chan
BlockSplit Info
Block Split
Use this doc to easily make and manage the guest list for your next big event.
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 (
CtrlP
) instead.