Calculation Engine (Define Fields)

12,875 topics in this forum

1. Dynamic Clock possible?

   By Mikhail, October 3, 2015
   • 7 replies
   • 1.1k views
   • 
   • ggt667
   • October 8, 2015

2. Mixing manual entry fields and calculation fields in List view

   By laguna92651, October 7, 2015
   • 4 replies
   • 814 views
   • 
   • laguna92651
   • October 8, 2015

3. exporting data from a relational databases

   By msoussi, October 7, 2015
   • 8 replies
   • 801 views
   • 
   • Lee Smith
   • October 7, 2015

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

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

5. seconds to minutes

   By Poruchan, October 5, 2015   

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

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

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

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

8. How to display calculation correctly

   By loscamos, September 21, 2015   

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

9. Adding summary fields

   By Snorkell, September 30, 2015   

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

10. Simple inventory database

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

11. Value lists in calculation fields

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

12. Let Function

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

13. Data Viewr Versus Calulated Field error

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

14. Running count of multiple checkbox selected products

    By FMData12, September 18, 2015   

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

15. Summarize field if another field equals a set parameter

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

16. Summary field sorting slow in related table

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

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

18. Sequentially enter 1 of 3 numbers?

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

19. Calc for performing find based on value list

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

20. Starting a new project

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

21. Counting with two specific values

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

22. Detecting only blank spaces in field

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

23. Counting fields with value in them

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

24. Percentage Values in Found Set

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

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

    By bleapy, September 9, 2015   

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

26. Evaluate()

    By bleapy, September 3, 2015   

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

27. Case function using Position function

    By Stu412, September 8, 2015   

    • case
    • position
    • (and 1 more)

       Tagged with:

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

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

29. Filter by length and case

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

30. Sub Query within ExecuteSQL

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

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

32. Timestamp ISO 8601 conversion with fraction of Seconds.

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

33. Hours Tracking

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

34. Field Validation

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

35. Proper, but not for everything

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