# How to Find rowNum? **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [December 18, 2020, 5:31am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483 "2020-12-18T05:31:58Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 18, 2020, 5:31am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/1 "2020-12-18T05:31:58Z")
How to find rowNum form airtable with Email Data ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 8:16am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/2 "2020-12-18T08:16:15Z")
Can you explain more. The rowNum is the rowID of the data viewer list / grid. Also the ID column in list of values component ![list_of_values](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/4/24a998ad2033ffe4ea3a9cdca43075ddcb299def.png) ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 18, 2020, 11:42am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/3 "2020-12-18T11:42:54Z")
Okay. I have a need for a system. Log in and remember My user with FireBase . I have created the registration page and once registered, the information will be sent to the airtable. ![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/5/259ec19762992e050bcedcda2b3edb1382f65a25.png) When the registration is complete, it will come to the login page. I want to send the user ID information to Airtable in the same row registered earlier. What tools do I need to know the rownum to pass data to the same row of data? ![2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/1/c1b0f3a1c22ff14894225f01128f59f8c871de84.png) You understand what I’m going to explain or not ? Thankyou ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 12:38pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/4 "2020-12-18T12:38:20Z")
In the ButtonSignup [click] event you have a [CreateRow] which returns (gives back) rowID. In the [then do] you are checking for error, add [else] and save the green [row] to a variable so you can use it later in your code. Why do you have **TWO** click events to the same ButtonSignup? Happy Thunking 😁 ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 18, 2020, 2:04pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/5 "2020-12-18T14:04:05Z")
![3](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/5/855dc2b5a113f0a42d0368b4ffe69ae24d4f7ad3.png) ![4](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/a/9a533f41ecd1d0cc098385ce2aa1c059a07175ef.png) I tried testing it and it didn’t work. The [Row] received is not an integer and therefore cannot be used. The value of [rowNum] must be an integer only. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 2:29pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/6 "2020-12-18T14:29:12Z")
Can we do some debugging work just to be certain what we have. Creat two labels in the form and in the ButtonSignup block assign the variable to the label just after you get the ]row] so the [else] will have two blocks, the one available now and also the label.text= app variable Current Row Num. This way the label in the screen will show what is held by the variable. Also do the same for ButtonLogin but this time it will be the first block inside the If statement and before [UpdateRowNum] Label.text=app variable Current Row Num Make sure you are referring to the same thing. Let me know the outcome. ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 18, 2020, 3:02pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/7 "2020-12-18T15:02:12Z")
This is the output. [Label.text] = [App Current Row Num]. It’s not a number. This indicates that the value obtained from [Row] is not [Rownum]. ![5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/9/49150193b6664412335cdf344c6e449766b92cf7.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 3:43pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/8 "2020-12-18T15:43:26Z")
Great. You are getting the row ID as an email bject. Use this block to convert it to text ![assets_-LAn5scXl2uqUJUOqkJo_-LAn5wecEraNWaG7Ig2g_-LAn6B2DqDAOPYpJXV8k_blocks-object-✕-fig-3](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/6/b67f6624fadac1e3067b348201bf9dd319bafc74.png) Label.text= generate JSON from object [variable goes here] ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 18, 2020, 4:00pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/9 "2020-12-18T16:00:50Z")
My results Is the number 0, which is an integer But the value is always displayed as 0. ![6](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/3/e31e158c891e8aad7a8735b447f465a6c8809a08.png) ![7](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/6/f67661dcd70da1b14403a1ab4b32b52b5400298d.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 4:03pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/10 "2020-12-18T16:03:02Z")
Is this after the CreateRow block was executed or before? ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 18, 2020, 4:13pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/11 "2020-12-18T16:13:40Z")
![8](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/0/000b7ad6afeedac5b2744609900fbb4d0d08fdf4.png) I’ve tried checking the [create row] block. I have seen my mistakes and I will update this blog. I will show you the results tomorrow. Good night ---
**Author:** ![LuEllaBella](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@LuEllaBella](https://community.thunkable.com/u/LuEllaBella)\ **Post date:** [December 18, 2020, 4:24pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/12 "2020-12-18T16:24:56Z")
Is it doing that because you’re using ‘create object with fields’? I actually often have a column in airtable to save rowids because I will sometimes need them later. But I also use a variable to store it. This is how I have mine set up. When I test this the row number is saved in airtable as a number. ![Thunkable 2020-12-18 100126](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/3/b39439c2b684550725f4a588d7f6767562f3c296.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 5:00pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/13 "2020-12-18T17:00:00Z")
Why would you do that. This is just duplication of effort. There is an invisible field (column) that stores rowID already. Just use the component [list of values] and use the column as ID. ![list_of_values](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/4/24a998ad2033ffe4ea3a9cdca43075ddcb299def.png) ---
**Author:** ![LuEllaBella](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@LuEllaBella](https://community.thunkable.com/u/LuEllaBella)\ **Post date:** [December 18, 2020, 5:04pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/14 "2020-12-18T17:04:57Z")
It’s a long story. My app is very convoluted and I’m a novice! 😄 ---
**Author:** ![LuEllaBella](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@LuEllaBella](https://community.thunkable.com/u/LuEllaBella)\ **Post date:** [December 18, 2020, 5:07pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/15 "2020-12-18T17:07:33Z")
However, they can ignore the part about me storing it in the column. That wasn’t really the point of my response. Simply explaining why I have it set up the way I do in the screenshot. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 18, 2020, 5:12pm UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/16 "2020-12-18T17:12:12Z")
The new UI from Thunkable Airtable is made part of the Data Source block in the code screen and therefore we should get used to use these blocks instead of the specific Airtable blocks. Anyway, don’t bother yourself with my comments as long as your App works. Happy Thunking ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 19, 2020, 3:55am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/17 "2020-12-19T03:55:32Z")
![9](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/4/54ac87db5bfecafa981ff7025ec4ae08b1b21977.png) This is the output [Label.text] = generate JSON from object [Row]. It was all of that row’s data, but not the [Rownum] we wanted. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 19, 2020, 4:01am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/18 "2020-12-19T04:01:05Z")
It is “\_id” You can obtain it by using the component “get property from object” in the object drawer ---
**Author:** ![tanasetaro](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanasetaro/32/92072_2.png) [@tanasetaro](https://community.thunkable.com/u/tanasetaro)\ **Post date:** [December 19, 2020, 5:40am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/19 "2020-12-19T05:40:46Z")
Thanks for help @muneer @LuEllaBella I found a way to store data with Component [datasource] in a very easy way. ![11](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/3/93430beeb6a09b34b2ae90b2da495493fc623312.png) ![10](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/6/26b9e3008366c552a3b565ba451b689cff64c321.png) Before, I came up with a very complicated method, it was confusing and impossible to do. In fact, it is not as difficult as you think. Perhaps complicated thinking is a tricky way, there is always a way to make it easier. Thank you all. Good luck ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 19, 2020, 6:18am UTC](https://community.thunkable.com/t/how-to-find-rownum/1039483/20 "2020-12-19T06:18:15Z")
I’m very happy you solved it. The Data Source drawer is the new way for Thunkable coding and if you open a new project you will no longer see the blocks specific for Airtable and you will have to use the Data Source blocks for all data needs. 👏 [Next page](https://community.thunkable.com/t/how-to-find-rownum/1039483.md?page=2)