Calculation Engine (Define Fields)

12,867 topics in this forum

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

2. Select letters to the left of a charachter

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

3. Preventing duplicates when creating new records using Set Variable

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

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

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

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

   By Franco Pagano, August 26, 2016   

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

6. Rounding issues

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

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

8. gain or loss between sucessive reccords

   By john9210, August 21, 2016   

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

9. Calculations

   By Smiley, August 16, 2016   

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

10. Sort subsummary

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

11. How to extract data to fields

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

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

13. Counting summarised fields that match a criteria

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

14. Trim ( )

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

15. If statement won't read variable correctly

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

16. calculate a mark reduction by percent

    By troutstudio, August 1, 2016   

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

17. The "and" operator not working

    By Smiley, August 9, 2016   

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

18. Case vs If

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

19. UUID duplicate record

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

20. Summary disaster

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

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

22. TimeStamp Calculation

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

23. rounding up time calculations

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

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

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

25. Nested IF's and CASE's

    By Kurt Hansen, July 26, 2016   

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

26. Calculation field: substitution of key with value

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

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

28. Count tasks based on field

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

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

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

31. Time elapsed calculation causing slowness

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

32. Sort value list

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

33. Calculation-weird output in merge field

    By kathrynfw, July 9, 2016   

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

34. First Monday date calculation

    By john9210, July 5, 2016
    • 2 replies
    • 693 views
    • 
    • john9210
    • July 6, 2016

35. Base64 Encode/Decode problems

    By muzz, June 29, 2016   

    • base64
    • empty
    • 12 replies
    • 20.2k views
    • 
    • muzz
    • July 1, 2016