# The "Set column values" action not working with Google Sheets? how to fix that? **URL:** \ **Category:** Ask for Help\ **Tags:** data-sync, actions\ **Created:** [February 8, 2024, 8:03am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619 "2024-02-08T08:03:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Sam\_Hewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_hewa/32/60726_2.png) [@Sam\_Hewa](https://community.glideapps.com/u/Sam_Hewa)\ **Post date:** [February 8, 2024, 8:03am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/1 "2024-02-08T08:03:54Z")
I am currently attempting to create an Inventory Management app using the Glide app and integrating it with Google Sheets. I have followed all the settings outlined in the Glide Inventory Management free template. However, I am encountering an issue where the restock and sell functions are not updating the corresponding values in the raw data type (Set column values). I am seeking a solution to this problem. If anyone has any suggestions or recommendations, please let me know. ![Screenshot 2024-02-08 at 9.05.33 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/867c4821c389249fd5267586d43a518be6b42140.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 9, 2024, 12:41am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/2 "2024-02-09T00:41:23Z")
Is your screenshot showing an add form or an edit form? ---
**Author:** ![Sam\_Hewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_hewa/32/60726_2.png) [@Sam\_Hewa](https://community.glideapps.com/u/Sam_Hewa)\ **Post date:** [February 9, 2024, 1:18am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/3 "2024-02-09T01:18:17Z")
I’m not sure, sorry. I’m new to this. When I go to the product collection, under actions, it says “allow users to add items and edit items.” Is that what you mean by “add from or an edit form”? ![Screenshot 2024-02-09 at 12.12.20 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1e7b71813246af2877e2db69798acb706c69ec7.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 9, 2024, 1:19am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/4 "2024-02-09T01:19:26Z")
Yes, so you clicked “Add Product” to show the first screenshot? ---
**Author:** ![Sam\_Hewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_hewa/32/60726_2.png) [@Sam\_Hewa](https://community.glideapps.com/u/Sam_Hewa)\ **Post date:** [February 9, 2024, 1:28am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/5 "2024-02-09T01:28:28Z")
No, when I click on the product “part 1”, it opens this screen ![Screenshot 2024-02-09 at 12.24.53 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/81b933dd9bb0af8dd2b9decf8d0f3d085c6c08e7.jpeg) ![Screenshot 2024-02-09 at 12.25.14 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0ee98432ef30a5d6c5a15fa2656f5d9b35742f38.png) and then I just click “restock item”. ![Screenshot 2024-02-09 at 12.25.35 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0cdfb29ed76a060fde9f1d1bd9e0564cedfcd45.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 9, 2024, 1:29am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/6 "2024-02-09T01:29:30Z")
Then what action ties to your “Restock item” button? ---
**Author:** ![Sam\_Hewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_hewa/32/60726_2.png) [@Sam\_Hewa](https://community.glideapps.com/u/Sam_Hewa)\ **Post date:** [February 9, 2024, 1:33am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/7 "2024-02-09T01:33:30Z")
![Screenshot 2024-02-09 at 12.30.53 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de3839efc4446c08176d5f6a3e1235cd0117d4e1.jpeg) ![Screenshot 2024-02-09 at 12.31.20 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fefad285fcba64be53861ce12af137087413c3c2.png) I reckon its connections to SKU on Orders Database. ---
**Author:** ![Sam\_Hewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_hewa/32/60726_2.png) [@Sam\_Hewa](https://community.glideapps.com/u/Sam_Hewa)\ **Post date:** [February 9, 2024, 1:37am UTC](https://community.glideapps.com/t/the-set-column-values-action-not-working-with-google-sheets-how-to-fix-that/70619/8 "2024-02-09T01:37:00Z")
All the question marks you see in the “orders relation” column are the ones that weren’t recorded when I attempted to restock.