Splitting Few columns into multiple Rows to capture "What If" Scenarios

Splitting Few columns into multiple Rows to capture "What If" Scenarios

Posted by: krish.balaji on 5 April 2018, 4:43 pm EST

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 5 April 2018, 4:43 pm EST - Updated 3 October 2022, 8:31 pm EST

  Hi,

  For a single row, user can enter variations but still considered as one single row, but need to capture the variation parameters.

  This single row can have children rows which I believe I can handle as Nested FlexGrid.

  My question is related to capture the variation data. I need to have the ability to add a new variation to the single row and capture the variation parameters. Out of 30 columns, 7-8 columns would capture the variation. (see attached image)

  It does not need to be “Row Split”. User considers the variation details as part of the same row and should move together when the user sorts or filters.

  Thanks
  
  Balaji

  

  1608×380 20.4 KB

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 April 2018, 7:42 am EST

  Hi Balaji,
  
  As per understanding from your questions and image, you would like to allow user to allow edit variation for a record in two columns. Each column ( two columns which have variation) have three parameter. You need to get these variation.
  
  Along with this, you would also like to use Row Detail and Dynamic Columns feature.

  Could you please let us know which technology/ framework you are using for ClientSide with Wijmo Controls?

  Also, please elaborate the following requirement with example.

  3. The number of Amount & Inc/Dec Indicator pair columns can be different by row. I can’t have the same number of pairs in every row
  4. How do I dynamically add/remove Amount & Inc/Dec Indicator pair columns to a row?
     
     <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
     
     It would be great if you could share a demo data source with around three records.
     
     We are sorry, we are unable to find attachment.

  Thanks,
  
  Manish Kumar Gupta

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 9 April 2018, 10:24 am EST

  SyndicateGrid.zip

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 9 April 2018, 10:24 am EST

  1. I am using RowDetail to see Order History
  2. I need to add new rows just for 2 columns “Amount & Inc/Dec Indicator” columns to capture the Amount & Inc/Dec indicator variations. This variation just should stay with the original row. “Add Step” should allow the user to enter new Amount and Inc/Dec indicator variation.
  3. Add Row function is to add a complete new row

  Please attached demo

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 3:00 am EST

  Hi Balaji,
  
  As per understanding for question 2,
  
  You would like to add some parameter in the row after clicking addStep button. So after clicking add step, the dataItem would be like this:

  {
  [b]"amount2":0,[/b]
  "investor":"Eight",
  "syndicate":"SOne",
  "tranche":"TTwo",
  "country":1,
  "type":"Seven",
  "sgcib":true,
  "sales":"Seven",
  "id":1,
  "amount1":10000,
  "rlValue":"Four",
  "sfValue":"One",
  "hValue":"Six",
  "hsaValue":"Eight",
  "comments":"comments entered 1",
  "group":"group 1",
  "modified":"2018-04-07T18:30:00.000Z",
  "created":"2018-04-01T18:30:00.000Z",
  "status":"open"
  }
  

  On start editing, the amount2 should be edited not amount1. But both should be shown while editing.

  Please confirm…
  
  ~Manish

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 9:01 am EST

  User should be able to add new row to existing Investor1 Row and able to edit only “Amount”, “Inc/Dec” and “Points” columns. Idea is to capture variation to Investor1 Row.

  Similarly, in the above scenario, Investor2 has 2 variations and Investor3 has no variations.

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 9:10 am EST - Updated 3 October 2022, 8:31 pm EST

  

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 10:50 pm EST

  If I use Row FlexGridDetailProvider to show the Order History, Custom Merge Manager does not work.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 11 April 2018, 7:55 am EST

  Hi,
  
  We are looking into this and update you soon.

  ~Manish

• 

  krish.balaji

  • Post Options:
  • Link
    Copy

  Posted 11 April 2018, 12:05 pm EST - Updated 3 October 2022, 8:31 pm EST

  

  695×192 27.7 KB

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 16 April 2018, 12:55 am EST

  Hi,
  
  We are sorry for the delayed response.
  
  As you said, RowDetail can not be used with CustomCellMergeing.
  
  MultiRow would not fulfil your requriement since you have variable variance for Amount and other column.

  In this case, you need to use wjFlexGridCellTemplate to show variation for a column. Please refer to the attached sample for the same( DataSvc.ts / getData/amounts)

  ~Manish

  FlexGrid.Spli.Column.zip