# How to Preserve Queried/Looked-up Values

**URL:** <https://community.glideapps.com/t/how-to-preserve-queried-looked-up-values/81320>\
**Category:** Ask for Help\
**Created:** [April 13, 2025, 11:54pm UTC](https://community.glideapps.com/t/how-to-preserve-queried-looked-up-values/81320 "2025-04-13T23:54:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\
**Post date:** [April 13, 2025, 11:54pm UTC](https://community.glideapps.com/t/how-to-preserve-queried-looked-up-values/81320/1 "2025-04-13T23:54:39Z")

</div>

Hello,  
I have a Glide table (Table A) that pulls data from another Glide table (Table B, which syncs with a Google Sheet) using a **Query** and **Lookup** setup. For example, Column 1 in Table A gets numeric values from Table B as new data is added daily in the Google Sheet.

To manage row limits, we regularly delete old rows from Table B. The problem is: once those rows are deleted, the relation breaks, and the data in Column 1 of Table A disappears.

What I want to do is **preserve the looked-up values (as static numbers) in Table A** automatically everyday—so we retain the historical record.

**Question:**  
What’s the best way to automate this everyday without causing too many updates?

Thanks in advance for any suggestions or tips!

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [April 14, 2025, 12:01am UTC](https://community.glideapps.com/t/how-to-preserve-queried-looked-up-values/81320/2 "2025-04-14T00:01:01Z")

</div>

You can use Scheduled Workflows, but they’ll end up costing a lot of updates over time. I think your best option is to create a non-computed basic number column in Table A, and manually copy the entire Lookup column into it.

It won’t be automatic, but it’s a quick one-time step you can do before deleting the old rows from Table B. The best part is it won’t use any updates at all 🙂

---

<div class="post-metadata">

**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\
**Post date:** [April 14, 2025, 1:52pm UTC](https://community.glideapps.com/t/how-to-preserve-queried-looked-up-values/81320/3 "2025-04-14T13:52:23Z")

</div>

@Hassan_Nadeem Thank you for your quick response and insights!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 21, 2025, 1:53pm UTC](https://community.glideapps.com/t/how-to-preserve-queried-looked-up-values/81320/4 "2025-04-21T13:53:05Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.