# How to move record to another table on trigger **URL:** \ **Category:** Ask for Help\ **Created:** [February 8, 2024, 5:53am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616 "2024-02-08T05:53:22Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 8, 2024, 5:53am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/1 "2024-02-08T05:53:22Z")
Hi Guys, I have a column called “Status” , When the status changes to “Move” I want select columns of the row to be moved to another table. I would want mapping of columns between tables to happen. What would be the recommended way to do this? I know zapier is one way, is there anyways we can do it without zapier? Thank you guys in advance, Regards, Dilip ---
**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:** [February 8, 2024, 6:02am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/2 "2024-02-08T06:02:58Z")
> [@Dilip\_Adiga](#): > > I have a column called “Status” , When the status changes to “Move” I want select columns of the row to be moved to another table. > > I would want mapping of columns between tables to happen. This is normally done with relations and lookups. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 8, 2024, 6:18am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/3 "2024-02-08T06:18:24Z")
Thank you for the reply Darren I get lookup usage, You will find one component and then d a look up to get other values you mean? I am confused about Relations Relation is to map value in column from one table to another right? I dont have common values. Example: Table 1 from where value should come will have Column with name “Brand Name” Table 2 to where value should be written to will have column with name “Brand Name” but the values in both will be different. Also how would it only trigger when I select option “Move” from my choice? Its a little confusing to me Regards, Dilip ---
**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:** [February 8, 2024, 6:20am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/4 "2024-02-08T06:20:21Z")
Please show me a screen shot of the two tables concerned, and describe what needs to change in the second table when the status is changed in the first table. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 8, 2024, 6:28am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/5 "2024-02-08T06:28:21Z")
I couldn’t take screenshot , so I created a Loom Video This is my First Table which has a column called toMove When the status of toMove is “Move” Few Rows in this table has to be moved to another table The Loom recording of the table is as below **We need the selected row from table 1 (Few columns) to be created as a new row in Table 2** **It should. be a new record, not updating any record.** Let me know if this helps. Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 8, 2024, 6:36am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/6 "2024-02-08T06:36:10Z")
is it possible I can use actions for this? Not sure how it would work though , since I have to create record in another table. Regards, Dilip ---
**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:** [February 8, 2024, 7:02am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/7 "2024-02-08T07:02:06Z")
Yes, you would need to use an Add Row action. You mentioned that you use a choice component to change the status - is that inside an Edit Form? If it is, you can use an onSubmit action to check the new status and add a row to the other table if necessary. If it’s not in an edit form, then you probably should change that. Or use a simple custom form. Either way, you just need to be able to trigger the add row action when the status changes. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 8, 2024, 7:04am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/8 "2024-02-08T07:04:07Z")
Hi Darren, Thank you for the reply. If by > [@Darren\_Murphy](#): > > You mentioned that you use a choice component to change the status - is that inside an Edit Form? You mean wether it is inside table that has status choice then yes it is Also do we have an action called onSubmit by default? It seems like we need to create a custom action right? Regards, Dilip ---
**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:** [February 8, 2024, 7:17am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/9 "2024-02-08T07:17:08Z")
You just need to be able to trigger an action when a user changes the status. If you can’t do that now, change the flow so that you can. I don’t know how you currently change the status, so I can’t tell you exactly what needs to be changed. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [February 8, 2024, 7:23am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/10 "2024-02-08T07:23:05Z")
I put a simple button on the detail page saying “Move” and then triggered the add row action. Thank you for the help Darren Regards, Dilip ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 15, 2024, 7:23am UTC](https://community.glideapps.com/t/how-to-move-record-to-another-table-on-trigger/70616/11 "2024-02-15T07:23:19Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.