Table look up not behaving as expected

4

Dear @ppe_office

In the consultation table the column “type consult” should contain the following formula:

Concatenate(Format("{1} {2}, {3}", thisRow.[date of consult].MonthName(), thisRow.[date of consult].Day(), thisRow.[date of consult].Year()), "  " ,thisRow.contacts)

image
image862×417 34.3 KB

The formula “format” is assuring that the layout is consequent executed in the way you write in the syntax.

This is the source where I have learned it in the past:

1 Like