# Copy a Computed Column into a Basic column automatically

**URL:** https://community.glideapps.com/t/copy-a-computed-column-into-a-basic-column-automatically/81630
**Category:** Feature Requests
**Created:** [April 30, 2025, 3:27pm UTC](https://community.glideapps.com/t/copy-a-computed-column-into-a-basic-column-automatically/81630 "2025-04-30T15:27:12Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [April 30, 2025, 3:27pm UTC](https://community.glideapps.com/t/copy-a-computed-column-into-a-basic-column-automatically/81630/1 "2025-04-30T15:27:12Z")

</div>

Since GBT can’t handle Computed Columns, can Glide create a Basic column that is a copy of computed column? One that automatically writes the value of the Computed Column to a Basic text column?

Call it a Sync Basic type that takes a computed column as its input and writes the value to a Basic Column.

This solves 99% of the reason why devlopers don’t/can’t use GBT. Frankly, there are probably less than a dozen computed columns in even the most complex tables that would need this feature - but they REALLY need it to make the App work when migrating to GBT.

In my case I use working tables when creating new objects (for the most part) and can write to Basic columns instead of computed columns in the new object (the computed column is in the working table).

But when importing data I have to transform the ‘compute column’ outside of Glide into a Basic column so the App works.

Better would be a Column type (Basic) that automatically copies a computed column result into a Basic column type. Instead of copy/paste transformation.

> [@From Computed Column to new Column as raw values in the same Glide table](https://community.glideapps.com/t/from-computed-column-to-new-column-as-raw-values-in-the-same-glide-table/79236):
>
> Hi, How to make a Copy of computed Column and Paste as raw value in a new column of the same Glide Table ( like Excel Copy and Paste as value) regards

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 30, 2025, 3:45pm UTC](https://community.glideapps.com/t/copy-a-computed-column-into-a-basic-column-automatically/81630/2 "2025-04-30T15:45:36Z")

</div>

There has been talk about something like this, but I don’t know if it’s actually on the roadmap. I hope so 🙂

For now, my go to solution when I discover I need to move a computed column to a non-computed column is as follows:

- Export as CSV
- Import into a Google Sheet
- Insert the column I need and populate it (usually with an arrayformula)
- Export as CSV
- Import back into Glide

It’s a bit fiddly, but it gets the job done.

---

<div class="post-metadata">

### Author: ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [April 30, 2025, 4:16pm UTC](https://community.glideapps.com/t/copy-a-computed-column-into-a-basic-column-automatically/81630/3 "2025-04-30T16:16:37Z")

</div>

My process is I need to seed a lot of data sets then import them into Glide. I am now reproducing (via lookups and other formulas) Glide formulas in Excel so I can export/import them into Glide.

These two tables, unfortunately, are used literally everywhere. These tables have about 100 columns each and so far 5 computed columns drive a LOT of other tables. Thanks for the confirmation that this is a goto solution.

Most objects I create I use computed columns so I can move compute columns into the working table and copy the result into a Basic column as I add new objects.

Also, these two tables started as Google sheets so the pain is triple since I had to migrate them GBT then re-wire all the other computed columns THEN re-wire all the screens.

This is the last phase 🤞…to a “scale out” Glide App.

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [April 30, 2025, 4:44pm UTC](https://community.glideapps.com/t/copy-a-computed-column-into-a-basic-column-automatically/81630/4 "2025-04-30T16:44:29Z")

</div>

You could use my [https://real-time-workflow.mbci.space/](https://real-time-workflow.mbci.space/) input update AI Component to execute a set column value action when the value in the computed column changes.
