List ( If ( Not IsEmpty ( Material ) ; “Material – “ & Material ) ; If ( Not IsEmpty ( Finish ) ; “Finish – ” & Finish ) )
Thanks Phil, unfortunately we are using FMP 8.01, it does not support "List" function, I will try use the "IF" statement to construct the function, now that I got some idea how it work.
Thanks for your help!
Sorry about that. I jumped from 5.5 to 10 so I never had a copy of of 8 and thus didn't know that it does not have this function.
If ( Not IsEmpty ( Material ) ; “Material – “ & Material ) &
If ( Not ( IsEmpty ( Material ) and IsEmpty ( Finish ) ; ¶ ) &
If ( Not IsEmpty ( Finish ) ; “Finish – ” & Finish )
A much messier calculation but one that can be made to work.
In some cases, you may be able to to stack a series of calculation fields one above the other on your layout and set them to slide up. This only works for printed/previewed/PDF'd output--can't see stuff "slide" in browse mode so you'll have to decide for yourself if that's an option.
The separate calcualtion fields would look like:
Field 1: If ( Not IsEmpty ( Material ) ; “Material – “ & Material )
Field 2: If ( Not IsEmpty ( Finish ) ; “Finish – ” & Finish )
You might also consider moving this data from dedicated fields to a table of related records where you have one field for the category ("Material", "Finish", etc) and one field for the value. Such records can then be listed in a portal set to slide up | Resize enclosing part or in some cases you can use a list view layout based on the portal with data from your parent record included on this layout.