How to get last row from airtable

emilpapelas4 · October 10, 2021, 3:41pm

Hello koders i ask if posible to get last row from airtable. if possible how please help me…

dora_paz · October 10, 2021, 4:06pm

Either get all rows and get data for last item in list or call a column and the lenght of list will give the last row number, then call row with that number

Still-learning · October 10, 2021, 4:07pm

First get all row, count it(using length of the list in a variable) Then Use the number(variable)

emilpapelas4 · October 10, 2021, 4:10pm

any example because not figure how to setup.

dora_paz · October 10, 2021, 4:13pm

Still-learning · October 10, 2021, 4:13pm

Initialise global last row to empty string
When screen initialise
Call spreadsheet get all rows
When spreadsheet got all rows
A.Set global last row to get total rows
B.Call spreadsheet get row
Number - get global last row

emilpapelas4 · October 10, 2021, 4:14pm

let me check

emilpapelas4 · October 10, 2021, 4:25pm

like this?

emilpapelas4 · October 10, 2021, 4:44pm

like this?

dora_paz · October 10, 2021, 4:49pm

emilpapelas4 · October 10, 2021, 4:56pm

Good works now is possible to get also image , users , amount from that row?

Still-learning · October 10, 2021, 4:59pm

You can try this way too… It will give you the total tow values as a list

emilpapelas4 · October 10, 2021, 5:02pm

is not ok i want each label to get a value

Still-learning · October 10, 2021, 5:04pm

Then use select list item list

Index 1 will give you column 1 value
Index 2 will give you column2 value

emilpapelas4 · October 10, 2021, 5:06pm

where need to add select list item?

Still-learning · October 10, 2021, 5:11pm

emilpapelas4 · October 10, 2021, 5:12pm

I want to get like this.

Label 1 to get - Test-3
Image- image
label2- Emil
label3-33

dora_paz · October 10, 2021, 5:14pm

And were is the problem to get them from list ? Select List item list get values index 1 will give you Test3 index2 image, index3 Emil and index 4 33

Still-learning · October 10, 2021, 5:19pm

Do you want still more clarity even after reading the post no 17&19???

get values is the main list- it will gives you the last row value as a single list. You can split them into individual cell value just by using proper index number as said by Dora. Pls try. Even if the get values gives you wrong order you can catch them or arrange them as you like by using exact index number

emilpapelas4 · October 10, 2021, 5:21pm

WORK NOW but having problem getting image