Setting up fields from multiple records

Discussion created by BenyJr on Apr 15, 2016
Latest reply on Apr 15, 2016 by greatgrey

Dear all,


I'm trying to find and use information from records as follows:


1) I have a field called Sounding_LT on all records. Such field could be empty or have a value (number);

2) I have to get from the records, the first one that has a value and the 4th one that also has a value, so I can manage to do calculation using those two numbers;

3) As I could not make it work as described above, I tried to get the values from a search, linking two new fields (Sounding1 and Sounding2, numbers, global) to the dates range, where I would have the information pulled from the record where start date matches date of the first sounding and the end date matches the date for the second sounding;

    - It works for the Sounding1, but not for Sounding2...

Screen Shot 2016-04-15 at 9.08.26 AM.png

Screen Shot 2016-04-15 at 9.10.04 AM.png


Any ideas?

Please let me know if more clarification is needed.