Answered

Editable child records grid

(0) Share

Report

Posted on 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 topics

I have the same question (0)

All responses (5)

Answers (1)

oliver.rodrigues 9,425 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
hubjes 48 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

oliver.rodrigues 9,425 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
hubjes 48 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
oliver.rodrigues 9,425 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No