Calculation Engine (Define Fields)

12,872 topics in this forum

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

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

2. Text Parsing Help - suffix?

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

3. 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
   • 880 views
   • 
   • comment
   • August 21, 2015

4. Extracting and summing data

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

5. Let function syntax

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

6. 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
   • 908 views
   • 
   • ArchFile
   • August 19, 2015

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

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

8. Timestamp vs. Date + Time fields

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

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

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

10. Comparison between layout load times and performance

    By Stu412, August 6, 2015   

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

11. Calculating elapsed time as decimal

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

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

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

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

14. HELP - Inventory Numbering System

    By ADJUDD1402, July 31, 2015   

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

15. 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
    • 2k views
    • 
    • LaRetta
    • July 31, 2015

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

17. Script or indicator when a page has finished loading

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

18. Need help remove *text* from text field

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

19. Date Calculation

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

20. Due date auto change

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

21. Date Find Issue

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

22. Math help

    By rivet, July 23, 2015
    • 7 replies
    • 985 views
    • 
    • rivet
    • July 26, 2015

23. Get age from birthday and Today

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

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

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

25. Future Creation Date with Past Modification Date

    By Kansas, July 7, 2015   

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

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

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

27. Field Help

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

28. Removing text after the last /

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

29. Contract Serial IDs

    By bcooney, July 5, 2015   

    • serial
    • ids
    • (and 1 more)

       Tagged with:

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

30. 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.1k views
    • 
    • Justin Close
    • July 9, 2015

31. Pattern Count and Substitute

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

32. Need help getting a repeating calc to work

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

33. How a repeating fields get a value from nonrepeating field

    By Omer Faruk EMRE, June 28, 2015
    • 8 replies
    • 812 views
    • 
    • Omer Faruk EMRE
    • July 3, 2015

34. Summing totals with GetNthRecord

    By laguna92651, July 1, 2015
    • 16 replies
    • 1.4k views
    • 
    • laguna92651
    • July 2, 2015

35. Counting Records of a Certain Type?

    By emballantine, June 30, 2015
    • 14 replies
    • 1.2k views
    • 
    • emballantine
    • July 2, 2015