Search the Community
Showing results for tags 'calculation fields'.
Found 3 results
docasar posted a topic in Calculation Engine (Define Fields)Hi, I have a global variable that has been set from previous a script. This global variable is $$abc and has a value of 100. I have two fields on Table A, Field1 and Field2. Field 1 has a value of abc, and field 2 is a calculation field with this formula: (Evaluate ( "$$" & Field1 ) ). The calculated result, in this case, should be "100" since that is the value of the Global Variable that I have set on the previous Script. However, I don't know what I am doing wrong. I Evaluate the formula on data viewer and it evaluates it correctly, but on the calculation field, it is just not working. I have tried to set the formula as $$abc directly, and still, it does not perform the calculation on the field. Any ideas would be much appreciated. Thanks a lot in advance for your time. Hi, I just solved the problem, it seems that calculation needs to be set to not store calculation results. Thanks a lot for just reading this!
Hi Guys, I am having trouble with Find Operation getting slower and slower each day. There are some design consideration as per some articles i have read recently which i will be doing as well. I inherited this solution from another developer, Find is based on some Calculation fields which are based further on some other calculation fields (both calculation fields have 'Do not store results' option checked) I know its not the best of designs, i wanted to ask for any possible improvement to Find process as its getting clumsy now. I have indexed relevant fields though, data in the table isn't huge, around 2000 records with 50 fields but Find is based on unstored calculation fields mainly. Can PSOS be used in Find Operation? Is there any other thing i must do at the beginning. Thanks much,
Hi everyone! I'm quite a novice in filemaker compared to many on this forum, but I've been working with it long enough now to have a pretty good hang of how to make it work for me. My problem is as such: My solution needs to create an HTML email when I click a scripted button in the database solution ( company banners, rich-text (like bold and larger fonts for weight) and pictures). The HTML email also needs to be able to have calculation fields from the database so that it works like a targeted "newsletter" or "template" style email that can be sent with custom client information included such as "name, date, location and stuff". The basic idea here is to have an HTML, mail merge kind of thing that auto populates fields from a record in the database by clicking a scripted button. With the core FMP program I can make a plain text e-mail that has fields from the database; with the 360 works plugin I can make an HTML email. Is there anyway I can combine best of both? I want to know if this is possible before buying the plug-in.. PLEASE HELP! Johnny