Calculation Engine (Define Fields)

12,869 topics in this forum

1. Creating total summary field from related records

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

2. Auto-completion field with input of two fields

   By Dr.Hamed, September 6, 2016   

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

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

4. Select letters to the left of a charachter

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

5. Preventing duplicates when creating new records using Set Variable

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

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

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

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

   By Franco Pagano, August 26, 2016   

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

8. Rounding issues

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

9. Advanced getField

   By Anthony, August 22, 2016   

   • calculation
   • getfield
   • (and 1 more)

      Tagged with:

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

10. gain or loss between sucessive reccords

    By john9210, August 21, 2016   

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

11. Calculations

    By Smiley, August 16, 2016   

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

12. Sort subsummary

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

13. How to extract data to fields

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

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

15. Counting summarised fields that match a criteria

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

16. Trim ( )

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

17. If statement won't read variable correctly

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

18. calculate a mark reduction by percent

    By troutstudio, August 1, 2016   

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

19. The "and" operator not working

    By Smiley, August 9, 2016   

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

20. Case vs If

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

21. UUID duplicate record

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

22. Summary disaster

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

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

24. TimeStamp Calculation

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

25. rounding up time calculations

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

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

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

27. Nested IF's and CASE's

    By Kurt Hansen, July 26, 2016   

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

28. Calculation field: substitution of key with value

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

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

    By emballantine, July 21, 2016   

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

30. Count tasks based on field

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

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

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

33. Time elapsed calculation causing slowness

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

34. Sort value list

    By Brandon HanYee, July 13, 2016
    • 2 replies
    • 868 views
    • 
    • Brandon HanYee
    • July 14, 2016

35. Calculation-weird output in merge field

    By kathrynfw, July 9, 2016   

    • calculation merge field error
    • 1 reply
    • 987 views
    • 
    • comment
    • July 9, 2016