DeleteRows

Pages
- DeleteRows
- The Coda School

DeleteRows

Explore

DeleteRows

⁠

Formula: DeleteRows()

Category: Action

⁠

DeleteRows()

Deletes chosen rows

or stated otherwise...

Hey Coda, please delete the following row(s).

DeleteRows() has one parameter:

⁠

Rows

DeleteRows(Rows)

A list of the rows to delete.

⁠

One of the largest drains on your doc’s performance are tables with high row counts (normally greater than 10,000 rows). Therefore, creating an automated system to delete old/unnecessary rows is a must.

Whether the above is your reason for deleting rows in your doc via an action or not, it is crucial to understand how to use this action. Let’s look at some common patterns you will be using with DeleteRows().

Deleting all rows from a table

Common in many distributed teams is the idea of a standup—a daily or weekly opportunity for individuals to share what they’re working on. Below is a button titled “Refresh Standup Table” that runs three actions:

Deletes all the rows from the table

Adds fresh new rows with a random assortment of people from the company

Without DeleteRows() this kind of workflow would not be possible! If you are interested, take a look at the button formula - Its a good one!

10/21/2022

There are no rows in this table

⁠

Delete only a selection of table

Below is a large database of countries. In this scenario (as is common), the table below was downloaded from a website, but Bob, our astute researcher, only wants the rows where the country is below the equator and in the western hemisphere.

Bob has configured his button below to only delete a selection of his table - aka the countries with a + Lat and Lng value.

Andorra

United Arab Emirates

Afghanistan

Antigua and Barbuda

Anguilla

Albania

Armenia

Netherlands Antilles

Angola

Antarctica

Argentina

American Samoa

Austria

Australia

Aruba

Azerbaijan

Bosnia and Herzegovina

Barbados

Bangladesh

Belgium

Burkina Faso

Bulgaria

Bahrain

Burundi

Benin

Bermuda

Brunei

Bolivia

Brazil

Bahamas

Bhutan

Bouvet Island

Botswana

Belarus

Belize

Canada

Cocos [Keeling] Islands

Congo [DRC]

Central African Republic

Congo [Republic]

Switzerland

Côte d'Ivoire

Cook Islands

Chile

Cameroon

China

Colombia

Costa Rica

Cuba

Cape Verde

Christmas Island

Cyprus

Czech Republic

Germany

Djibouti

Denmark

Dominica

Dominican Republic

Algeria

Ecuador

Estonia

Egypt

Western Sahara

Eritrea

Spain

Ethiopia

Finland

Fiji

Falkland Islands [Islas Malvinas]

Micronesia

Faroe Islands

France

Gabon

United Kingdom

Grenada

Georgia

French Guiana

Guernsey

Ghana

Gibraltar

Greenland

Gambia

Guinea

Guadeloupe

Equatorial Guinea

Greece

South Georgia and the South Sandwich Islands

Guatemala

Guam

Guinea-Bissau

Guyana

Gaza Strip

Hong Kong

Heard Island and McDonald Islands

Honduras

Croatia

Haiti

Hungary

Indonesia

Ireland

Israel

Isle of Man

India

British Indian Ocean Territory

Iraq

Iran

Iceland

Italy

Jersey

Jamaica

Jordan

Japan

Kenya

Kyrgyzstan

Cambodia

Kiribati

Comoros

Saint Kitts and Nevis

North Korea

South Korea

Kuwait

Cayman Islands

Kazakhstan

Laos

Lebanon

Saint Lucia

Liechtenstein

Sri Lanka

Liberia

Lesotho

Lithuania

Luxembourg

Latvia

Libya

Morocco

Monaco

Moldova

Montenegro

Madagascar

Marshall Islands

Macedonia [FYROM]

Mali

Myanmar [Burma]

Mongolia

Macau

Northern Mariana Islands

Martinique

Mauritania

Montserrat

Malta

Mauritius

Maldives

Malawi

Mexico

Malaysia

Mozambique

Namibia

New Caledonia

Niger

Norfolk Island

Nigeria

Nicaragua

Netherlands

Norway

Nepal

Nauru

Niue

New Zealand

Oman

Panama

Peru

French Polynesia

Papua New Guinea

Philippines

Pakistan

Poland

Saint Pierre and Miquelon

Pitcairn Islands

Puerto Rico

Palestinian Territories

Portugal

Palau

Paraguay

Qatar

Réunion

Romania

Serbia

Russia

Rwanda

Saudi Arabia

Solomon Islands

Seychelles

Sudan

Sweden

Singapore

Saint Helena

Slovenia

Svalbard and Jan Mayen

Slovakia

Sierra Leone

San Marino

Senegal

Somalia

Suriname

São Tomé and Príncipe

El Salvador

Syria

Swaziland

Turks and Caicos Islands

Chad

French Southern Territories

Togo

Thailand

Tajikistan

Tokelau

Timor-Leste

Turkmenistan

Tunisia

Tonga

Turkey

Trinidad and Tobago

Tuvalu

Taiwan

Tanzania

Ukraine

Uganda

U.S. Minor Outlying Islands

United States

Uruguay

Uzbekistan

Vatican City

Saint Vincent and the Grenadines

Venezuela

British Virgin Islands

U.S. Virgin Islands

Vietnam

Vanuatu

Wallis and Futuna

Samoa

Kosovo

Yemen

Mayotte

South Africa

Zambia

Zimbabwe

There are no rows in this table

⁠

Delete a single row from a table

Many times you may want to create a button that merely deletes a single row from a table —specifically the row from which the button was pressed.

Why? There are two main reasons:

You want to lock your doc to prevent accidental deletion of rows or rows in bulk, but you want people to still have that option via a button.

Your users are very tech illiterate and need the doc “dummy-proofed” so everything is as easy as possible.

Ice Cream Flavors

Ice Cream Flavors

Vanilla

Hate this flavor!

Carmel

Hate this flavor!

Cookies and Cream

Hate this flavor!

Chocolate

Hate this flavor!

There are no rows in this table

⁠

Deleting a selection of rows from a separate table

One especially useful way to use DeleteRows() is when you configure a button in a column to delete an already filtered collection of rows that are related to that row. *NOTE: This can only be done with a formula-configuration of a button - not in the regular UI configuration*

Confused? Lets look at this example:

Contracts

Contracts

Apple

$25,000.00

Delete 2 Invoices

Facebook

$79,750.00

Delete 4 Invoices

Google

$64,550.00

Delete 2 Invoices

There are no rows in this table

⁠

Invoices

Invoices

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ··· in the right corner or using a keyboard shortcut (

CtrlP

) instead.