Calculation Engine (Define Fields)

12,871 topics in this forum

1. LocationValues Function, How to sepearete the values

   By MaLuc, August 28, 2017   

   • gps latitude longitude
   • 2 replies
   • 666 views
   • 
   • MaLuc
   • August 28, 2017

2. Find & Return Words in Field

   By hutchlad, August 25, 2017   

   • find
   • function
   • (and 2 more)

      Tagged with:

     • find
     • function
     • field
     • help
   • 5 replies
   • 1.1k views
   • 
   • comment
   • August 25, 2017

3. date ca First Monday Calculation

   By John Chamberlain, August 22, 2017   

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

4. Rank function

   By Trpan_z, August 17, 2017   

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

5. 3 values selection relationships and tables

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

6. Calculate Phone costs nightmare

   By dkey, August 17, 2017   

   • minutes
   • seconds
   • (and 1 more)

      Tagged with:

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

7. Saturday date (numeric) based on month input

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

8. Ignoring & and and - in names

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

9. Balance/Quantity Returned

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

10. JSONPath with FM JSON functions

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

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

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

12. 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.8k views
    • 
    • Lee Smith
    • August 3, 2017

13. Countdown timers

    By Wayne Irvine, July 28, 2017   

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

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

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

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

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

    By docasar, July 19, 2017   

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

17. Deriving a value from another record

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

18. Highlight Calculation

    By bcooney, July 14, 2017   

    • display
    • highlight
    • (and 2 more)

       Tagged with:

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

19. Find prior Wednesday

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

20. Calculating format premiums

    By enquirerfm, July 5, 2017   

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

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

22. Strip the last five characters from a field name

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

23. Print last rows of the portal

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

24. Filled-In Fields From Related Records

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

25. Summarize 2 data points for time display?

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

26. First and last date date of Week number

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

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

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

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

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

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

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

30. Logic for multiple values used in a sentence

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

31. Calculating overtime?

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

32. Summarize 3 time fields?

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

33. filemaker iterate (Loop) parsing text

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

34. Random number from value list?

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

35. I assume this is simple...

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