ECFMUser

Thanks. Unfortunately I do not have the luxury of making any structural changes at this point. The table is de-normalized. All the data is kept in one big table. Can something like this be done: When the user goes to generate monthly report, trigger a script that finds all the records in that date range, loop through them and generate the totals, then proceed with the report layout. Thanks.

It is quite possible that it could be done via calculation field. I would prefer to do it that way, because then I don't have to worry about installing the plug-in on all user's computers. But I am not a pro in FileMaker, and am struggling to get this done in calculation field. This is my requirement: I have a order entry system. Each order can have multiple items such as paper,ink, labor etc. It is also possible to have different kinds of paper ordered in one order, and each has a different rate. I need to generate one total for paper, one for labor etc. The user has four columns to populate the order info. - Quantity, Items, unit cost and price. Item is a dropdown list. Each of these columns are repeating upto 20 times. I would like the total to be generated as and when the user selects an item. However, because this is a dropdown box, I am not able to call the script. The final outcome of these paper_total, labor_total fields are to be used in a report. I'd appreciate if you could suggest a way to do this in a calculation field. Thanks.

Thank you very much. Any idea if the plug-in has to be installed on each client computer that has FM Pro.

Hi, Is it possible to call a script from a calculation field? This is what I am trying to achieve: I have a dropdown field, and I need a script to run whenever something is selected in this field. My code is simple; I am using several IF and EndIfs. Set Field [Total_Paper;0] If [Left(Items[1];5) = "Paper"] Set Field[Total_Paper; Total_Paper + Line_Total[1]] End If If [Left(Items[2];5) = "Paper"] Set Field[Total_Paper; Total_Paper + Line_Total[2]] End If Since the above is not possible in a calculation field, I coded the above in a script Any help is sincerely appreciated. Thanks.