Calculation Engine (Define Fields)

12,872 topics in this forum

1. Extract account name in front of the "@" sign in an e-mail addy

   By Rich S, October 6, 2015
   • 5 replies
   • 813 views
   • 
   • comment
   • October 7, 2015

2. seconds to minutes

   By Poruchan, October 5, 2015   

   • calculation
   • time
   • 9 replies
   • 2.7k views
   • 
   • Poruchan
   • October 5, 2015

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

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

4. 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

5. How to display calculation correctly

   By loscamos, September 21, 2015   

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

6. Adding summary fields

   By Snorkell, September 30, 2015   

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

7. Simple inventory database

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

8. Value lists in calculation fields

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

9. Let Function

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

10. Data Viewr Versus Calulated Field error

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

11. Running count of multiple checkbox selected products

    By FMData12, September 18, 2015   

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

12. Summarize field if another field equals a set parameter

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

13. Summary field sorting slow in related table

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

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

    By jl2017, September 16, 2015   

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

15. Sequentially enter 1 of 3 numbers?

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

16. Calc for performing find based on value list

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

17. Starting a new project

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

18. Counting with two specific values

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

19. Detecting only blank spaces in field

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

20. Counting fields with value in them

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

21. Percentage Values in Found Set

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

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

    By bleapy, September 9, 2015   

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

23. Evaluate()

    By bleapy, September 3, 2015   

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

24. 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

25. 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.3k views
    • 
    • Kris M
    • September 9, 2015

26. Filter by length and case

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

27. Sub Query within ExecuteSQL

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

28. 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.7k views
    • 
    • OlgerDiekstra
    • September 2, 2015

29. Timestamp ISO 8601 conversion with fraction of Seconds.

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

30. Hours Tracking

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

31. Field Validation

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

32. Proper, but not for everything

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

33. Multi-part composite serial number for items

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

34. ExecuteSQL Sum Breakdown

    By WSaxton, August 27, 2015   

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

35. Indent in FM 14

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