# Copy a value in the entire column

**URL:** <https://community.glideapps.com/t/copy-a-value-in-the-entire-column/79228>\
**Category:** Ask for Help\
**Created:** [January 15, 2025, 10:26pm UTC](https://community.glideapps.com/t/copy-a-value-in-the-entire-column/79228 "2025-01-15T22:26:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\
**Post date:** [January 15, 2025, 10:26pm UTC](https://community.glideapps.com/t/copy-a-value-in-the-entire-column/79228/1 "2025-01-15T22:26:51Z")

</div>

Hello Gliders. My app has many users. Some have the role of ADMIN and others WORKERS. In the morning an ADMIN will set the exchange rate writing it in his user profile, in the “exchange rate” column. At that point I would like to copy that exchange rate to all rows in the USER table. How do I do it?  
Then, I use that exchange rate to calculate money amounts in the EXPENSES table. But since an ADMIN changes the exchange rate every morning, the money amounts change every day. I dont want that. Money amounts calculated in one day must stay fixed. How do I fix this?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 15, 2025, 10:49pm UTC](https://community.glideapps.com/t/copy-a-value-in-the-entire-column/79228/2 "2025-01-15T22:49:45Z")

</div>

> [@mbraunperu](#):
>
> In the morning an ADMIN will set the exchange rate writing it in his user profile, in the “exchange rate” column. At that point I would like to copy that exchange rate to all rows in the USER table.

Don’t write it to the user profile. Write it to a different table and use a single value column to bring it into the user table.

> [@mbraunperu](#):
>
> the money amounts change every day

You should be writing that expense rate to the expense table when a row is added so it sticks at that point in time when using it in your math.

---

<div class="post-metadata">

**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\
**Post date:** [January 15, 2025, 11:38pm UTC](https://community.glideapps.com/t/copy-a-value-in-the-entire-column/79228/3 "2025-01-15T23:38:13Z")

</div>

Awesome Jeff. Thanks!!!

---

<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:** [January 22, 2025, 11:38pm UTC](https://community.glideapps.com/t/copy-a-value-in-the-entire-column/79228/4 "2025-01-22T23:38:52Z")

</div>

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