# How to update the datalist thru a unique value field?

**URL:** <https://community.yeeflow.com/t/how-to-update-the-datalist-thru-a-unique-value-field/207>\
**Category:** Ask the community\
**Created:** [September 25, 2023, 2:04am UTC](https://community.yeeflow.com/t/how-to-update-the-datalist-thru-a-unique-value-field/207 "2023-09-25T02:04:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnny](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@johnny](https://community.yeeflow.com/u/johnny)\
**Post date:** [September 25, 2023, 2:04am UTC](https://community.yeeflow.com/t/how-to-update-the-datalist-thru-a-unique-value-field/207/1 "2023-09-25T02:04:11Z")

</div>

Hi Yeeflow,

How can I use my fields to update my records, besides export records with field “ID”?

I usually update my device status records from excel file( about 4000 Items), the field “Device Name” is the unique value, I want thru this field update my device status in yeeflow.

thanks!

---

<div class="post-metadata">

**Author:** ![frank](https://avatars.discourse-cdn.com/v4/letter/f/3d9bf3/32.png) [@frank](https://community.yeeflow.com/u/frank)\
**Post date:** [September 26, 2023, 2:52am UTC](https://community.yeeflow.com/t/how-to-update-the-datalist-thru-a-unique-value-field/207/2 "2023-09-26T02:52:01Z")

</div>

Hi Johnny, sorry, that the data ID is the key field to update existing data. An idea is you can export list data to excel with data ID and then use a vLookup function to sync the device status from your existing excel by the unique Device Name.

---

<div class="post-metadata">

**Author:** ![johnny](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@johnny](https://community.yeeflow.com/u/johnny)\
**Post date:** [September 26, 2023, 2:58am UTC](https://community.yeeflow.com/t/how-to-update-the-datalist-thru-a-unique-value-field/207/3 "2023-09-26T02:58:02Z")

</div>

Thanks Frank. I will try.