Share
Explore
Activate and OpenRow
Formula: Activate() and OpenRow()
Category: Action
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.
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
OpenRow(Row, ViewOrLayout, ViewMode)
The row that you want to open.
Optional
ViewOrLayout
OpenRow(Row, ViewOrLayout, ViewMode)
The view you want to open the row.
Optional
ViewMode
OpenRow(Row, ViewOrLayout, ViewMode)
View mode for the open row; Modal/Fullscreen.
Activate() has one parameter:
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
View
Name
Location
Notes
Client 1
California
Client 2
New York
There are no rows in this table
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
A view set to VIEW layout
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.
Practice: Use activate to pop-open a detail view of a row
Done
Create an app like experience with a “fullscreen” toggle button
Done
View invoices in full-screen edit mode
Done
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.