Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Api Patch Call - Empty Cell in last row

Topic Labels: API
Solved
Jump to Solution
1664 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jop85web
4 - Data Explorer
4 - Data Explorer

Hi,

I'm trying to patch call an empty cell which is always be in the last/current row. Is there a way to do this with a parameter?

1 Solution

Accepted Solutions
Steve_Haysom
8 - Airtable Astronomer
8 - Airtable Astronomer

if you add an autonumber field and then sort by that field descending, then the first record would be the latest added record. This would need 2 calls to the api though.

See Solution in Thread

2 Replies 2

There is no way to identify the “last row” in a table without requesting all of the rows in the table or view. This is because different views of the same table can include different records in different orders. 

In order to update a cell value, you need to know the record ID of the record, not just it’s relative position. 

Steve_Haysom
8 - Airtable Astronomer
8 - Airtable Astronomer

if you add an autonumber field and then sort by that field descending, then the first record would be the latest added record. This would need 2 calls to the api though.