Importing Multiple Rows based on a Quantity Value based Cell?

Hi Everyone,

 

I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item?

 

For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. 

Is there any techniques that could then import 5 new rows into a list and data module with all that same information?

Attached a screenshot which may help explain what I'm trying to do.

davidlloyddeguzman_0-1615414058239.png

 

Answers

  • @davidlloyddeguzman 

     

    yes, this can be done, but I am not sure you are going to like it as it deals with formulas and since formulas are involved, they are now locked from editing.

     

    But here you go:

     

    Have a one module that contains the line items and load the data into it:

    2021-03-10_16-36-42.png

     

    Create another module, dimensionalized by your Row Count and reference the above line items:

    2021-03-10_16-36-55.png2021-03-10_16-37-05.png

     

    So, I think this is the "final" you are looking for, but not the "result".  Am I correct?

     

    Rob

  • @rob_marshall , as u rightly said that formulizing will restrict the editing and as and when Employee details will change in future then it may not viable to apply this; just a cautious note trying to put.

     

    @davidlloyddeguzman , hope u want to achieve this through a dashboard (and not in module directly) then there are different ways to do that e.g.

     

    1. introduce a Boolean line item and get that checked as source to be copied e.g. click against employee 1

    2. Click a button..... Create xx entries using the Employee 1 data

    3. Create action should run which will create the entries in the module (this to be clubbed in the process)

    4. Copy all the Emp 1 entries in new added entries (can be again controlled through Boolean line item)

    This way u may get all the desired entries keeping them editable for all cells.

     

    ** Similarly a delete action can also be created, generally not require in employees case, to omit unnecessary entries in the module.

     

    Let us know if this is u want to achieve or misunderstood your query!