Calculation Engine (Define Fields)

12,875 topics in this forum

1. Multi-part composite serial number for items

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

2. ExecuteSQL Sum Breakdown

   By WSaxton, August 27, 2015   

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

3. Indent in FM 14

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

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

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

5. Text Parsing Help - suffix?

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

6. Populating a field with a max value from another field for groups of records

   By gfr92y, August 20, 2015   

   • populating fields
   • maximum value
   • 7 replies
   • 922 views
   • 
   • comment
   • August 21, 2015

7. Extracting and summing data

   By Valdrin, August 18, 2015
   • 2 replies
   • 615 views
   • 
   • Valdrin
   • August 21, 2015

8. Let function syntax

   By redefmbrasil, August 19, 2015
   • 2 replies
   • 696 views
   • 
   • redefmbrasil
   • August 19, 2015

9. Using Case (or If?) to Replace Field Content in a Checkbox Set after updating the Value List

   By ArchFile, July 22, 2015   

   • case
   • checkbox set
   • (and 2 more)

      Tagged with:

     • case
     • checkbox set
     • replace field content
     • value list
   • 3 replies
   • 962 views
   • 
   • ArchFile
   • August 19, 2015

10. Creating a record for every Friday in a month...

    By MParker, August 12, 2015
    • 2 replies
    • 872 views
    • 
    • MParker
    • August 13, 2015

11. Timestamp vs. Date + Time fields

    By Justin Close, August 5, 2015
    • 13 replies
    • 2.8k views
    • 
    • Justin Close
    • August 7, 2015

12. Number of days between two dates calculation???

    By burnerofhells, March 19, 2008
    • 6 replies
    • 15.2k views
    • 
    • comment
    • August 6, 2015

13. Comparison between layout load times and performance

    By Stu412, August 6, 2015   

    • performance
    • 0 replies
    • 907 views
    • 
    • Stu412
    • August 6, 2015

14. Calculating elapsed time as decimal

    By madman411, August 5, 2015
    • 4 replies
    • 1.6k views
    • 
    • madman411
    • August 5, 2015

15. Conditional Summing

    By Gurratheboy, August 4, 2015   

    • sum
    • conditional
    • (and 4 more)

       Tagged with:

      • sum
      • conditional
      • if
      • filemaker
      • 14
      • functions
    • 1 reply
    • 1.5k views
    • 
    • comment
    • August 4, 2015

16. Extracting part of a layout name to use in a calculation

    By brainonastick, August 3, 2015
    • 1 reply
    • 666 views
    • 
    • Ocean West
    • August 3, 2015

17. HELP - Inventory Numbering System

    By ADJUDD1402, July 31, 2015   

    • inventory number
    • 8 replies
    • 2.2k views
    • 
    • bruceR
    • August 1, 2015

18. Need to find max date then calculate, then next max date etc

    By Stu412, July 31, 2015   

    • dates
    • maximum
    • (and 1 more)

       Tagged with:

      • dates
      • maximum
      • pivot
    • 14 replies
    • 2.2k views
    • 
    • LaRetta
    • July 31, 2015

19. Reset Invoice Number for Month (script issue)

    By ADJUDD1402, July 31, 2015   

    • reset invoice number
    • script with invoice number
    • 2 replies
    • 1.1k views
    • 
    • comment
    • July 31, 2015

20. Script or indicator when a page has finished loading

    By Matthew R White, July 29, 2015
    • 2 replies
    • 886 views
    • 
    • Wim Decorte
    • July 29, 2015

21. Need help remove *text* from text field

    By Johhhn, July 29, 2015
    • 2 replies
    • 828 views
    • 
    • Johhhn
    • July 29, 2015

22. Date Calculation

    By cterrell16, July 27, 2015
    • 6 replies
    • 987 views
    • 
    • comment
    • July 28, 2015

23. Due date auto change

    By cterrell16, July 23, 2015
    • 6 replies
    • 1.2k views
    • 
    • cterrell16
    • July 27, 2015

24. Date Find Issue

    By biggles1212, July 27, 2015
    • 5 replies
    • 1.3k views
    • 
    • comment
    • July 27, 2015

25. Math help

    By rivet, July 23, 2015
    • 7 replies
    • 1k views
    • 
    • rivet
    • July 26, 2015

26. Get age from birthday and Today

    By Bikeman17, July 23, 2015
    • 3 replies
    • 1.5k views
    • 
    • Bikeman17
    • July 23, 2015

27. Extract Email id's with matching domain from list of values

    By Deepak Kumar, July 16, 2015
    • 6 replies
    • 1.2k views
    • 
    • Deepak Kumar
    • July 18, 2015

28. Future Creation Date with Past Modification Date

    By Kansas, July 7, 2015   

    • auto enter creation date
    • 8 replies
    • 1.4k views
    • 
    • Kansas
    • July 15, 2015

29. Counting records with specific field value (SQL?)

    By madman411, July 1, 2015
    • 13 replies
    • 5.7k views
    • 
    • madman411
    • July 12, 2015

30. Field Help

    By cterrell16, July 8, 2015
    • 3 replies
    • 716 views
    • 
    • Wim Decorte
    • July 10, 2015

31. Removing text after the last /

    By ddinisco, July 9, 2015
    • 4 replies
    • 973 views
    • 
    • dwdata
    • July 10, 2015

32. Contract Serial IDs

    By bcooney, July 5, 2015   

    • serial
    • ids
    • (and 1 more)

       Tagged with:

      • serial
      • ids
      • series
    • 8 replies
    • 2.1k views
    • 
    • bcooney
    • July 9, 2015

33. FM9 incompatible step in calculation?

    By Justin Close, July 8, 2015   

    • custom function
    • calculation
    • (and 1 more)

       Tagged with:

      • custom function
      • calculation
      • fm9
    • 2 replies
    • 2.2k views
    • 
    • Justin Close
    • July 9, 2015

34. Pattern Count and Substitute

    By Deepak Kumar, October 25, 2013
    • 5 replies
    • 1.4k views
    • 
    • bruceR
    • July 7, 2015

35. Need help getting a repeating calc to work

    By yilbber, July 6, 2015
    • 7 replies
    • 1.7k views
    • 
    • yilbber
    • July 7, 2015