Activate and OpenRow

Explore

Gallery

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

Invoice #1

$10,000.00

Open

Edit Invoice

Invoice #2

$3,654.00

Closed

View Invoice

Starbucks

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

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 EDIT Layout

⁠

A view set to VIEW 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.

⁠