For an input screen, I want to enable users to input at a yearly level and then I want that same value to flow to every month pertaining to that year automatically. This is to make life easier for the end user to not input data at a monthly level, rather do one input at the year.
Example. Value for FY 20:- 1000. Then Jan-dec 20 would have 1000 each.
I created an input screen by year with same dimension as that of the month module and now I wish to create an action to take data from year module to that of month module. However the mapping stops me from directly copying over data.
I didn't go the formula route because I want the end user to still have the ability to edit if they wish to make changes to the numbers. Can this be done in the way above that is receive input at yearly level and then disaggregate the numbers.
@Sachinsourav02 AS @KirillKuznetsov already mentioned, even it will be possible to create import actions to copy data from total year to months, I would strongly NOT advise to use the import action.
It will be difficult to make a distinction between which rows should "be needed to launch the import" and which rows are OK with the manual monthly modifications. There will always be potential issues that Total Year values will not match with monthly values.
Also, a user could "forget" to launch the import actions... :).
Added to the solution proposed by @KirillKuznetsov you could also consider the option to create 1 module with month and activate the "Breakback" option.
In this case the Total Year and month amounts are manually input.
The user can choose to input data at TOTAL year (but using an Yearly amount) and automatically the total year will be allocated to months based on the existing monthly values or will be equally split if no values are input.
So, in your case the user should input 1200 at total year level in order to have 1000 per every month, and in a second step, he/she can go and adjust the monthly amounts.