Activate and OpenRow
Share
Explore

icon picker
Activate and OpenRow

Formula: Activate() and OpenRow()
Category: Action
front-gate-open.svg
OpenRow()
Opens the detail view of a row with optional parameters to open the rows as fullscreen or in alternate pre-set layouts
or stated otherwise...
Hey Coda, please open this row for me. And give me a bunch of options, too.
door-opened.svg
Activate()
Brings up the detail view of a row passed as an input, and unlike OpenRow, doesn’t have optional parameters
or stated otherwise...
Hey Coda, can you please open this row for me? I don’t need a bunch of options, though.

OpenRow() has one required and two optional parameters:
Required
row (1).svg
Row

OpenRow(Row, ViewOrLayout, ViewMode)

The row that you want to open.
Optional
view-file.svg
ViewOrLayout

OpenRow(Row, ViewOrLayout, ViewMode)

The view you want to open the row.
Optional
full-screen.svg
ViewMode

OpenRow(Row, ViewOrLayout, ViewMode)

View mode for the open row; Modal/Fullscreen.

Activate() has one parameter:
3d-select (1).svg
Object

Activate(Object)

Any Coda object: a table, control, columns, rows, etc.

Activate

Activate() allows you to open a newly created row. In fact, it’s what Coda uses to open a newly created row when you toggle the Open Row for Editing on a button.
Go ahead! Try right-clicking on the button below and press the formula editor.
Add a Client
1
2
View
Name
Location
Notes
Client 1
California
Client 2
New York
There are no rows in this table

image.png

Use Activate to create user friendly documents

Activate() is extremely useful when building documents where your end users are not as accustomed to or familiar with Coda. It makes opening the detail view of a row far simpler.
Try the
button in the table above to see how it easy it is to open that rows detail view.

OpenRow

OpenRow() is the far more powerful cousin of Activate() as it allows you to specify the detail layout in which the row should be opened. The one catch, though, is that you have to store a table that is set to that layout and then reference that in the OpenRow() formula.
Imagine you have a table of invoices where some are have already been collected (closed) and some are still open (yet to be collected). Obviously you don’t want to edit already closed invoices. Watch how the buttons below actually open different views of the rows.

Company
Invoice Number
Amount
Status
Edit/View
Nike
2
Invoice #1
$10,000.00
Open
Edit Invoice
Invoice #2
$3,654.00
Closed
View Invoice
Starbucks
3
Invoice #1
$4,000.00
Open
Edit Invoice
Invoice #2
$1,254.00
Open
Edit Invoice
Invoice #3
$1,325.00
Closed
View Invoice
Apple
3
Invoice #1
$346.00
Closed
View Invoice
Invoice #2
$8,745.00
Closed
View Invoice
Invoice #3
$2,346.00
Open
Edit Invoice
A view set to EDIT Layout
2
A view set to VIEW layout
2
The tables above are Views of the parent invoice table and their specific details view is SET to an individual detail layout type. The OpenRow() formula actually references these views and needs them to work.
You will likely want to store these views in your documents on a dedicated and hidden page.

Done
Create an app like experience with a “fullscreen” toggle button
Done
View invoices in full-screen edit mode
Done

Share
 
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.