Child Table Name

I have a child table linked to my parent form and wanted to ask 2 questions:

  1. Can the child table name be changed on the form - see screenshot?

  1. The child table captures 4 images, how can i add these to the parent table workflow pdf attachment and also as a โ€œother attachmentโ€ on the email?

Thanks

0 3 357
3 REPLIES 3

Steve
Platinum 4
Platinum 4

Modify the Description property of the column that refers to the child table.

Thanks, that solved the first part

For the second part, here is one way of doing it. Specify the formula below in โ€œOther Attachmentsโ€ field of the email workflow:

SELECT(
    Parent[Pic], 
   ([ID]=[_THISROW].[ID])
)
+
SELECT(
   Child[Pic],
   ([Parent Ref]=[_THISROW].[ID])
)

where โ€œParentโ€ is the parent table and has fields โ€œIDโ€, โ€œPicโ€
and โ€œChildโ€ is the child table and has fields โ€œIDโ€, โ€œPicโ€, โ€œParent Refโ€.

Top Labels in this Space