Search the Community
Showing results for tags 'calculation fields'.
Found 2 results
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