Calculation Engine (Define Fields)

12,869 topics in this forum

1. date ca First Monday Calculation

   By John Chamberlain, August 22, 2017   

   • calulations
   • 2 replies
   • 702 views
   • 
   • John Chamberlain
   • August 22, 2017

2. Rank function

   By Trpan_z, August 17, 2017   

   • rank
   • 11 replies
   • 3.1k views
   • 
   • comment
   • August 19, 2017

3. 3 values selection relationships and tables

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

4. Calculate Phone costs nightmare

   By dkey, August 17, 2017   

   • minutes
   • seconds
   • (and 1 more)

      Tagged with:

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

5. Saturday date (numeric) based on month input

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

6. Ignoring & and and - in names

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

7. Balance/Quantity Returned

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

8. JSONPath with FM JSON functions

   By TJ53, August 6, 2017
   • 2 replies
   • 1k views
   • 
   • TJ53
   • August 10, 2017

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

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

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

11. Countdown timers

    By Wayne Irvine, July 28, 2017   

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

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

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

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

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

    By docasar, July 19, 2017   

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

15. Deriving a value from another record

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

16. Highlight Calculation

    By bcooney, July 14, 2017   

    • display
    • highlight
    • (and 2 more)

       Tagged with:

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

17. Find prior Wednesday

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

18. Calculating format premiums

    By enquirerfm, July 5, 2017   

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

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

20. Strip the last five characters from a field name

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

21. Print last rows of the portal

    By emtau, July 4, 2017
    • 8 replies
    • 1k views
    • 
    • emtau
    • July 5, 2017

22. Filled-In Fields From Related Records

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

23. Summarize 2 data points for time display?

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

24. First and last date date of Week number

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

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

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

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

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

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

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

28. Logic for multiple values used in a sentence

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

29. Calculating overtime?

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

30. Summarize 3 time fields?

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

31. filemaker iterate (Loop) parsing text

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

32. Random number from value list?

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

33. I assume this is simple...

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

34. Checkbox Set/Filtering a list view

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

35. Extracting Multiple Text from One Field

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