Ok, so below is the template START EXPRESSION and IF EXPRESSIONS, that I am using for my template.
It works, but it is still leaving “DEAD SPACE” because it is running the ‘Start’ and ‘End’ expression, but simply not putting anything there, if there isnt something to put there.
I would like to write a Start Expression, that ONLY pulls in fields with data in them.
INSTEAD of looking for data and inserting blank’s if it does not find anything.
How??
<<Start: [Related Site Equipments [Company]]>>
<<IF( ISBLANK([recentservicerecord]), ””, “Technicians That Performed Repairs For Following Equipment:”)>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#1]))>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#2]))>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#3]))>>
<<IF( ISBLANK([recentservicerecord]), ””, ([recentservicerecord].[Technician#4]))>>
<<IF( ISBLANK([recentservicerecord]), ””, “Technician Resolution & Any Additional Findings During Repair.”)>>
<<IF( ISBLANK([recentservicerecord]), ””, CONCATENATE("Unit Tag#: ", [recentservicerecord].[Unit Tag#]) )>>
<<IF(ISBLANK([recentservicerecord]),””,CONCATENATE(“Unit Summary Notes:”, [recentservicerecord].[ Unit Notes Summary]))>>
<<IF(ISBLANK([recentservicerecord]),””,CONCATENATE(“Technician Recommendations:”, [recentservicerecord].[Technician Recommendations]))>>
.<>
LinkedIn
Twitter
