AnsweredAssumed Answered

lookup loop for multiple results

Question asked by slarsson on Jun 4, 2018

I have a contractor assessment form where users enter some basic info on a contractor.  It would be nice to be able to show, right on this form, when the previous assessment(s) were completed.  So basically a lookup (based on the contractor name), showing any Created On dates.

 

I added a Calculated Value using the formula:

lookup("Contractor Chronic Unease Assessment", "Contractor Name", parseLookup(ContractorName, true), "Created")

 

This works very well for the FIRST assessment with the same contractor name.  Is there any way to repeat this for all assessments?  Or at least the most recent one(s)?

Outcomes