Calculation Engine (Define Fields)

12,872 topics in this forum

1. Conditional Auto-increment via Calculation?

   By vwgtiturbo, August 29, 2017
   • 1 reply
   • 1.1k views
   • 
   • vwgtiturbo
   • August 31, 2017

2. LocationValues Function, How to sepearete the values

   By MaLuc, August 28, 2017   

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

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

4. date ca First Monday Calculation

   By John Chamberlain, August 22, 2017   

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

5. Rank function

   By Trpan_z, August 17, 2017   

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

6. 3 values selection relationships and tables

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

7. Calculate Phone costs nightmare

   By dkey, August 17, 2017   

   • minutes
   • seconds
   • (and 1 more)

      Tagged with:

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

8. Saturday date (numeric) based on month input

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

9. Ignoring & and and - in names

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

10. Balance/Quantity Returned

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

11. JSONPath with FM JSON functions

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

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

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

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

14. Countdown timers

    By Wayne Irvine, July 28, 2017   

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

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

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

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

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

    By docasar, July 19, 2017   

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

18. Deriving a value from another record

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

19. Highlight Calculation

    By bcooney, July 14, 2017   

    • display
    • highlight
    • (and 2 more)

       Tagged with:

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

20. Find prior Wednesday

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

21. Calculating format premiums

    By enquirerfm, July 5, 2017   

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

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

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

23. Strip the last five characters from a field name

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

24. Print last rows of the portal

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

25. Filled-In Fields From Related Records

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

26. Summarize 2 data points for time display?

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

27. First and last date date of Week number

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

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

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

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

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

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

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

31. Logic for multiple values used in a sentence

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

32. Calculating overtime?

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

33. Summarize 3 time fields?

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

34. filemaker iterate (Loop) parsing text

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

35. Random number from value list?

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