Hi, I'm David. I'm new to this forum. I hope one of you experts can help me.
My filemaker solution is a legal-oriented solution. Among many others, I have a matters table and layout.
I have a Custom Function that creates a list of items from a filtered portal. On the matters layout, I have a portal is showing records from an Events table that is filtered to show events that are due today. When I am on the matters layout, if I go to Data Viewer and use the Custom Function, I get the correct result (i.e. it will give me a list of the items in the portal).
However, if I try to create a calculation field in the matters table, using the exact same syntax I've used in Data Viewer (the result is set to Text) I get no results. Shouldn't the calculation be giving me the exact same results as I'm seeing in Data Viewer?
The Data Viewer's calculation context is the current layout, i.e the table occurrence it is based on.
A calculation can be set to evaluate in any desired context, i.e. TO. Are the calc TO and the layout TO identical?