Calculation Engine (Define Fields)

12,875 topics in this forum

1. Running total problem

   By Tpaairman, April 4, 2023
   • 22 replies
   • 1.7k views
   • 
   • comment
   • April 6, 2023

2. Re-importing images into a container field

   By VirtualBob, March 31, 2023
   • 6 replies
   • 841 views
   • 
   • VirtualBob
   • March 31, 2023

3. tax calculation error in "billing" starter solution that came with Filemaker 13 advanced

   By curious99, March 30, 2023
   • 2 replies
   • 638 views
   • 
   • curious99
   • March 30, 2023

4. Date from next record calculation.

   By Tpaairman, March 23, 2023
   • 6 replies
   • 741 views
   • 
   • Tpaairman
   • March 28, 2023

5. parsing text field

   By Joseph Farr, February 27, 2023
   • 4 replies
   • 919 views
   • 
   • Joseph Farr
   • February 27, 2023

6. Clean a lookup field populated

   By Enigma20xx, February 24, 2023   

   • lookup
   • 4 replies
   • 1.1k views
   • 
   • Enigma20xx
   • February 27, 2023

7. Converting Excel formula to FM Calculation

   By madman411, February 9, 2023
   • 5 replies
   • 1.2k views
   • 
   • comment
   • February 9, 2023

8. Sum hours worked from related table with matching value

   By madman411, February 1, 2023
   • 1 reply
   • 542 views
   • 
   • comment
   • February 1, 2023

9. Why can't I use a non-numeric value in this value list?

   By Rich S, January 26, 2023
   • 2 replies
   • 804 views
   • 
   • comment
   • January 26, 2023

10. Trying to create a simple WHILE calc

    By Rich S, January 24, 2023
    • 1 reply
    • 713 views
    • 
    • comment
    • January 24, 2023

11. SQL - Calculating income per quarter

    By madman411, January 24, 2023
    • 1 reply
    • 1.2k views
    • 
    • comment
    • January 24, 2023

12. Summary in a calculation

    By CKonash, January 19, 2023
    • 3 replies
    • 1.3k views
    • 
    • bcooney
    • January 22, 2023

13. Trying to show related records on a single bar

    By Steve Martino, January 10, 2023
    • 4 replies
    • 1.1k views
    • 
    • Steve Martino
    • January 10, 2023

14. ExecuteSQL Issues

    By CKonash, December 23, 2022
    • 2 replies
    • 1k views
    • 
    • comment
    • December 23, 2022

15. apples, bananas, oranges and basket

    By Amedeo, December 16, 2022
    • 2 replies
    • 783 views
    • 
    • Amedeo
    • December 16, 2022

16. Conditional Calculation based on fields from another table

    By n7mafia, December 7, 2022
    • 3 replies
    • 1.1k views
    • 
    • comment
    • December 7, 2022

17. How to replace an unstored calculation via script?

    By RavingLuhn, November 17, 2022
    • 1 reply
    • 782 views
    • 
    • bcooney
    • November 19, 2022

18. Last function

    By Chrism, November 2, 2022
    • 11 replies
    • 1.2k views
    • 
    • Chrism
    • November 2, 2022

19. Getting value on the selected checkbox on a single field

    By archrid404, October 21, 2022
    • 1 reply
    • 520 views
    • 
    • comment
    • October 21, 2022

20. Get the nearest price

    By archrid404, October 19, 2022
    • 4 replies
    • 749 views
    • 
    • comment
    • October 21, 2022

21. Estimation Tool Ideas

    By Dr. Evil, September 26, 2022
    • 7 replies
    • 1.4k views
    • 
    • comment
    • September 27, 2022

22. barcode configurator

    By Christy, September 22, 2022
    • 0 replies
    • 828 views
    • 
    • Christy
    • September 22, 2022

23. Address Concatenate w/ Punctuation

    By Dr. Evil, September 21, 2022
    • 4 replies
    • 684 views
    • 
    • Dr. Evil
    • September 22, 2022

24. TextStyleAdd and global fields

    By Rich S, August 24, 2022
    • 3 replies
    • 977 views
    • 
    • Rich S
    • August 24, 2022

25. Remove extraneous characters from beginning of field

    By -dp-, August 11, 2022
    • 2 replies
    • 867 views
    • 
    • -dp-
    • August 11, 2022

26. Click Container Field to insert file script...

    By emtau, August 9, 2022
    • 2 replies
    • 797 views
    • 
    • emtau
    • August 9, 2022

27. Counting days in between multiple dates

    By emtau, July 28, 2022
    • 6 replies
    • 1.1k views
    • 
    • comment
    • August 1, 2022

28. Conditional result based on if Fields are empty, partially, or not empty.

    By emtau, July 20, 2022
    • 2 replies
    • 639 views
    • 
    • emtau
    • July 28, 2022

29. Converting Excel formula to FM

    By Steve Martino, July 19, 2022
    • 9 replies
    • 1.7k views
    • 
    • Steve Martino
    • July 20, 2022

30. accessing a series of parameters/rates

    By Aussie John, July 18, 2022
    • 1 reply
    • 684 views
    • 
    • comment
    • July 18, 2022

31. Hide Object When not working with global variable

    By Rich S, July 7, 2022
    • 5 replies
    • 1.1k views
    • 
    • bcooney
    • July 9, 2022

32. Using links from Cogsci's Hook app

    By -dp-, June 6, 2022
    • 3 replies
    • 589 views
    • 
    • comment
    • June 6, 2022

33. Detect connected Device

    By archrid404, June 2, 2022
    • 0 replies
    • 431 views
    • 
    • archrid404
    • June 2, 2022

34. Help on extract data from an address field into separate fields

    By DrWill, April 29, 2022
    • 1 reply
    • 637 views
    • 
    • comment
    • April 29, 2022

35. Make a dumb function smart and elegant!

    By innodat, April 13, 2022
    • 8 replies
    • 721 views
    • 
    • innodat
    • April 14, 2022