Calculation Engine (Define Fields)

12,875 topics in this forum

1. Counting values across different fields

   By sinisa93, September 9, 2016
   • 6 replies
   • 1k views
   • 
   • sinisa93
   • September 19, 2016

2. Parsing Negative Values

   By "... you mean these fans?", September 18, 2016
   • 2 replies
   • 862 views
   • 
   • "... you mean these fans?"
   • September 18, 2016

3. Get Current Time as HH:mm:ssZ

   By Devin, September 15, 2016
   • 6 replies
   • 1.8k views
   • 
   • comment
   • September 15, 2016

4. How to not increment a field with an auto enter increment

   By Oyseka, September 14, 2016   

   • calculation
   • duplicate records
   • (and 1 more)

      Tagged with:

     • calculation
     • duplicate records
     • fixedid
   • 0 replies
   • 1.1k views
   • 
   • Oyseka
   • September 14, 2016

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

   By aharown07, September 10, 2016   

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

6. Calc combined list of two fields

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

7. Creating total summary field from related records

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

8. Auto-completion field with input of two fields

   By Dr.Hamed, September 6, 2016   

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

9. 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.4k views
   • 
   • LaRetta
   • September 1, 2016

10. Select letters to the left of a charachter

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

11. Preventing duplicates when creating new records using Set Variable

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

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

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

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

    By Franco Pagano, August 26, 2016   

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

14. Rounding issues

    By FM User New, August 23, 2016
    • 4 replies
    • 1.6k views
    • 
    • FM User New
    • August 23, 2016

15. Advanced getField

    By Anthony, August 22, 2016   

    • calculation
    • getfield
    • (and 1 more)

       Tagged with:

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

16. gain or loss between sucessive reccords

    By john9210, August 21, 2016   

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

17. Calculations

    By Smiley, August 16, 2016   

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

18. Sort subsummary

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

19. How to extract data to fields

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

20. 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.3k views
    • 
    • webko
    • August 15, 2016

21. Counting summarised fields that match a criteria

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

22. Trim ( )

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

23. If statement won't read variable correctly

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

24. calculate a mark reduction by percent

    By troutstudio, August 1, 2016   

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

25. The "and" operator not working

    By Smiley, August 9, 2016   

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

26. Case vs If

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

27. UUID duplicate record

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

28. Summary disaster

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

29. 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
    • 3k views
    • 
    • emtau
    • August 3, 2016

30. TimeStamp Calculation

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

31. rounding up time calculations

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

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

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

33. Nested IF's and CASE's

    By Kurt Hansen, July 26, 2016   

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

34. Calculation field: substitution of key with value

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

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

    By emballantine, July 21, 2016   

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