# Updating cell in a table when raw in another table is deleted **URL:** \ **Category:** Ask for Help\ **Created:** [April 7, 2025, 9:58am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215 "2025-04-07T09:58:05Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 9:58am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/1 "2025-04-07T09:58:05Z")
Hi, i’am new on Glide but this looks fantastic ! I’m reaching out to inquire about the possibiity to add a new function in my app. This is an app to manage devices linked to users. I have a table for users and a table for devices. Within the layout, i can attribute devices to a given user. Using the “relation” function, my table with all users automatically updates with the list of attributed devices. What would like to do now, is when i remove a given user (raw), to set devices as “available” automatically. In the present form 'Available" is in the user list. Is there any way to proceed ? Thank you very much.😊 Tristan ---
**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 7, 2025, 10:00am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/2 "2025-04-07T10:00:42Z")
Could you provide screen shots of both tables please? I’d like to see and understand how they are being related. ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 11:20am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/3 "2025-04-07T11:20:52Z")
Thanks for your help. Here are the tables. Regards ![Screen1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba5ae8876cde5686fea2ed607f475b2275b69541.png) ![Screen2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/989650a11ea115af9d06f89bd07e53f97e786d0e.png) ![Screen3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27ff4ad5c29ff569f0800f888afcc44a213f8068.png) ---
**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 7, 2025, 11:33am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/4 "2025-04-07T11:33:13Z")
How do you know which device belongs to which user? I can’t see any column value that both tables have in common. ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 11:42am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/5 "2025-04-07T11:42:21Z")
In “dispositifs” table, the column (utilisateur) is defined within the app using the menu, where the list is from the table “Utilisateurs” column “Name”. By choosing a user, the column “utilisateur” in “dispositif” table updates with the name. ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 11:47am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/6 "2025-04-07T11:47:26Z")
Here is another set of screen were device T01 is attributed to 01SEFMA1. ![screen4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c292584d6069bf166c18079d37bc106e02eb32fe.png) ![Screen5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b21be6513e8cf49b6d4e93aad6de69a71f4b5238.png) ![Screen6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e00f741d6ee369d2ebb92d4b45c899087cab35ad.png) ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 11:54am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/7 "2025-04-07T11:54:46Z")
The column “matériel en prêt” in “utilisateur” table is in relation with “utilisateurs” table and automatically display all devices with UserName. ---
**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 7, 2025, 11:55am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/8 "2025-04-07T11:55:14Z")
I see. And so when you delete a user, you want to clear any related columns in the device table, yes? The way you have this setup is a little odd. But anyway, lets try and work with what you have. Firstly, the only way to update multiple rows at once is to either use the Glide API, or use server side workflows. Both of those require a paid plan. I’ll assume you don’t have a paid plan, so will rule those options out. You could do something like the following: - In your Device table, create a relation that matches the user name with the user name in the users table. If that relation is empty, that means there is no user associated with that device. - Create an if-then-else column: – If relation is not empty, then User Name – Else Unassigned Then use that if-then-else column to represent device ownership/assignment. ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 11:57am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/9 "2025-04-07T11:57:36Z")
You got it ! Thanks for the suggestion, i will try and get in touch. ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 7, 2025, 1:16pm UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/10 "2025-04-07T13:16:43Z")
Dear Darren Murphy, What you’ve suggested works very well ! Thank you very much ! The only things that is not cleaned is the user name I selected within the App. Is there any way to directly attribute a device to a user without updating the “device” table and then applying what you’ve suggested ? Anyway, Thanks a lot for your kind support, Regards ---
**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:** [April 7, 2025, 11:49pm UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/11 "2025-04-07T23:49:36Z")
> [@Tristan\_Bonnevie](#): > > The only things that is not cleaned is the user name I selected within the App. Is there any way to directly attribute a device to a user without updating the “device” table and then applying what you’ve suggested ? If you have a users table, you can have a multiple choice component that allows you to write a list of devices ID. Then, use split text to split that list to an array, and a relation to link that array to the the devices table. That way, you can display a list of components that belong to a user, in the users view. On the devices table, create a reverse relation using the rowID (or whatever you decide to write in the choice component above), back to the split text column in users table. You will know which user is assigned the device. ---
**Author:** ![Tristan\_Bonnevie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tristan_bonnevie/32/86907_2.png) [@Tristan\_Bonnevie](https://community.glideapps.com/u/Tristan_Bonnevie)\ **Post date:** [April 9, 2025, 10:03am UTC](https://community.glideapps.com/t/updating-cell-in-a-table-when-raw-in-another-table-is-deleted/81215/12 "2025-04-09T10:03:45Z")
Thank you very much !