# Store Linked Data as Static Value in Glide App

**URL:** <https://community.glideapps.com/t/store-linked-data-as-static-value-in-glide-app/76321>\
**Category:** Ask for Help\
**Created:** [September 12, 2024, 1:51pm UTC](https://community.glideapps.com/t/store-linked-data-as-static-value-in-glide-app/76321 "2024-09-12T13:51:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Perseu\_Oliveira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perseu_oliveira/32/79602_2.png) [@Perseu\_Oliveira](https://community.glideapps.com/u/Perseu_Oliveira)\
**Post date:** [September 12, 2024, 1:51pm UTC](https://community.glideapps.com/t/store-linked-data-as-static-value-in-glide-app/76321/1 "2024-09-12T13:51:59Z")

</div>

I have a table that registers appointments, including the person for whom the appointment is made. In the people’s table, there is a column called **status** , which changes over time. In the appointments table, there is a column where I want to save the status of the person **at the time** the appointment was made by linking the status.

My issue is that the status I save in the appointments table is a computed column, so it reflects the status in real time. I want to save the actual value of the status at the moment the appointment is created, rather than just linking to the real-time status.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [September 12, 2024, 2:04pm UTC](https://community.glideapps.com/t/store-linked-data-as-static-value-in-glide-app/76321/2 "2024-09-12T14:04:46Z")

</div>

I think you could submit the status through a user profile column when you create the new row.

You’ll need one more column in the appointments table to hold the status value.

> **[User Profile Columns | Glide Docs](https://www.glideapps.com/docs/user-profile-columns)**
>
> Work with user data from anywhere in your app.

---

<div class="post-metadata">

**Author:** ![Perseu\_Oliveira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perseu_oliveira/32/79602_2.png) [@Perseu\_Oliveira](https://community.glideapps.com/u/Perseu_Oliveira)\
**Post date:** [September 12, 2024, 2:42pm UTC](https://community.glideapps.com/t/store-linked-data-as-static-value-in-glide-app/76321/3 "2024-09-12T14:42:25Z")

</div>

Thank you for the suggestion! I don’t mind creating a new column, but I need to apply this to the rows that have already been created. Is there a way to save the status for the existing rows as well?

---

<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:** [September 12, 2024, 3:10pm UTC](https://community.glideapps.com/t/store-linked-data-as-static-value-in-glide-app/76321/4 "2024-09-12T15:10:06Z")

</div>

How many rows? Could you just update existing rows manually through the data editor?

Otherwise you could add a temporary collection to any screen pointing to the appointments table and filter it to show rows where the new column is empty. Then set the click action on the collection to Set Column and have it copy the computed column value to the new column. Then rapid click through all items in the collection until all of them are gone. Finally you can remove that collection from the screen since you won’t need it anymore.