Calculation Engine (Define Fields)

12,879 topics in this forum

1. Count list of values from Summary list field

   By Sinky, March 24, 2021
   • 11 replies
   • 2.2k views
   • 
   • comment
   • August 1, 2023

2. Field validation by calculation issue, possible bug or just an oversight?

   By logicgator, June 28, 2023
   • 5 replies
   • 1k views
   • 
   • comment
   • June 29, 2023

3. Test for "sequentiality" of related dates

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

4. Display value from second portal row

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

5. Running total problem

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

6. Re-importing images into a container field

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

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

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

8. Date from next record calculation.

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

9. parsing text field

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

10. Clean a lookup field populated

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

11. Converting Excel formula to FM Calculation

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

12. Sum hours worked from related table with matching value

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

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

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

14. Trying to create a simple WHILE calc

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

15. SQL - Calculating income per quarter

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

16. Summary in a calculation

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

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

18. ExecuteSQL Issues

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

19. apples, bananas, oranges and basket

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

20. Conditional Calculation based on fields from another table

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

21. How to replace an unstored calculation via script?

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

22. Last function

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

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

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

24. Get the nearest price

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

25. Estimation Tool Ideas

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

26. barcode configurator

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

27. Address Concatenate w/ Punctuation

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

28. TextStyleAdd and global fields

    By Rich S, August 24, 2022
    • 3 replies
    • 1k views
    • 
    • Rich S
    • August 24, 2022

29. Remove extraneous characters from beginning of field

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

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

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

31. Counting days in between multiple dates

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

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

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

33. Converting Excel formula to FM

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

34. accessing a series of parameters/rates

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

35. Hide Object When not working with global variable

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