# Please, how can I create an automation that opens a screen with data from a table, but upon submitting the edit, fills in the data in a support table? **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [March 9, 2024, 2:09pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545 "2024-03-09T14:09:55Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 9, 2024, 2:09pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/1 "2024-03-09T14:09:55Z")
Please, how can I create an automation that opens a screen with data from a table, but upon submitting the edit, fills in the data in a support table? ---
**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:** [March 9, 2024, 3:09pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/2 "2024-03-09T15:09:46Z")
I’m not sure I get the flow here. 1/Can you explain more about “opens a screen with data from a table”? How is it related to the screen you’re viewing before that? 2/When you say “submitting the edit”, do you mean you’re opening an edit screen in the previous action? ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 10, 2024, 12:30pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/3 "2024-03-10T12:30:19Z")
Hi, Thin! I would like to open the editing screen, but instead of saving the data in the original spreadsheet, save it in another spreadsheet with the same fields. ---
**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:** [March 10, 2024, 1:19pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/4 "2024-03-10T13:19:05Z")
But do you want to commit the edits to the original sheet? Does it work like a log of edits? ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 10, 2024, 4:01pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/5 "2024-03-10T16:01:39Z")
No. I wouldn’t like to change the original sheet. I’d like to transfer the edited information to another sheet. ---
**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:** [March 10, 2024, 4:15pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/6 "2024-03-10T16:15:27Z")
Here is how you can do it: - Display the data from your first table in a Collection - Add a Collection Item action - Make that action and Add Row action - Target it at your second table and select the columns you want copied All that said, this is an odd thing to do. Normally you want to eliminate duplicated data, not create more. I’d be curious to know why you think it’s necessary to do this in the first place? ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 10, 2024, 6:32pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/7 "2024-03-10T18:32:28Z")
Thanks, Darren! I’m doing a app where the users will can edit the screen but I want to aprove before. The only way that I thought to do this is using a second table and copy-paste to the first if everything is OK. If you have another ideia, I appreciated to know. ---
**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:** [March 10, 2024, 6:41pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/8 "2024-03-10T18:41:41Z")
Wouldn’t it make a lot more sense to just have one table with an extra column for an approval flag. By default the flag would be empty and you would filter out the row with an empty approval flag. When the admin approves the post, you change the flag so it passes the filter, and that’s it. ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 10, 2024, 6:59pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/9 "2024-03-10T18:59:26Z")
I do this for the new post but I have no idea how to do when the user edit a post that just exist. ---
**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:** [March 11, 2024, 12:10am UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/10 "2024-03-11T00:10:50Z")
How many columns do you have for that table? I would opt for an external table as well, but would multiple users be able to edit a row at the same time? ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 11, 2024, 1:53pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/11 "2024-03-11T13:53:38Z")
The is 50 columns but the user can edit only 8 columns. ---
**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:** [March 11, 2024, 2:05pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/12 "2024-03-11T14:05:58Z")
If a user edits a post, would the original still be visible…and then get overwritten when the admin approves it? Or would the original be hidden as well? ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 11, 2024, 2:57pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/13 "2024-03-11T14:57:41Z")
I need that the original still be visible. ---
**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:** [March 11, 2024, 3:33pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/14 "2024-03-11T15:33:51Z")
I think @Darren_Murphy provided a good solution if you want to use a second table. Darren and others might feel differently, but I think you can do this with one table. Since you are only updating 8 columns out of 50, I think what I would personally do is create 8 additional new columns in your existing table. You could have a button with a custom action to first write the original column values to the new columns with a Set Column action, followed by a second action to show the edit screen with only those new 8 columns shown (this is effectively pre-filling the editable fields on the screen). The user can make their changes on the edit screen and submit the form. (Maybe you want to do something with a second approval flag so it shows up on the admins list.) When the admin approves the edit, a Set Column action can take the values from the new 8 columns and overwrite the original 8 columns. One advantage of having all of this in the same table is that you can easily display a before and after value to the admin so they can see what the user changed in each of those 8 columns. ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 11, 2024, 4:02pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/15 "2024-03-11T16:02:38Z")
Great! I’ll try this and if I have any doubt, I will ask to you. ---
**Author:** ![Rafael\_Salla\_Paulilo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafael_salla_paulilo/32/71453_2.png) [@Rafael\_Salla\_Paulilo](https://community.glideapps.com/u/Rafael_Salla_Paulilo)\ **Post date:** [March 11, 2024, 4:21pm UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/16 "2024-03-11T16:21:33Z")
It works perferctly!!! Thank you very much!!! ---
**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:** [March 12, 2024, 12:30am UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/17 "2024-03-12T00:30:34Z")
Please note that for the solution to work perfectly, I think only the user who submitted the original post can edit that post, which I assume is the case for you, and admins step in to approve the changes. If multiple users can edit a post, there can be a situation where the next attempt to edit overwrites the previous one. ---
**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:** [March 19, 2024, 12:30am UTC](https://community.glideapps.com/t/please-how-can-i-create-an-automation-that-opens-a-screen-with-data-from-a-table-but-upon-submitting-the-edit-fills-in-the-data-in-a-support-table/71545/18 "2024-03-19T00:30:47Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.