Calculation Engine (Define Fields)

12,870 topics in this forum

1. Space in a field is not a null return?

   By John Chamberlain, October 3, 2015
   • 1 reply
   • 763 views
   • 
   • comment
   • October 3, 2015

2. Format text no matter what is entered into the field

   By Matthew R White, October 1, 2015
   • 4 replies
   • 2.5k views
   • 
   • bcooney
   • October 1, 2015

3. How to display calculation correctly

   By loscamos, September 21, 2015   

   • calculation
   • 17 replies
   • 1.3k views
   • 
   • dwdata
   • September 30, 2015

4. Adding summary fields

   By Snorkell, September 30, 2015   

   • addition summary fields
   • 0 replies
   • 528 views
   • 
   • Snorkell
   • September 30, 2015

5. Simple inventory database

   By confusedmuch, September 26, 2015
   • 6 replies
   • 3.2k views
   • 
   • comment
   • September 29, 2015

6. Value lists in calculation fields

   By Phillip Prahl, September 24, 2015
   • 3 replies
   • 668 views
   • 
   • comment
   • September 26, 2015

7. Let Function

   By aguest, September 25, 2015
   • 2 replies
   • 849 views
   • 
   • Lee Smith
   • September 25, 2015

8. Data Viewr Versus Calulated Field error

   By dkey, September 2, 2015
   • 12 replies
   • 1.1k views
   • 
   • Lee Smith
   • September 21, 2015

9. Running count of multiple checkbox selected products

   By FMData12, September 18, 2015   

   • checkbox
   • 2 replies
   • 1.6k views
   • 
   • FMData12
   • September 21, 2015

10. Summarize field if another field equals a set parameter

    By Matthew R White, September 18, 2015
    • 2 replies
    • 608 views
    • 
    • comment
    • September 19, 2015

11. Summary field sorting slow in related table

    By ACT, September 18, 2015
    • 0 replies
    • 584 views
    • 
    • ACT
    • September 18, 2015

12. Extracting string of text from one field with different variables

    By jl2017, September 16, 2015   

    • text strings
    • extracting text
    • 7 replies
    • 1.2k views
    • 
    • comment
    • September 16, 2015

13. Sequentially enter 1 of 3 numbers?

    By Matthew R White, August 20, 2015
    • 16 replies
    • 1.1k views
    • 
    • comment
    • September 15, 2015

14. Calc for performing find based on value list

    By Steve Martino, September 12, 2015
    • 4 replies
    • 613 views
    • 
    • Steve Martino
    • September 14, 2015

15. Starting a new project

    By genious, September 12, 2015
    • 0 replies
    • 655 views
    • 
    • genious
    • September 12, 2015

16. Counting with two specific values

    By madman411, September 11, 2015
    • 3 replies
    • 644 views
    • 
    • madman411
    • September 12, 2015

17. Detecting only blank spaces in field

    By McScripta, September 11, 2015
    • 4 replies
    • 1.1k views
    • 
    • McScripta
    • September 11, 2015

18. Counting fields with value in them

    By McScripta, September 11, 2015
    • 3 replies
    • 704 views
    • 
    • comment
    • September 11, 2015

19. Percentage Values in Found Set

    By Chuck, September 11, 2015
    • 2 replies
    • 600 views
    • 
    • comment
    • September 11, 2015

20. Copy All Records in One Table to a Dummy Table

    By bleapy, September 9, 2015   

    • copy records
    • importing
    • 7 replies
    • 3.1k views
    • 
    • bleapy
    • September 10, 2015

21. Evaluate()

    By bleapy, September 3, 2015   

    • evaluate()
    • 8 replies
    • 1.1k views
    • 
    • bleapy
    • September 9, 2015

22. Case function using Position function

    By Stu412, September 8, 2015   

    • case
    • position
    • (and 1 more)

       Tagged with:

      • case
      • position
      • calculation
    • 13 replies
    • 1.7k views
    • 
    • Wim Decorte
    • September 9, 2015

23. Better way to CrossTab than FM Advanced training book?

    By Stu412, September 9, 2015   

    • crosstab
    • case
    • (and 1 more)

       Tagged with:

      • crosstab
      • case
      • summary
    • 1 reply
    • 1.2k views
    • 
    • Kris M
    • September 9, 2015

24. Filter by length and case

    By sal88, August 31, 2015
    • 6 replies
    • 728 views
    • 
    • sal88
    • September 4, 2015

25. Sub Query within ExecuteSQL

    By aguest, September 3, 2015
    • 3 replies
    • 3.7k views
    • 
    • eos
    • September 3, 2015

26. Birthday reminder from Filemaker via email

    By emtau, August 25, 2015   

    • email reminder
    • email
    • (and 3 more)

       Tagged with:

      • email reminder
      • email
      • automatically
      • birthday
      • reminder
    • 17 replies
    • 7.6k views
    • 
    • OlgerDiekstra
    • September 2, 2015

27. Timestamp ISO 8601 conversion with fraction of Seconds.

    By Devin, September 1, 2015
    • 8 replies
    • 3.3k views
    • 
    • Devin
    • September 2, 2015

28. Hours Tracking

    By Beuwolf, August 25, 2015
    • 17 replies
    • 1k views
    • 
    • Beuwolf
    • September 2, 2015

29. Field Validation

    By redefmbrasil, August 31, 2015
    • 3 replies
    • 627 views
    • 
    • Kris M
    • August 31, 2015

30. Proper, but not for everything

    By Montana50, August 28, 2015
    • 5 replies
    • 729 views
    • 
    • Montana50
    • August 28, 2015

31. Multi-part composite serial number for items

    By Gabriel G, August 27, 2015
    • 4 replies
    • 719 views
    • 
    • Gabriel G
    • August 28, 2015

32. ExecuteSQL Sum Breakdown

    By WSaxton, August 27, 2015   

    • executesql
    • 2 replies
    • 901 views
    • 
    • WSaxton
    • August 27, 2015

33. Indent in FM 14

    By Montana50, August 15, 2015
    • 5 replies
    • 802 views
    • 
    • Montana50
    • August 27, 2015

34. Calculation date based on get current date and limited to prior 2015

    By Matthew R White, August 24, 2015
    • 13 replies
    • 885 views
    • 
    • comment
    • August 25, 2015

35. Text Parsing Help - suffix?

    By Matthew R White, August 20, 2015
    • 4 replies
    • 889 views
    • 
    • comment
    • August 24, 2015