Calculation Engine (Define Fields)

12,879 topics in this forum

1. Calculation field that removes certain text from a text field

   By DLM, July 26, 2013
   • 7 replies
   • 782 views
   • 
   • Lee Smith
   • July 29, 2013

2. Formatting phone numbers

   By VirtualBob, July 25, 2013
   • 5 replies
   • 891 views
   • 
   • Rick Whitelaw
   • July 28, 2013

3. The strangest thing with a calculation....

   By DLM, July 1, 2013
   • 12 replies
   • 1.4k views
   • 
   • Fitch
   • July 27, 2013

4. recalculate auto-calculate field with global storage reference

   By Ziphius, July 21, 2013
   • 8 replies
   • 3.1k views
   • 
   • Lee Smith
   • July 25, 2013

5. Calculation with all portal row

   By joaocoutinho, July 24, 2013
   • 3 replies
   • 1.9k views
   • 
   • Matthew F
   • July 24, 2013

6. count instance repeated values

   By madman411, July 20, 2013
   • 3 replies
   • 904 views
   • 
   • madman411
   • July 20, 2013

7. repetitions and serial numbers

   By posternutbag, July 19, 2013
   • 2 replies
   • 3.1k views
   • 
   • LaRetta
   • July 19, 2013

8. Calculation Help

   By "... you mean these fans?", July 9, 2013
   • 4 replies
   • 1k views
   • 
   • jbante
   • July 9, 2013

9. Find <

   By beckham, July 7, 2013
   • 4 replies
   • 3.1k views
   • 
   • beckham
   • July 9, 2013

10. New to filemaker and coming from access. Need help with formula...

    By danlee2672, July 5, 2013
    • 1 reply
    • 763 views
    • 
    • LaRetta
    • July 5, 2013

11. ExecuteSQL syntax question

    By doughemi, July 2, 2013
    • 4 replies
    • 867 views
    • 
    • doughemi
    • July 3, 2013

12. Create a summary field on fields of an external table

    By Filip Langenbick, June 28, 2013
    • 3 replies
    • 1.2k views
    • 
    • Rick Whitelaw
    • July 2, 2013

13. Make repetition a list?

    By David Nelson, June 16, 2013
    • 3 replies
    • 961 views
    • 
    • David Nelson
    • July 1, 2013

14. Container Field File Path

    By adyf, July 1, 2013
    • 5 replies
    • 833 views
    • 
    • adyf
    • July 1, 2013

15. Calculation Idea / Help

    By "... you mean these fans?", June 27, 2013
    • 2 replies
    • 705 views
    • 
    • "... you mean these fans?"
    • June 28, 2013

16. Summary field works different once linked

    By Filip Langenbick, June 27, 2013
    • 3 replies
    • 951 views
    • 
    • Filip Langenbick
    • June 27, 2013

17. Rounding Up

    By Herbs, June 26, 2013
    • 5 replies
    • 876 views
    • 
    • Lee Smith
    • June 26, 2013

18. Hourly rate

    By ttmail, June 26, 2013
    • 2 replies
    • 772 views
    • 
    • ttmail
    • June 26, 2013

19. calculation Help

    By Matrixxdg, June 26, 2013
    • 2 replies
    • 777 views
    • 
    • Matrixxdg
    • June 26, 2013

20. Individual Pieces of Calc work until Combined in Script for Script Trigger

    By Dana G, June 25, 2013
    • 3 replies
    • 1.9k views
    • 
    • IdealData
    • June 26, 2013

21. How can I count city field ?

    By Mustafa55, June 22, 2013
    • 9 replies
    • 2k views
    • 
    • Mustafa55
    • June 24, 2013

22. Wrong field type - invoicing - used relational vs lookup field

    By skingjack2, June 23, 2013
    • 2 replies
    • 734 views
    • 
    • Matthew F
    • June 23, 2013

23. Script calculation

    By ttmail, June 23, 2013
    • 2 replies
    • 881 views
    • 
    • ttmail
    • June 23, 2013

24. Use return carriage in the position function.

    By Capt JB, June 21, 2013
    • 4 replies
    • 831 views
    • 
    • Capt JB
    • June 22, 2013

25. How to create a summary field to summarize filtered data?

    By nareyramos, June 13, 2013
    • 13 replies
    • 943 views
    • 
    • nareyramos
    • June 19, 2013

26. Get ( RecordOpenState ) = 3!

    By alecgregory, June 19, 2013
    • 2 replies
    • 1.2k views
    • 
    • alecgregory
    • June 19, 2013

27. Get (FileSize) issue

    By davidnickerson, June 18, 2013
    • 1 reply
    • 889 views
    • 
    • Vaughan
    • June 19, 2013

28. Percent from Literal to Readable

    By Dr. Evil, June 18, 2013
    • 5 replies
    • 697 views
    • 
    • Dr. Evil
    • June 19, 2013

29. Serial Number Field based on the current year and a serial no.

    By fmow, June 14, 2013
    • 7 replies
    • 3.2k views
    • 
    • fmow
    • June 18, 2013

30. Calculated AppleScript

    By Agnes Riley, June 12, 2013
    • 10 replies
    • 3.5k views
    • 
    • bruceR
    • June 18, 2013

31. Filtering a List Calculation

    By adyf, June 15, 2013
    • 4 replies
    • 1k views
    • 
    • adyf
    • June 17, 2013

32. Field using List Function

    By roemere, June 12, 2013
    • 6 replies
    • 1.4k views
    • 
    • jbante
    • June 13, 2013

33. Hide Repetitive Record Titles

    By Dr. Evil, June 10, 2013
    • 4 replies
    • 814 views
    • 
    • Dr. Evil
    • June 11, 2013

34. Age calc

    By sharabi, June 3, 2013
    • 9 replies
    • 1.8k views
    • 
    • Fitch
    • June 10, 2013

35. Auto Enter 1 of 3 numbers

    By Matthew R White, June 6, 2013
    • 3 replies
    • 1.7k views
    • 
    • Raybaudi
    • June 7, 2013