Instead of defining calculations in the data structure, I would love it if we could define them on the layout....can you imagine how 'clean' the schema would be....all those unnecessary calculated headings/labels gone.....

How's about:

http://www.filemaker.com/help/FunctionsRef-34.html

...as well as:

http://www.briandunning.com/cf/868

:qwery:

Try to watch this video:

http://www.filemaker.com/help/FunctionsRef-34.html

--sd

How's about:

http://www.filemaker.com/help/FunctionsRef-34.html

...as well as:

http://www.briandunning.com/cf/868

:qwery:

Try to watch this video:

http://www.filemaker.com/help/FunctionsRef-34.html

--sd

The video link is the same as the first link

Oh yes what a bummer, the tool I wished to turn attention to is this:

http://www.schubec.com/en/product_details_883818.html

--sd

See if this can help you out.

Layout_Calcs.zip

Thats exactly what I'm thinking about - pity it requires the web viewer to achieve as formatting it to look like the rest of my interface looks to be a bit of pain (as well as added the html tags). (I'm hoping the next version has this feature built into merge fields as I have loads of calc fields used only for displaying headings)

Oh yes what a bummer, the tool I wished to turn attention to is this:

http://www.schubec.com/en/product_details_88 3818.h...

--sd

Oh no I confused it with another thread ... it's the Matt Petrowski movie with Agnès' custom function - Sorry!

http://www.filemakermagazine.com/videos/customlist-custom-function.html

--sd

pity it requires the web viewer to achieve as formatting it to look like the rest of my interface looks to be a bit of pain

Well does it indeed? ...as if you have used this tecnique for ages:

http://www.nabble.com/-DEMO--A-New-Approach-to-Conditional-Summary-Report-Headers-to20259501.html

http://www.kevinfrank.com/download/conditional-summary-report-headers.zip

http://fmforums.com/forum/showtopic.php?tid/198987/post/307298/hl//fromsearch/1/#307298

Well I do not believe so, since Daniele is just as meat cleaver sharp in his reasoning as Kevin Frank, Davor Juretic, Mikhail Edoshin, Jason DeLoose, Alexander Zueiv or Don Wieland just to mention a few... so if one of those enlighten us mere mortals is it worth (...well manditory) to pay attention.

--sd

I have loads of calc fields used only for displaying headings

You could reduce their number significantly by using a repeating field.

Could you explain have you would use the evaluate function to accomplish this?

I understand using the function itself, but on the layout it just display as "Evaluate ( ... )".