4 Replies Latest reply on Apr 15, 2016 3:48 PM by greatgrey

    Setting up fields from multiple records


      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.