# How to get value from spreedsheet to calculate **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [October 29, 2018, 4:01am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109 "2018-10-29T04:01:07Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![kraftgirl](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kraftgirl](https://community.thunkable.com/u/kraftgirl)\ **Post date:** [October 29, 2018, 4:01am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/1 "2018-10-29T04:01:07Z")
I have the material types and their constants in the Airtable as shown. I would like to get value in the table for calculation after selects the material type. For example, after I select Copper (anneal soft-drawn), I would like to get the value of Thermal Coefficient, Resistivity of material and TCAP to calculate. How should I do? Please advice me. Thank you. ![Airtable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/c/fc152ec605db0d9dcacae08ea15fecef0c92ad98.jpeg) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 29, 2018, 8:33am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/2 "2018-10-29T08:33:22Z")
1. Download all data from the AirTable to the List. As the key, you can use the name of the material 2. From this list, create a ListViewer with the names of materials (keys) 3. When choosing a material (key) from the ListViewer, look for the record in the List using this key and after finding it, you will receive all the necessary fields of this record. 4. Perform the necessary actions with the values ​​of the fields received ---
**Author:** ![Farshad](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/farshad/32/27108_2.png) [@Farshad](https://community.thunkable.com/u/Farshad)\ **Post date:** [October 30, 2018, 5:43am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/4 "2018-10-30T05:43:28Z")
Hello, please, explain more about how to create key Can I download the entire table at the first run of the app and allow access to the information without the need for the Internet? ---
**Author:** ![kraftgirl](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kraftgirl](https://community.thunkable.com/u/kraftgirl)\ **Post date:** [October 30, 2018, 7:01am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/5 "2018-10-30T07:01:08Z")
Hi actech Thank you for your suggestion. But I’m a newbie for this application. Could you please explain more about how to download data to the list. I have to use the local storage to download the data, haven’t I? Could you please show me the block for the example? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 30, 2018, 2:20pm UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/6 "2018-10-30T14:20:55Z")
Basic example of loading data into a list and displaying the values ​​of the Name column in a ListViewer ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c248d98dc120dd7bb73ac3984c11c0f806691b49.png) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 30, 2018, 2:26pm UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/7 "2018-10-30T14:26:56Z")
To download all the data, the GetAllRows block is used. In the example shown above, instead of the Name field, specify your Material Type field. If your material is displayed in the ListViewer, then create a handler for clicking on the list item, get its value (item), and then find the row in the source “list” that matches the selected material. ---
**Author:** ![kraftgirl](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kraftgirl](https://community.thunkable.com/u/kraftgirl)\ **Post date:** [October 31, 2018, 7:08am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/8 "2018-10-31T07:08:10Z")
Hello actech Thank you for your advices. Now I can download all data from Airtable and show the list of material type on the screen. After I select the material type, the name of material will show on the label. But I confused about how to get the value of the selected material. Which block I can use? I would like to get the value for calculation after click the calculate button. Actually, I’m not familiar with any programming. So, I have to ask you more detail. Thank you. ![List%20viewer](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/5/f5f94edf5eca32b466930584acb2fe80317ce57c.jpeg) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 31, 2018, 8:04am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/9 "2018-10-31T08:04:42Z")
First an empty object is created. Then we perform a search row, which corresponds to the selected material. After that you can get all the fields of the record that matches the found material. Instead of my data field names, you need to substitute field names from your table. \_id is the unique identifier for the entry in the AirTable. We use the name of the material as the key, but in fact it is better to use this \_id as the key, because the names can be the same, and \_id is unique. But the algorithm using \_id is a bit more complicated. ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/1/71709f06c64e94205ebbb272eec1c26d4e96f1a4.png) ---
**Author:** ![kraftgirl](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kraftgirl](https://community.thunkable.com/u/kraftgirl)\ **Post date:** [November 1, 2018, 6:17am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/10 "2018-11-01T06:17:02Z")
Hi actech Thank you for your helping. Now I can complete my app. Thank you so much. ---
**Author:** ![Farshad](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/farshad/32/27108_2.png) [@Farshad](https://community.thunkable.com/u/Farshad)\ **Post date:** [November 2, 2018, 1:11am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/11 "2018-11-02T01:11:02Z")
Thank you so much. 🙏🙏💐💐 ---
**Author:** ![nangginlianaig](https://avatars.discourse-cdn.com/v4/letter/n/e47774/32.png) [@nangginlianaig](https://community.thunkable.com/u/nangginlianaig)\ **Post date:** [April 27, 2020, 5:40pm UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/12 "2020-04-27T17:40:01Z")
I want to create song book apps. I save my data in airtable with two column… And i want to download in local db… Is this block which you have shown will work for me too…??? ---
**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, 11:31am UTC](https://community.thunkable.com/t/how-to-get-value-from-spreedsheet-to-calculate/54109/13 "2024-11-08T11:31:47Z")