Calculation Engine (Define Fields)

12,867 topics in this forum

1. 3 values selection relationships and tables

   By wattmhite, August 17, 2017
   • 2 replies
   • 653 views
   • 
   • comment
   • August 17, 2017

2. Calculate Phone costs nightmare

   By dkey, August 17, 2017   

   • minutes
   • seconds
   • (and 1 more)

      Tagged with:

     • minutes
     • seconds
     • decimals
   • 2 replies
   • 792 views
   • 
   • dkey
   • August 17, 2017

3. Saturday date (numeric) based on month input

   By John Chamberlain, August 16, 2017
   • 3 replies
   • 720 views
   • 
   • Steve Martino
   • August 17, 2017

4. Ignoring & and and - in names

   By wattmhite, August 16, 2017
   • 1 reply
   • 639 views
   • 
   • comment
   • August 16, 2017

5. Balance/Quantity Returned

   By Lola, August 15, 2017
   • 8 replies
   • 1.4k views
   • 
   • Lola
   • August 15, 2017

6. JSONPath with FM JSON functions

   By TJ53, August 6, 2017
   • 2 replies
   • 975 views
   • 
   • TJ53
   • August 10, 2017

7. If a calculation field results in a negative it is not used in another calculation field

   By littlered136, August 7, 2017
   • 4 replies
   • 891 views
   • 
   • littlered136
   • August 7, 2017

8. SUM of one field, based on criteria from two other fields

   By NewBoard, August 2, 2017   

   • sum
   • fields
   • (and 3 more)

      Tagged with:

     • sum
     • fields
     • year
     • supplier
     • name
   • 4 replies
   • 2.7k views
   • 
   • Lee Smith
   • August 3, 2017

9. Countdown timers

   By Wayne Irvine, July 28, 2017   

   • timer
   • 1 reply
   • 2.2k views
   • 
   • comment
   • July 28, 2017

10. Force Answer when = ?

    By hutchlad, July 27, 2017   

    • calculation
    • filemaker
    • (and 1 more)

       Tagged with:

      • calculation
      • filemaker
      • field calc
    • 4 replies
    • 1.1k views
    • 
    • comment
    • July 27, 2017

11. web scraping getting text between two text strings. 1 2 3

    By hownow, December 29, 2014
    • 70 replies
    • 8.2k views
    • 
    • Quito
    • July 25, 2017

12. How to use a global variable within a calcualtion field

    By docasar, July 19, 2017   

    • global variable
    • calculation fields
    • 3 replies
    • 1.7k views
    • 
    • Wim Decorte
    • July 21, 2017

13. Deriving a value from another record

    By birder, July 19, 2017
    • 6 replies
    • 861 views
    • 
    • birder
    • July 19, 2017

14. Highlight Calculation

    By bcooney, July 14, 2017   

    • display
    • highlight
    • (and 2 more)

       Tagged with:

      • display
      • highlight
      • stored
      • style
    • 4 replies
    • 974 views
    • 
    • bcooney
    • July 18, 2017

15. Find prior Wednesday

    By rob, July 12, 2017
    • 2 replies
    • 803 views
    • 
    • comment
    • July 12, 2017

16. Calculating format premiums

    By enquirerfm, July 5, 2017   

    • summary
    • calculation
    • 11 replies
    • 1.8k views
    • 
    • enquirerfm
    • July 12, 2017

17. Trying to auto enter Current Date in Date field based on Get (ModifiedFields)

    By cbum, July 9, 2017
    • 5 replies
    • 1.2k views
    • 
    • comment
    • July 9, 2017

18. Strip the last five characters from a field name

    By Rich S, July 9, 2017
    • 2 replies
    • 48.1k views
    • 
    • comment
    • July 9, 2017

19. Print last rows of the portal

    By emtau, July 4, 2017
    • 8 replies
    • 988 views
    • 
    • emtau
    • July 5, 2017

20. Filled-In Fields From Related Records

    By CBarnes, July 4, 2017
    • 4 replies
    • 839 views
    • 
    • comment
    • July 4, 2017

21. Summarize 2 data points for time display?

    By wattmhite, June 30, 2017
    • 3 replies
    • 1.1k views
    • 
    • LaRetta
    • July 2, 2017

22. First and last date date of Week number

    By wattmhite, June 30, 2017
    • 2 replies
    • 2.6k views
    • 
    • comment
    • June 30, 2017

23. Encode data to smart card (contact less card)

    By hasru, November 1, 2008
    • 7 replies
    • 3k views
    • 
    • sri tekukur
    • June 28, 2017

24. Time lapsed - with no end time and on the fly?

    By wattmhite, June 26, 2017
    • 1 reply
    • 810 views
    • 
    • comment
    • June 26, 2017

25. Sync Between Two Diffrent layout field Records in one way

    By samarthmkt, June 26, 2017
    • 0 replies
    • 610 views
    • 
    • samarthmkt
    • June 26, 2017

26. Logic for multiple values used in a sentence

    By Rich S, June 23, 2017
    • 2 replies
    • 879 views
    • 
    • Rich S
    • June 26, 2017

27. Calculating overtime?

    By wattmhite, June 22, 2017
    • 2 replies
    • 872 views
    • 
    • comment
    • June 22, 2017

28. Summarize 3 time fields?

    By wattmhite, June 22, 2017
    • 1 reply
    • 788 views
    • 
    • Ocean West
    • June 22, 2017

29. filemaker iterate (Loop) parsing text

    By Devin, June 10, 2017
    • 16 replies
    • 2.7k views
    • 
    • Devin
    • June 13, 2017

30. Random number from value list?

    By Matthew R White, June 12, 2017
    • 1 reply
    • 801 views
    • 
    • comment
    • June 12, 2017

31. I assume this is simple...

    By JTSmith, June 5, 2017
    • 2 replies
    • 897 views
    • 
    • Lee Smith
    • June 5, 2017

32. Checkbox Set/Filtering a list view

    By Steve Martino, June 2, 2017
    • 0 replies
    • 916 views
    • 
    • Steve Martino
    • June 2, 2017

33. Extracting Multiple Text from One Field

    By OneStop, May 31, 2017
    • 18 replies
    • 2.1k views
    • 
    • LaRetta
    • May 31, 2017

34. Week Picker

    By jagstirling, May 27, 2017
    • 2 replies
    • 1.3k views
    • 
    • jagstirling
    • May 31, 2017

35. Letter Grade Formula

    By jmille011, May 30, 2017
    • 5 replies
    • 929 views
    • 
    • Lee Smith
    • May 30, 2017