# Data viewer list to airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [October 7, 2021, 7:22pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960 "2021-10-07T19:22:38Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 7, 2021, 7:22pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/1 "2021-10-07T19:22:38Z")
Hi, how do I create a row in airtable for every row in a list? I scan a QR Code to get items for my list (which can be any number of items) then I want to write data back to airtable with additional data (this is from a seperate screen). I may be better off using a data list but not sure if this will help In case a work around is best, I am trying to check out bikes and the process is, - scan bikes to add to list, autofill rental contract with bikes on list, once contract is signed then add bikes to rented out list with a start time and contract number. -then check in is: scan first bikes code which brings up all items associated with the same rental contract, and as each item is scanned it is removed from the list. ---
**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:** [October 7, 2021, 9:37pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/2 "2021-10-07T21:37:44Z")
This shouldn’t be too hard to do. In fact, I would argue that Thunkable is uniquely designed for just this sort of app! Can you clarify: 1. When a user scans a QR code, is the QR scanner recording a text string such as “Mongoose” (or say, a serial #)? And would the user scan several bikes at one time to produce the list you mentioned? 2. So therefore a user might scan three bikes and create the list {“Mongoose”,“Diamondback”,“Cannondale”}? And then the user fills out a single set of information that applies to all three bikes? Or do they fill out three sets of similar information? ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 7, 2021, 10:03pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/3 "2021-10-07T22:03:44Z")
when items are scanned a list is created as below (bike name and serial number from airtable) ![IMG_B630F85B64FF-1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/4/f4e7cd3fd5aaa4ad9104a9cde89c6a84d242bed0.jpeg) then the data in the list is used in the next screen to fill out a contact (a pdf of which is emailed) as below ![IMG_5754](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/2/32fc2255d327c19f8b00827d64cbf36e156e43b9.png) when the contract is submitted a unique code is created (and saved to the clipboard to be pasted into ChargeStripe for a credit card hold) I want to upload each item to a seperate row in airtable so I can later recall each item, with this unique code, separately. (up to a week later) ---
**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:** [October 7, 2021, 10:10pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/4 "2021-10-07T22:10:14Z")
When you scan each QR code, use the Create Row block in the Data Sources drawer and add the QR result value(s) to the column(s) in AirTable. It would look something like this (I’m using the Snap to Place interface so the exact blocks may be a little different): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/a/2af41bfd39059d0ce3ef979205b10ffd11428730.png) This video shows something similar: See this video instead: [How to Add Data to AirTable from Your Thunkable App - YouTube](https://www.youtube.com/watch?v=bnUX2zCQTHo). ---
**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:** [October 7, 2021, 10:12pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/5 "2021-10-07T22:12:49Z")
And actually, since all three (or however many) bikes will correspond to the same user, you might want to save a list to Airtable – if possible – or create a row for each bike as I’ve shown above but include a UserID or some other unique value so that you can go back and search for that user’s bikes/rows later. ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 7, 2021, 10:24pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/6 "2021-10-07T22:24:45Z")
I have that part sorted but I want to add the bikes from another screen from where they are scanned, and they are currently saved as a list variable scanned here ![Screen Shot 2021-10-08 at 12.21.47 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c273117ef24224a158c7c78731880201dec06b30.png) then want to upload each item as new row from here (Currently all items are in one field) ![Screen Shot 2021-10-08 at 12.23.20 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/c/8c1ebd0b004e235c8e4df0dcbb18242f8f540a19.png) ---
**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:** [October 7, 2021, 10:31pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/7 "2021-10-07T22:31:46Z")
If you have the bikes in a list, I’d consider converting the list to text and then storing that text in Airtable. I had taken this screenshot before you posted that but it may be helpful: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/9/89f10d36eecd6d8e711285ffe19db65837000a57.png) Just replace the three-item list I have with your List variable. It looks like maybe you’re already doing that. ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 8, 2021, 6:53am UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/8 "2021-10-08T06:53:38Z")
thanks, however I have 34 bikes in 5 locations and in 3 months it will be another 14 bikes and another 10 locations. It needs to be a central database where I can manage the bikes. One way I thought of (in the middle of the night 😐) is add the bikes to airtable in the first screen as they are scanned, with the unique code generated there, then use that code as a variable in the second screen to update all entries in airtable with that code (update would be time and confirmation the contract was signed) ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 10, 2021, 6:48pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/9 "2021-10-10T18:48:30Z")
@tatiang @muneer I know this is a stupid question but how do I update “all” not just “in list find first/last occurrence” ![Screen Shot 2021-10-10 at 9.12.24 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/1/8136a5e7accba59a2de73a14692da2e7a420097f.png) ---
**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:** [October 10, 2021, 7:22pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/10 "2021-10-10T19:22:53Z")
No stupid questions… we all had to start somewhere! 😉 The `first occurrence of item` block returns an integer based on the position of the list item that matches. So if you had a list like {“orange”,“red”,“yellow”} and you got the first occurrence of “yellow” that block would return 3 since it’s the third position in the list. Can you explain what you mean by “update all”? Are you trying to change the value of all list items? Or change the value of all cells in an Airtable column? Or something else…? ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 10, 2021, 7:30pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/11 "2021-10-10T19:30:39Z")
I want to update every row that has a certain identifier. ![Screen Shot 2021-10-10 at 9.25.53 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/7/c7dcd2956c48ed8b5dd8f62cbd3ef96827149ccf.png) Rows 6-8 were added in one screen, I then want to update them on another screen when a contract is signed. The number in the identifier column is saved as “app variable Unique Code” so it should be easy. I can share my project if it would help ---
**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:** [October 10, 2021, 7:33pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/12 "2021-10-10T19:33:58Z")
You can only do that using a loop. There is not a single block that will accomplish what you want. It would be something like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/1/a10dcbc0d00fad514978d5e5d2418856c2119cb5.png) ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 10, 2021, 7:49pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/13 "2021-10-10T19:49:12Z")
A loop as in, find first were identifier = variable AND name = null, update row, then rerun until no more instances? (there could be up to 20 instances) just saw the screen shot, will try that Thanks ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 17, 2021, 6:48pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/14 "2021-10-17T18:48:03Z")
@muneer @tatiang I got that part all sorted for the checkout process but now for the checkin I need to go back to updating every Airtable row that has an item mentioned in a variable list. Is there an easy way to do this or do i need to split up the list and work through each item separately? ---
**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:** [October 17, 2021, 9:06pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/15 "2021-10-17T21:06:53Z")
Can you please show example or give more details. I did not understand your question. ---
**Author:** ![bikeon.kfte5](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bikeon.kfte5](https://community.thunkable.com/u/bikeon.kfte5)\ **Post date:** [October 18, 2021, 1:19pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/16 "2021-10-18T13:19:01Z")
![IMG_7A635FC3474D-1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8bebe268b9aa3c59682287d10278555e18dead24.jpeg) When I click on ‘Check In’ I want to update the airtable rows that are the same as my ‘Items to be returned’. The list varies in length. I want to put CI time in Airtable. Is there an easy way to UpdateRowNum with rowNum as a list (several rows). Or do I need to seperate the list variable and update each row separately. ![Screen Shot 2021-10-18 at 9.49.43 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/b/5b4bace229b60feeb258e89512ac17cae09b6892.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:** [October 18, 2021, 1:55pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/17 "2021-10-18T13:55:15Z")
Unfortunately there is no “bulk update” feature or method in Thunkable nor in Airtable itself. You will have to loop through the rows and update relevant rows matching your criteria. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/data-viewer-list-to-airtable/1549960/18 "2024-11-08T13:14:55Z")