Skip to main content
C
carlosp5114
September 7, 2023
Question

How to create an editable grid from a record

  • September 7, 2023
  • 4 replies
  • 0 views

Hi! I have a doubt with the approach of my application and I would like to know your thoughts!

In my case, I have a summary view of PO in which I have a read-only grid with the PO lines.

I created a related record action to "recepit" the PO Lines ("Recepcionar Pedido", which will link to a process model), and now I want to create an interface with the following conditions:

  • 1) I must show the same information/table with the PO Lines (I just need some of the fields). Not need to add new rows
  • 2) I must be able to create an extra-column to introduce manually 

In order to do this, I thought several options:

  • 1) Create an editable grid based on the data of a record (like a read-only grid, same values, but with the posibility to manipulate it)
  • 2) Convert the read-only grid in an editable grid (i dont know if its possible or complex, I know the configuration are totally different)

How can I manage to do it? If it´s not a good approach, I would like to hear from your recommendations 

Thanks a lot, any idea would be useful

    4 replies

    ignacio.moran
    ignacio.moran
    September 8, 2023

    Hi Carlos, 

    What do you mean with "I must be able to create an extra column to introduce manually". Do you mean that the final user will have the possibility to add manually a column to the grid? Or you mean you as developer will add a new column to the grid? What type of data will be managed in that new column? 

    C
    carlosp5114Author
    September 8, 2023

    Hi Ignacio! In this case, I mean that I, as a developer, must have the chance to add a new column to the grid (NOT the user). 

    Each row of my previous grid had a column/field called "quantity". In my new grid, I would like to create a new column called "Quantity Receipt" (just a number the user introduces manually)

    But this is my second step. First of all, I would like to "query" or "translate" my data to the new editable grid. How can I manage this? Can I make a query in my editable grid instead of creating it from zero?

    *Update: I was searching ways to pass the data of my read only grid, and I have shown a post in which selectable values are used. What do you think about this approach to save the data? Logically after that I have to show a grid again (and being able to add a column as a developer)

    In Mike´s explanation, I´m interested in the part of making an edit of the existing data after clicking the link/selected rows. I would like to understand how to do this (passing the data and make it editable)

    ignacio.moran
    ignacio.moran
    September 8, 2023

    Hi Carlos, 

    to add this link, and then display a new field below the grid, you should add a dynamic link in a new column of the read only grid and then this dynamic link will save a boolean to true which is also in the "showWhen" attribute of the new field below your grid, so when you press the link the field is shown.

    But then you also need to save the item where you are going to save the value quantity and you must think in a solution for this. 

    On my side, I prefer creating an editable grid, where you will add the new editable column with a text field and in each field you will save the quantity of each row. The data for this grid should be fetched again as you did in the parent interface. 

    Terms & ConditionsAccessibility statement