Embedded Databound Subforms

追蹤

Sylvia Able

• 2021年01月06日 17:51

Is it possible to have embedded subforms that are databound?  I'm using MySQL database.

I have 4 database tables that are related (see attachment).  Note that I only added the relationships in red so that AgilePoint would see these tables as a true children and allow me to include them in the datasource of the form.

On my form, my parent data would be on the form outside of any subform.  But, I want to embed subforms as shown in the second attachment and I want to make them databound so that AgilePoint saves the data to the appropriate tables in the database when the submit button is clicked.

Is this possible?  If not, is there another way to accomplish this?

Thanks!

0

• 

  Suhail Faisal

  • 2021年02月08日 05:21

  Hi Sylvia,

  You can achieve this when your tables have the foreign key relationships defined in MySQL DB. While configuring the data source for your application, as shown in the below screenshot, you will get listed the related or child tables which you can select through.

  The selected tables/data sources will be available in the data model panel in the form designer canvas.

  Hope this helps you.

  

  

  Thanks

  Suhail Faisal

  0

  評論操作 永久連結
• 

  Sylvia Able

  • 2021年02月08日 12:57

  Thanks for your response, Suhail.  

  What I really want to do here is to embed the databound subforms within each other as demonstrated by the blue, red and green boxes.  Is that possible?

  0

  評論操作 永久連結
• 

  Suhail Faisal

  • 2021年02月11日 06:20

  Hi Sylvia,

  AgilePoint supports the Parent-Child relationship of 1 level i.e, with respect to the data source. Means 1 parent table - 1 child table or 1 parent table - multiple child tables in the same level.

  Multi-level or nested parent-child relationship is not supported.

  In your case I believe, the parent table for the child table-3 is child table-2 and for child table-2 it is child table-1. And if you want to embed this in eForm then it is not achievable.

  Hope this clarifies your concern.

  Thanks

  Suhail Faisal

  0

  評論操作 永久連結
• 

  Sylvia Able

  • 2021年02月11日 12:51

  Ok, thank you Suhail.  That's what I suspected, but wanted to find out for sure.  I appreciate your help!

  0

  評論操作 永久連結

請登入寫評論。