Editable child records grid

Like (0) Share

Report

Posted on 8 Apr 2024 10:23:17 by hubjes

Hi.

I have a list in Power Pages and an edit button for table A.
If I click the edit button, it opens the form for Table A, which is a sub-grid associated with Table B.
I would like to make this sub-grid editable, but the only option I have found is to add another edit button to the sub-grid form and create another form for table B.

Is there any option to make this sub-grid editable instead of creating another form and opening another window?

Categories:

General

All responses (5)

Answers (1)

oliver.rodrigues 9,342 Most Valuable Professional on 12 Apr 2024 at 07:01:12

Like (0)

Report
Re: Editable child records grid

So what is a good practise to do this type of task?

review permissions and make sure you are not exposing extra data

if that's the only page you are using WebAPI, make sure to reference your API wrapper only in that page/form to minimize the exposure of it

use common functions / generic JS code where applicable

basically the same good practices as any other customization within Power Pages

Should I change my data structure some kind?

if your child table will have a fixed number of records, you could consider creating fields in the parent table, for example: Parametry1 Parametry2 Parametry3

I personally don't like that approach, but it might solve your problem
hubjes 48 on 11 Apr 2024 at 07:54:54

Like (0)

Report

Re: Editable child records grid

Thank you.
I achieved this by using Liquid and WebAPI.

So what is a good practise to do this type of task?
Should I change my data structure some kind?

For me a possibility to edit child records is pretty common need.
Sorry for so many questions but I would like to understand it better.
Verified answer

oliver.rodrigues 9,342 Most Valuable Professional on 09 Apr 2024 at 16:39:53

Like (0)

Report

Re: Editable child records grid

Hi, unfortunately you can't achieve that with OOB components as each form is related to a specific table.
Technically speaking you can use the WebAPI to achieve this, but it will involve custom code.

To be honest, this is not a common issue, most customers understand the concept of parent/child record and that they should be editing the data in each one's context.
hubjes 48 on 09 Apr 2024 at 14:04:11

Like (0)

Report

Re: Editable child records grid

Thanks for your response.

Yes I added type 'Subgrid' in Basic Form Metadata:
But from the user's perspective, I see my form first:
Then, when I click the Edit button, I see my subgrid in the pop-up window:
And what I want to achieve is to be able to edit the data in this pop-up window, the data is linked to the parent record in my form. Instead of clicking another Edit button and opening another pop-up window, like this:
Do you think this is achievable?
To make it simpler, I just want to have a form where when I click edit it will allow me to edit records from another table, related to my selection.
oliver.rodrigues 9,342 Most Valuable Professional on 09 Apr 2024 at 07:08:20

Like (0)

Report

Re: Editable child records grid

You don't need to have it as a separate window, when adding the Option to the Subgrid (via Metadata), instead of selecting Web Page, you can select a Basic Form. This will open as a Pop-up/Modal instead of a separate page.

If you want an editable grid/inline editing, you can enable that in the back-end. But my experience with that isn't the best, I tried it recently and it wasn't stable.