Copy from one list member to another

I have an Input module by List:A,B,C,D

The user wants to make the input for member A and copy them to all the other list members B,C and D so they don't have to make the i/ps multiple times.

How can I do this ? If I have an import action then can I map 1 to many for the List?

Accepted answers

Misbah

@BahalR

Copy Across or Copy Down should be the way to go. But if you are looking for this to be done with the help of an import then follow these steps

Step 1: Create a module (Module 1) which is not dimensioned by the List (A,B,C,D). Pull the values from Original Module to this module so that you have only one value in it. Make sure In your original module you have Summary set to Opening Bal or Closing Bal

Step 2: Create another module (Module 2) which is a copy of Original module and then pull the values from Module 1 and then Create a saved view here.

Step 3: Create an import which pulls the data from Module 2 into Original Module.

Hope that helps

Misbah

Miz Logix

All comments

ShubhamCh

Hi @BahalR

Here is my solution:-

Create a top level to your existing list
Turn on the summary :- FirstNonBlank
Create one line item with same format as the user input line item
Give the formula :- User Input[SELECT: Test.Top Level]
Create a saved view which shows this line item only
User this saved view as source object in import action and map it to the User Input line item.
When you run this action. The User input will be copied over to all other members as well.

Look at the pictures for better understanding;-

Screenshot 2022-10-20 at 11.43.32 AM.png

Screenshot 2022-10-20 at 11.43.47 AM.png

Screenshot 2022-10-20 at 11.44.03 AM.png

Screenshot 2022-10-20 at 11.44.23 AM.png

I hope it solves your problem.

Thanks!

- Shubham

Misbah

@BahalR

Copy Across or Copy Down should be the way to go. But if you are looking for this to be done with the help of an import then follow these steps

Step 2: Create another module (Module 2) which is a copy of Original module and then pull the values from Module 1 and then Create a saved view here.

Step 3: Create an import which pulls the data from Module 2 into Original Module.

Hope that helps

Misbah

Miz Logix

BahalR

worked like magic. Thanks @Misbah

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…