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()
1
Connor
The first connor
2
Connor
The second instance
3
Someone Else
There are no rows in this table
Order
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
Name
1
Pizza
2
Burger
3
Salad
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.