1 Reply Latest reply on Sep 25, 2013 8:34 AM by philmodjunk

    Capturing Field Data For Record Set



      Capturing Field Data For Record Set


           I want to be able to include the data from a particular field in a calculation. This data being the results of a search (doesn't have to technically be a search, but want a subset of records).

           For example, I have a table with items, each item has a name and a type. In the calculation, I want to include the names of all items of one particular type.


        • 1. Re: Capturing Field Data For Record Set

               How will you use this information that is now all in one field?

               If you use a relationship to match to the desired subset of records, (Can you list them in a portal?), The list function can be set up like this:

               List ( RelatedTable::Field )

               and you'll get a return separated list of all the values in field over all the related records. Substitute can be used with list to replace the returns with other characters if that is necessary.

               The ExecuteSQL function can also be used to generate such a list if you are using FileMaker 12 and this opens the door to listing the results of a full up query of your data in SQL.