# Syncing columns between Glide and Google Sheets **URL:** \ **Category:** Ask for Help\ **Created:** [July 17, 2023, 10:23am UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005 "2023-07-17T10:23:02Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 17, 2023, 10:23am UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/1 "2023-07-17T10:23:02Z")
I based an app on Google Sheets. The already present columns were showed up in Glide. Great! But then I started adding columns in Glide. Some show up in Google Sheets, some not? What’s the criteria? I’d really like to see some columns (Math, Excel Formula) I added in the Google Sheet. Sure, any “computed” columns won’t carry over the computation to Google Sheets. But at least the values could be synced, I thought. ---
**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:** [July 17, 2023, 10:29am UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/2 "2023-07-17T10:29:28Z")
No, only non-computed columns will appear and sync in the Google Sheet. I’ve never really thought about it too much, but I guess this is probably a side effect of having all computed columns evaluated client side. ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 17, 2023, 12:04pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/3 "2023-07-17T12:04:01Z")
> I’ve never really thought about it too much, but I guess this is probably a side effect of having all computed columns evaluated client side. Hm… that would mean the value are nowhere except during execution on a client. Advantage: No persistent storage needed for them. Disadvantage: They need to be recalculated over and over again. Anyway: Any suggestion for how to get at them for producing reports? Or even seeing them in a Google Sheet? ---
**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:** [July 17, 2023, 12:07pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/4 "2023-07-17T12:07:26Z")
The biggest advantage is an app that responds instantly instead of waiting for for data to sync back and forth between the glide servers and the google servers. If you can add a set column action as part of your flow, then you can take this computed values and write them to basic columns in your data. ---
**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:** [July 17, 2023, 12:09pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/5 "2023-07-17T12:09:01Z")
> [@Ralf\_Westphal](#): > > Anyway: Any suggestion for how to get at them for producing reports? Or even seeing them in a Google Sheet? One workaround is to use a set column value and copy your computed value to a basic column… that should make it available in Sheets. Edit: what Jeff said ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 17, 2023, 12:28pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/6 "2023-07-17T12:28:00Z")
> If you can add a set column action as part of your flow, then you can take this computed values and write them to basic columns in your data. You mean I create a “Manual Sync” action for a table and call that after adding/editing a record? For a column A\_calc I would add a column A\_sync to the table and the action would copy the A\_calc value to the A\_sync column? But how to intercept the default how a record gets stored when submitting a new record or changing an existing one? ---
**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:** [July 17, 2023, 12:36pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/7 "2023-07-17T12:36:05Z")
> [@Ralf\_Westphal](#): > > For a column A\_calc I would add a column A\_sync to the table and the action would copy the A\_calc value to the A\_sync column? Yes, that’s the basic idea. > [@Ralf\_Westphal](#): > > But how to intercept the default how a record gets stored when submitting a new record or changing an existing one? Add forms and Edit forms have an On Submit action. When a form is submitted, you can execute other actions, such as a Set Column action. ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 17, 2023, 12:55pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/8 "2023-07-17T12:55:00Z")
Sorry for asking, but where do I find the submit action for the add and edit forms? I have a screen for my table. But I don’t see separated screens for add/edit. But when I click on “add” or click a record for editing, I sure see different screens which can be layouted separately. Where do they exist? Or would I need to set up form screens for adding and editing manually and manually link them to the add/edit actions of a screen bound to a table? ---
**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:** [July 17, 2023, 1:00pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/9 "2023-07-17T13:00:50Z")
It’s in the right hand configuration panel when you are inside the form. ![Screenshot_20230717-075939](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/128f22b533c9d3f70c9b7f21059c2f6973038b1d.png) ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 17, 2023, 1:25pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/10 "2023-07-17T13:25:04Z")
This is what I see when I in the edit form of the screen “Aktivitäten”: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6e0038dee4f8911be1aebf7202413f2f400d3fa.png) * * * ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd75e9a59c5c91d1544205a9b2811a5338817801.png) * * * ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1009bf8e414dc9f041b3c146402b89134da10d31.png) * * * Maybe you’re using the older version of Glide with pages? ---
**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:** [July 17, 2023, 1:30pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/11 "2023-07-17T13:30:26Z")
That’s not an Edit Form. I suggest taking a look at this documentation. > **[Glide • Adding, Editing, and Forms](https://www.glideapps.com/docs/guides/core/adding-editing-forms)** > > Let users add and edit your data in different ways. It looks like you are showing a tab screen or a detail screen, but not a form screen. ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 17, 2023, 3:22pm UTC](https://community.glideapps.com/t/syncing-columns-between-glide-and-google-sheets/64005/12 "2023-07-17T15:22:38Z")
> It looks like you are showing a tab screen or a detail screen, but not a form screen. Sure, not a dedicated form screen. I used used what was provided automatically. Thx for the link. Will study that…