How to copy newly added rows in a Source Sheet to a Target Sheet without copying Source columns?
Hi there!
I have a DataMesh that is set up between two sheets. When I add a new row to the Source Sheet, I would like for the DataMesh to pick up that new row and bring it into the Target Sheet, however, it does not seem capable of doing that. The other method which I have explored is the Copy Row Automation -- this works well up to a point, but the issue with this method is that it brings in ALL of the columns from the Source Sheet, which I do not want in my Target Sheet.
TLDR: Any ideas on how to automatically copy newly added rows in a Source Sheet to a Target Sheet without also copying over the Source Sheet columns (in other words, copying ONLY the information of the row that matches the columns in the Target Sheet)? I hope this makes sense. Thank you in advance.
Kindly,
O.O.
Answers
-
Take a look at this configuration set up article. Make sure you have "copy and add data" selected when building your workflow.
Here is another community post discussing the topic.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives