Calculation Engine (Define Fields)

12,881 topics in this forum

1. Sub Query within ExecuteSQL

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

2. Birthday reminder from Filemaker via email

   By emtau, August 25, 2015
   • 17 replies
   • 8.1k views
   • 
   • OlgerDiekstra
   • September 2, 2015

3. Timestamp ISO 8601 conversion with fraction of Seconds.

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

4. Hours Tracking

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

5. Field Validation

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

6. Proper, but not for everything

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

7. Multi-part composite serial number for items

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

8. ExecuteSQL Sum Breakdown

   By WSaxton, August 27, 2015
   • 2 replies
   • 1k views
   • 
   • WSaxton
   • August 27, 2015

9. Indent in FM 14

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

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

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

11. Text Parsing Help - suffix?

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

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

    By gfr92y, August 20, 2015
    • 7 replies
    • 977 views
    • 
    • comment
    • August 21, 2015

13. Extracting and summing data

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

14. Let function syntax

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

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

    By ArchFile, July 22, 2015
    • 3 replies
    • 1k views
    • 
    • ArchFile
    • August 19, 2015

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

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

17. Timestamp vs. Date + Time fields

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

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

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

19. Comparison between layout load times and performance

    By Stu412, August 6, 2015
    • 0 replies
    • 944 views
    • 
    • Stu412
    • August 6, 2015

20. Calculating elapsed time as decimal

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

21. Conditional Summing

    By Gurratheboy, August 4, 2015
    • 1 reply
    • 1.6k views
    • 
    • comment
    • August 4, 2015

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

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

23. HELP - Inventory Numbering System

    By ADJUDD1402, July 31, 2015
    • 8 replies
    • 2.3k views
    • 
    • bruceR
    • August 1, 2015

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

    By Stu412, July 31, 2015
    • 14 replies
    • 2.3k views
    • 
    • LaRetta
    • July 31, 2015

25. Reset Invoice Number for Month (script issue)

    By ADJUDD1402, July 31, 2015
    • 2 replies
    • 1.2k views
    • 
    • comment
    • July 31, 2015

26. Script or indicator when a page has finished loading

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

27. Need help remove *text* from text field

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

28. Date Calculation

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

29. Due date auto change

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

30. Date Find Issue

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

31. Math help

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

32. Get age from birthday and Today

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

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

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

34. Future Creation Date with Past Modification Date

    By Kansas, July 7, 2015
    • 8 replies
    • 1.4k views
    • 
    • Kansas
    • July 15, 2015

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

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