Jump to content

Search the Community

Showing results for tags 'calculation fields'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 3 results

  1. 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!
  2. 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
  3. 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,
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.