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?
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?
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.
But do you want to commit the edits to the original sheet? Does it work like a log of edits?
No. I wouldn’t like to change the original sheet. I’d like to transfer the edited information to another sheet.
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?
1 Like
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.
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.
I do this for the new post but I have no idea how to do when the user edit a post that just exist.
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?
The is 50 columns but the user can edit only 8 columns.
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?
I need that the original still be visible.
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.
2 Likes
Great! I’ll try this and if I have any doubt, I will ask to you.
It works perferctly!!! Thank you very much!!!
1 Like
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.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.