Child table not showing in parent table form

Hi,

I need help understanding why my child table Pictures don't show in the form for my parent table Unsafe site.

Pejme_0-1672039279839.png

 

The child table does show in the details view for the parent table, so don't think there is a setting issue.

Pejme_5-1672039613977.png

 

Screenshots that may answer some questions you might have for me. to help narrow down the issue.

Pejme_1-1672039336088.png

Pejme_2-1672039370101.png

 

Pejme_3-1672039419397.png

 

Pejme_4-1672039462648.png

 

Pejme_6-1672039827089.png

 

Pejme_8-1672039882454.png

 

Pejme_9-1672040041743.png

 

 

 

 

 

 

 

 

0 10 183
10 REPLIES 10

It seems system generated "Related xxxxs" fields are not displayed in a Form.

You could try to create a VC manually with the same App Formula.

@TeeSee1 Thanks for your reply.

I created a manual VC, but it doesn't show either.

Pejme_0-1672044048328.png

 

Pejme_1-1672044098463.png

 

 

Pejme_2-1672044120622.png

 

 

 

Hmm interesting.

Here is what I get

 

TeeSee1_1-1672054978091.pngTeeSee1_2-1672055032309.pngTeeSee1_3-1672055098416.png

If I set "is a part of", then the column DOES show up as @Suvrutt_Gurjar suggested.

TeeSee1_4-1672055603981.png

Since it is not always correct to set it (depends on your use case and your case seems to fit this one), you can keep the workaround in your tool box. (It seems you are having issues with both of them...)

Hi @TeeSee1 

I think use case is when orphan children records are not practically required and parent /children tables functionality is closely integrated. For example an Order( parent table)  and its Order details ( child table). In majority of cases , once an order is deleted, order details make no sense.  A task is deleted , then the related activities can also be deleted and so on.

Hi @Pejme and @TeeSee1 , The configuration is explained in detail in the article below under the topic  "Express ownership between table"

References between tables - AppSheet Help

 

 

@TeeSee1 Yeah, unfortunately, I can't get either suggestion to work.

 

Pejme_6-1672104591871.pngPejme_7-1672104624689.png

 

There must be some setting or something in one of my tables because I was able to implement the child table in the parent table form for two other tables, but I can't get it to work for these two tables ๐Ÿ˜ž

Do you mean putiing picture in forms?

if yes, https://support.google.com/appsheet/answer/10107317?hl=en.

You may want to mark the reference column in the child table as "ISPartof" for the related records from the child table to appear in the parent form. But please do read the  restriction that is associated when you select the "Is a Part of" setting.

The restriction is when a parent record is deleted the "IsPartof" child records are also deleted when you enable this setting.

The sample setting shown below

Suvrutt_Gurjar_0-1672045818505.png

 

@Suvrutt_Gurjar" Is a part of?" made it appear at first. But it's not working again after I tried to delete the duplicate VC suggested above.

Pejme_0-1672049630090.png

 

Any idea what I can have done to make it disappear again?

Please check your configuration again. Is the system generated [Related ....] column present in the parent table as well as parent form's column order?

 

@Suvrutt_Gurjar Everything is the same as before, as far as I can see ๐Ÿ˜•

Pejme_0-1672103010593.png

 

Pejme_1-1672103043938.pngPejme_2-1672103076474.pngPejme_3-1672103097770.pngPejme_4-1672103150865.pngPejme_5-1672103181731.png

 

 

 

Top Labels in this Space