Calculation Engine (Define Fields)

12,877 topics in this forum

1. Test for "sequentiality" of related dates

   By Rich S, May 30, 2023
   • 3 replies
   • 687 views
   • 
   • comment
   • May 31, 2023

2. Display value from second portal row

   By oa2022, May 30, 2023
   • 9 replies
   • 998 views
   • 
   • comment
   • May 31, 2023

3. Running total problem

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

4. Re-importing images into a container field

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

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

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

6. Date from next record calculation.

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

7. parsing text field

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

8. Clean a lookup field populated

   By Enigma20xx, February 24, 2023
   • 4 replies
   • 1.1k views
   • 
   • Enigma20xx
   • February 27, 2023

9. Converting Excel formula to FM Calculation

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

10. Sum hours worked from related table with matching value

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

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

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

12. Trying to create a simple WHILE calc

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

13. SQL - Calculating income per quarter

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

14. Summary in a calculation

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

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

16. ExecuteSQL Issues

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

17. apples, bananas, oranges and basket

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

18. Conditional Calculation based on fields from another table

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

19. How to replace an unstored calculation via script?

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

20. Last function

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

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

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

22. Get the nearest price

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

23. Estimation Tool Ideas

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

24. barcode configurator

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

25. Address Concatenate w/ Punctuation

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

26. TextStyleAdd and global fields

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

27. Remove extraneous characters from beginning of field

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

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

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

29. Counting days in between multiple dates

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

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

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

31. Converting Excel formula to FM

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

32. accessing a series of parameters/rates

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

33. Hide Object When not working with global variable

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

34. Using links from Cogsci's Hook app

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

35. Detect connected Device

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