Calculation Engine (Define Fields)

12,871 topics in this forum

1. Multiple values in a single field, how to get the highest

   By aharown07, September 10, 2016   

   • max
   • 2 replies
   • 869 views
   • 
   • aharown07
   • September 10, 2016

2. Calc combined list of two fields

   By shredded, September 8, 2016
   • 12 replies
   • 1.4k views
   • 
   • comment
   • September 9, 2016

3. Creating total summary field from related records

   By muskee, September 6, 2016
   • 3 replies
   • 812 views
   • 
   • comment
   • September 7, 2016

4. Auto-completion field with input of two fields

   By Dr.Hamed, September 6, 2016   

   • autocompletion
   • 1 reply
   • 677 views
   • 
   • Agnes Riley
   • September 6, 2016

5. Enter data in a field in one table and automatically enters data in a field in another table

   By dansan500, September 1, 2016   

   • post in two places
   • post in two tables
   • 6 replies
   • 1.1k views
   • 
   • LaRetta
   • September 1, 2016

6. Select letters to the left of a charachter

   By genious, August 31, 2016
   • 2 replies
   • 799 views
   • 
   • genious
   • August 31, 2016

7. Preventing duplicates when creating new records using Set Variable

   By kbee, August 29, 2016
   • 3 replies
   • 1.1k views
   • 
   • kbee
   • August 29, 2016

8. Revert Record if field in portal equals a certain value

   By Steve Martino, August 27, 2016
   • 2 replies
   • 635 views
   • 
   • Steve Martino
   • August 27, 2016

9. applescript set var to cell "myfield" ...

   By Franco Pagano, August 26, 2016   

   • applescript
   • 4 replies
   • 2.3k views
   • 
   • Franco Pagano
   • August 27, 2016

10. Rounding issues

    By Dermot, August 23, 2016
    • 4 replies
    • 1.4k views
    • 
    • Dermot
    • August 23, 2016

11. Advanced getField

    By Anthony, August 22, 2016   

    • calculation
    • getfield
    • (and 1 more)

       Tagged with:

      • calculation
      • getfield
      • reference
    • 6 replies
    • 1.8k views
    • 
    • Anthony
    • August 22, 2016

12. gain or loss between sucessive reccords

    By john9210, August 21, 2016   

    • fms13
    • fmp15
    • 6 replies
    • 1.1k views
    • 
    • john9210
    • August 21, 2016

13. Calculations

    By Smiley, August 16, 2016   

    • calulations
    • 0 replies
    • 642 views
    • 
    • Smiley
    • August 16, 2016

14. Sort subsummary

    By Brandon HanYee, August 16, 2016
    • 0 replies
    • 675 views
    • 
    • Brandon HanYee
    • August 16, 2016

15. How to extract data to fields

    By cos, June 7, 2016
    • 20 replies
    • 1.5k views
    • 
    • Trente
    • August 15, 2016

16. Calculate Employee Sick leave accumulation

    By Miss A!, August 11, 2016   

    • employee
    • hr
    • (and 1 more)

       Tagged with:

      • employee
      • hr
      • leave days
    • 5 replies
    • 1.2k views
    • 
    • webko
    • August 15, 2016

17. Counting summarised fields that match a criteria

    By JoeHardstaff, July 26, 2016
    • 8 replies
    • 2.5k views
    • 
    • JoeHardstaff
    • August 12, 2016

18. Trim ( )

    By "... you mean these fans?", August 12, 2016
    • 2 replies
    • 816 views
    • 
    • comment
    • August 12, 2016

19. If statement won't read variable correctly

    By Gerry, August 11, 2016
    • 8 replies
    • 898 views
    • 
    • Agnes Riley
    • August 12, 2016

20. calculate a mark reduction by percent

    By troutstudio, August 1, 2016   

    • percentage calculations
    • 6 replies
    • 1.5k views
    • 
    • troutstudio
    • August 10, 2016

21. The "and" operator not working

    By Smiley, August 9, 2016   

    • operator
    • and
    • 4 replies
    • 789 views
    • 
    • LaRetta
    • August 9, 2016

22. Case vs If

    By OlgerDiekstra, August 9, 2016
    • 4 replies
    • 1.7k views
    • 
    • comment
    • August 9, 2016

23. UUID duplicate record

    By Charity, August 5, 2016
    • 1 reply
    • 1.9k views
    • 
    • doughemi
    • August 6, 2016

24. Summary disaster

    By [email protected], August 3, 2016
    • 1 reply
    • 776 views
    • 
    • Wim Decorte
    • August 3, 2016

25. How to hide records that are no longer needed?

    By emtau, June 7, 2016   

    • hide
    • expired
    • (and 4 more)

       Tagged with:

      • hide
      • expired
      • no longer needed
      • delete
      • hide records
      • ex
    • 3 replies
    • 2.8k views
    • 
    • emtau
    • August 3, 2016

26. TimeStamp Calculation

    By rudym88, May 3, 2016
    • 10 replies
    • 2.7k views
    • 
    • comment
    • August 1, 2016

27. rounding up time calculations

    By littlered136, July 29, 2016
    • 28 replies
    • 3.3k views
    • 
    • littlered136
    • August 1, 2016

28. How do you determine # of consonant letters in an English word?

    By Heng, July 30, 2016
    • 4 replies
    • 736 views
    • 
    • comment
    • July 30, 2016

29. Nested IF's and CASE's

    By Kurt Hansen, July 26, 2016   

    • if
    • case
    • 8 replies
    • 1.3k views
    • 
    • Kurt Hansen
    • July 29, 2016

30. Calculation field: substitution of key with value

    By Voljen, July 25, 2016
    • 4 replies
    • 743 views
    • 
    • Voljen
    • July 26, 2016

31. Auto Enter Entry - when does filemaker auto enter a creation time stamp?

    By emballantine, July 21, 2016   

    • auto enter
    • 1 reply
    • 1.2k views
    • 
    • Josh Ormond
    • July 21, 2016

32. Count tasks based on field

    By Jacob Talbot, July 21, 2016
    • 2 replies
    • 867 views
    • 
    • comment
    • July 21, 2016

33. How to Subtract a Sum of several Child Records from an Initial Value in a Parent Record

    By Guy_Smith, July 19, 2016   

    • calculation
    • portal
    • (and 1 more)

       Tagged with:

      • calculation
      • portal
      • file attached
    • 4 replies
    • 1k views
    • 
    • Guy_Smith
    • July 20, 2016

34. Validating a field using SQL custom function

    By Justin P., July 17, 2016   

    • fmp14
    • validation
    • (and 1 more)

       Tagged with:

      • fmp14
      • validation
      • executesql
    • 0 replies
    • 1.1k views
    • 
    • Justin P.
    • July 17, 2016

35. Time elapsed calculation causing slowness

    By sal88, March 24, 2014
    • 16 replies
    • 1.9k views
    • 
    • sal88
    • July 15, 2016