Calculation Engine (Define Fields)

12,875 topics in this forum

1. Date Calculation

   By Alanj, April 12, 2011
   • 4 replies
   • 791 views
   • 
   • Alanj
   • April 12, 2011

2. Auto entera field based on Date+1 calculation?

   By dbfreak, April 11, 2011
   • 1 reply
   • 660 views
   • 
   • comment
   • April 12, 2011

3. Get(LayoutName) calculation in case statement

   By Mike CPB, April 8, 2011
   • 2 replies
   • 979 views
   • 
   • Mike CPB
   • April 8, 2011

4. Text from a field as validation calculation

   By Woodnote, April 7, 2011
   • 5 replies
   • 1.2k views
   • 
   • Woodnote
   • April 8, 2011

5. Text Parsing (IP Address)

   By tomg3, March 25, 2010
   • 8 replies
   • 3.4k views
   • 
   • comment
   • April 7, 2011

6. Is this a bug?

   By TrulySimple, April 5, 2011
   • 26 replies
   • 2.8k views
   • 
   • TrulySimple
   • April 7, 2011

7. Calc step for "includes this text"?

   By Ian Murphy, April 6, 2011
   • 2 replies
   • 652 views
   • 
   • Ian Murphy
   • April 6, 2011

8. Struggling with simple calc

   By James Gill, April 6, 2011
   • 3 replies
   • 652 views
   • 
   • comment
   • April 6, 2011

9. Letter from field

   By Pavel Smirnov, April 2, 2011
   • 5 replies
   • 1.4k views
   • 
   • Vaughan
   • April 6, 2011

10. Case statements

    By tokkajy, April 5, 2011
    • 3 replies
    • 1.2k views
    • 
    • Fitch
    • April 5, 2011

11. Creating a Data Dictionary in FMP9

    By david.michaels, April 5, 2011
    • 1 reply
    • 1k views
    • 
    • Fitch
    • April 5, 2011

12. Creating Percentages

    By placebo, April 5, 2011
    • 1 reply
    • 629 views
    • 
    • comment
    • April 5, 2011

13. Substitute % + number

    By FMReader, March 31, 2011
    • 6 replies
    • 1.6k views
    • 
    • FMReader
    • April 2, 2011

14. Another "Sum of related fields" question

    By gseymour, March 29, 2011
    • 9 replies
    • 1.4k views
    • 
    • gseymour
    • April 1, 2011

15. UniqueValue_Sum - Inconsistent inaccurate counts

    By TrulySimple, April 1, 2011
    • 4 replies
    • 1k views
    • 
    • TrulySimple
    • April 1, 2011

16. Limit New Records on a Layout

    By Shipbuilder, March 30, 2011
    • 11 replies
    • 1.6k views
    • 
    • Shipbuilder
    • March 31, 2011

17. Change Excel Formula to Filemaker Calculation

    By zdub, March 30, 2011
    • 1 reply
    • 2.4k views
    • 
    • comment
    • March 31, 2011

18. User text used AS the Calculation

    By mike60640, March 30, 2011
    • 2 replies
    • 615 views
    • 
    • mike60640
    • March 30, 2011

19. Dates to chart box number

    By peptoulcer, March 30, 2011
    • 0 replies
    • 592 views
    • 
    • peptoulcer
    • March 30, 2011

20. Replace calculation in text block

    By Shedboyxx, March 28, 2011
    • 2 replies
    • 622 views
    • 
    • Shedboyxx
    • March 29, 2011

21. Global Field Work-Around

    By JLC, March 29, 2011
    • 2 replies
    • 1.6k views
    • 
    • Josh Ormond
    • March 29, 2011

22. SumIF

    By isateng, March 26, 2011
    • 1 reply
    • 1.2k views
    • 
    • bcooney
    • March 26, 2011

23. Automatically Update Summary and Calculation Fields

    By dtsparky, April 23, 2008
    • 3 replies
    • 1.5k views
    • 
    • R2D2
    • March 26, 2011

24. midpoint of date and time

    By mrmogway, March 26, 2011
    • 6 replies
    • 3.8k views
    • 
    • mrmogway
    • March 26, 2011

25. Sum from related TO

    By Oyseka, March 25, 2011
    • 2 replies
    • 1.3k views
    • 
    • Oyseka
    • March 26, 2011

26. Calculation to auto-fill date based on checkbox

    By mrswombat, March 24, 2011
    • 6 replies
    • 2.3k views
    • 
    • mrswombat
    • March 24, 2011

27. Simple True/False Checkbox

    By chrisknight55, March 24, 2011
    • 2 replies
    • 1k views
    • 
    • chrisknight55
    • March 24, 2011

28. Locating most current date in Found Set

    By Shipbuilder, March 24, 2011
    • 2 replies
    • 915 views
    • 
    • Shipbuilder
    • March 24, 2011

29. Calculations & Summarizing Data

    By Raschelle, March 24, 2011
    • 0 replies
    • 901 views
    • 
    • Raschelle
    • March 24, 2011

30. time interval calculation

    By Cateleb, March 23, 2011
    • 7 replies
    • 1.6k views
    • 
    • Cateleb
    • March 24, 2011

31. Formula that can calculate how many syllables are in a given word?

    By HALBURN, March 22, 2011
    • 1 reply
    • 2.9k views
    • 
    • HALBURN
    • March 23, 2011

32. Text spacing

    By Pavel Smirnov, March 23, 2011
    • 1 reply
    • 1.5k views
    • 
    • Vaughan
    • March 23, 2011

33. Auto input based on several fields

    By Oyseka, March 20, 2011
    • 0 replies
    • 672 views
    • 
    • Oyseka
    • March 20, 2011

34. nth day of the month

    By ron G, March 16, 2011
    • 2 replies
    • 797 views
    • 
    • ron G
    • March 19, 2011

35. Substitute text (or replace)

    By cereal_killer, March 17, 2011
    • 4 replies
    • 1.2k views
    • 
    • cereal_killer
    • March 18, 2011