Calculation Engine (Define Fields)

12,880 topics in this forum

1. rounding up time calculations

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

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

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

3. Nested IF's and CASE's

   By Kurt Hansen, July 26, 2016
   • 8 replies
   • 1.5k views
   • 
   • Kurt Hansen
   • July 29, 2016

4. Calculation field: substitution of key with value

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

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

   By emballantine, July 21, 2016
   • 1 reply
   • 1.4k views
   • 
   • Josh Ormond
   • July 21, 2016

6. Count tasks based on field

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

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

   By Guy_Smith, July 19, 2016
   • 4 replies
   • 1.1k views
   • 
   • Guy_Smith
   • July 20, 2016

8. Validating a field using SQL custom function

   By Justin P., July 17, 2016
   • 0 replies
   • 1.2k views
   • 
   • Justin P.
   • July 17, 2016

9. Time elapsed calculation causing slowness

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

10. Sort value list

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

11. Calculation-weird output in merge field

    By kathrynfw, July 9, 2016
    • 1 reply
    • 1.1k views
    • 
    • comment
    • July 9, 2016

12. First Monday date calculation

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

13. Base64 Encode/Decode problems

    By muzz, June 29, 2016
    • 12 replies
    • 22.2k views
    • 
    • muzz
    • July 1, 2016

14. How do I extract a string from a field that matches a text field in one of the records from another table?

    By johnfromberkeley, June 28, 2016
    • 3 replies
    • 763 views
    • 
    • comment
    • June 29, 2016

15. Tax Calculation

    By ZippyT, June 24, 2016
    • 3 replies
    • 977 views
    • 
    • ZippyT
    • June 24, 2016

16. Converting Text to Date

    By dav1089, June 22, 2016
    • 2 replies
    • 1.1k views
    • 
    • dav1089
    • June 23, 2016

17. How to Select Randomly between a range of numbers

    By Maclurv, June 18, 2016
    • 2 replies
    • 1.1k views
    • 
    • Maclurv
    • June 18, 2016

18. Check whether Date is within a Date range

    By Tissot, July 1, 2008
    • 25 replies
    • 10.9k views
    • 
    • LaRetta
    • June 17, 2016

19. char(number) not working as I expected...

    By philipcaplan, June 16, 2016
    • 1 reply
    • 821 views
    • 
    • comment
    • June 16, 2016

20. Converting decimal values into proper time format

    By McScripta, June 15, 2016
    • 12 replies
    • 1.4k views
    • 
    • McScripta
    • June 16, 2016

21. Different scripting result depending on Filemaker version, 13, 14, 15

    By Tompa79, June 13, 2016
    • 3 replies
    • 860 views
    • 
    • Wim Decorte
    • June 13, 2016

22. summary count over several fields

    By beckham, June 13, 2016
    • 1 reply
    • 835 views
    • 
    • comment
    • June 13, 2016

23. Filed name ending in space on cvs file

    By adrianatwork, June 11, 2016
    • 4 replies
    • 1.2k views
    • 
    • comment
    • June 12, 2016

24. Calculation across related tables.

    By charisse, June 8, 2016
    • 11 replies
    • 1.2k views
    • 
    • comment
    • June 10, 2016

25. Counting tasks due

    By Smiley, June 8, 2016
    • 5 replies
    • 722 views
    • 
    • comment
    • June 8, 2016

26. Date range calculation criteria

    By Miss A!, June 8, 2016
    • 2 replies
    • 2.1k views
    • 
    • Miss A!
    • June 8, 2016

27. Counting records between NOT directly linked tables (1 & 3)

    By AGilek, June 7, 2016
    • 2 replies
    • 1.3k views
    • 
    • AGilek
    • June 8, 2016

28. Hiding objects on multiple rules

    By Smiley, June 2, 2016
    • 11 replies
    • 5.1k views
    • 
    • Josh Ormond
    • June 7, 2016

29. Go to portal row

    By Philip Jenks, June 6, 2016
    • 12 replies
    • 5k views
    • 
    • Ron Cates
    • June 7, 2016

30. Calculation

    By indy4300, June 4, 2016
    • 8 replies
    • 874 views
    • 
    • indy4300
    • June 4, 2016

31. Fuel Consumption

    By Ninja, June 1, 2016
    • 6 replies
    • 1.4k views
    • 
    • comment
    • June 3, 2016

32. Rounding a summary field

    By indy4300, June 2, 2016
    • 2 replies
    • 1.4k views
    • 
    • indy4300
    • June 2, 2016

33. Counting Number of pages when printing

    By Smiley, June 2, 2016
    • 3 replies
    • 694 views
    • 
    • comment
    • June 2, 2016

34. Seperating A Address Field

    By Kevin Roach, June 2, 2016
    • 1 reply
    • 777 views
    • 
    • comment
    • June 2, 2016

35. Rounding a summary field

    By indy4300, June 1, 2016
    • 3 replies
    • 769 views
    • 
    • indy4300
    • June 1, 2016