# How to loop through spreadsheet rows

**URL:** https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295
**Category:** Questions about Thunkable X
**Created:** [September 20, 2023, 2:00pm UTC](https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295 "2023-09-20T14:00:31Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [September 20, 2023, 2:00pm UTC](https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295/1 "2023-09-20T14:00:31Z")

</div>

I can’t find the get all rows block in the DND platform,and that has made it difficult for me to compare in a new object to be created is equal to an existing row in other to avoid duplicate records…

Something like this…

 ![IMG_20230920_113821_227](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f8fec8734e6cfc46678e98d5f898ba8468dc429.jpeg)

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [September 20, 2023, 2:14pm UTC](https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295/2 "2023-09-20T14:14:33Z")

</div>

You can get one row of data or one column of data at a time but not all rows.

---

<div class="post-metadata">

### Author: ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [September 20, 2023, 5:51pm UTC](https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295/3 "2023-09-20T17:51:37Z")

</div>

So how do I avoid users from having similar usernames on the app?  
Remember the check if a new username already existed ,if it’s true,it tells the current or new user to pick another name.  
All these records will be saved and retrieved from Airtable spreadsheet.  
TIA

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [September 20, 2023, 6:45pm UTC](https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295/4 "2023-09-20T18:45:45Z")

</div>

I would use Firebase for sign in since it manages userIds for you. Although that’s mostly useful if you’re also storing user data in Firebase.

But I’d you prefer to manage it yourself in Airtable, you can use the “find first occurrence” list block to determine if there is a row in the “list of values” (another block) for your userId column.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [December 19, 2023, 6:46pm UTC](https://community.thunkable.com/t/how-to-loop-through-spreadsheet-rows/2605295/5 "2023-12-19T18:46:02Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.