# Bulk modify database without a unique id?

**URL:** <https://forum.bubble.io/t/bulk-modify-database-without-a-unique-id/39092>\
**Category:** Database\
**Created:** [October 2, 2018, 4:14pm UTC](https://forum.bubble.io/t/bulk-modify-database-without-a-unique-id/39092 "2018-10-02T16:14:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![robert](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/robert/32/149181_2.png) [@robert](https://forum.bubble.io/u/robert)\
**Post date:** [October 2, 2018, 4:14pm UTC](https://forum.bubble.io/t/bulk-modify-database-without-a-unique-id/39092/1 "2018-10-02T16:14:29Z")

</div>

I want to update records in the database, but I don’t have the “unique id”. I have a unique text field that could be used to locate the record.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![robert](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/robert/32/149181_2.png) [@robert](https://forum.bubble.io/u/robert)\
**Post date:** [October 2, 2018, 5:17pm UTC](https://forum.bubble.io/t/bulk-modify-database-without-a-unique-id/39092/2 "2018-10-02T17:17:04Z")

</div>

Apparently, the answer is no. Will update this if I am mistaken.

---

<div class="post-metadata">

**Author:** ![mishav](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mishav/32/6420_2.png) [@mishav](https://forum.bubble.io/u/mishav)\
**Post date:** [October 9, 2018, 11:54am UTC](https://forum.bubble.io/t/bulk-modify-database-without-a-unique-id/39092/3 "2018-10-09T11:54:54Z")

</div>

Did some robotic voice say no?

You can search the database for any of the different fields as constraints. Perhaps the interactive lessons would help: [https://bubble.io/lessons](https://bubble.io/lessons)

Edit - I didn’t notice the “bulk” part … once you have a search result list of records to update, the best approach is likely to be either a recursive scheduled API workflow, or a Data API call.

---

<div class="post-metadata">

**Author:** ![robert](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/robert/32/149181_2.png) [@robert](https://forum.bubble.io/u/robert)\
**Post date:** [October 9, 2018, 1:11pm UTC](https://forum.bubble.io/t/bulk-modify-database-without-a-unique-id/39092/4 "2018-10-09T13:11:08Z")

</div>

I consulted with a bubble coach, and the answer was confirmed as a no. The easiest solution was to download the data i wanted to modify (with the unique ID), then match it up in excel (with the other field), using the Vlookup function, then copy and paste the values (without the formula), then to save as csv, and then to do the bulk modify function in Bubble.
