Excellent, thank you! I am testing this merge before I roll it out to my inspection reports, and I created a spreadsheet with two records as the merge source, one with a photo path and one where the photo path is blank. This approach worked with the record that had a valid photo path but produced an error message for the second path (which was blank). Is there an additional result to the Boolean evaluation that needs to be provided if the IF TRUE statement is false (i.e., no path exists)?
|