Search the Community
Showing results for tags 'calculation 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
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 i
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