Add Auto-Increment Number to output doc Template

Hi people,

I have had a try on this popular tutorial by the intelligent contributor @Jonathon:

However, my use case is a little bit different. There is no preferred number of rows to be displayed in one single page.

This is what I want to achieve:
Instead of #89 , #90 (_Row Number), I want it to show Photo 1, Photo 2, Photo 3 as images in the list getting populated to the output pdf.

Ultimately, I need simply an integer list along with the Site Inspection Photo. Every time a new report is generated, it will re-start the counting from Photo 1, Photo 2, Photo 3โ€ฆ etc.

This report is working against data from Site Inspection TABLE which contains a sub-table (/list) called Site Inspection Photos with Ref and Key.

Therefore, anything need to be worked around with this Site Inspection TABLE.

Is there any good advice?

Solved Solved
1 16 2,880
1 ACCEPTED SOLUTION

Oh okay. One reason I had bolded the presumption before sharing the expression was that Earlier expression expected fixed length, one word key.

Anyway for the latest key, can you please try the below expression? Please note the use of ref column and key columns.

<<Start: [Site Inspection Photos]>>
<<[Photo]>>
<<[Timestamp]>><<[Description]>>
<<CONCATENATE( "Photo โ€œ, COUNT(SPLIT(LEFT([Ref Column in Site Inspection Photos].[Site Inspection Photos],FIND([Key Column of Site Inspection Photos],[Ref Column in Site Inspection Photos].[Site Inspection Photos])),โ€ , ")))>>

<< END>>

View solution in original post

16 REPLIES 16
Top Labels in this Space