Calculation Engine (Define Fields)

12,872 topics in this forum

1. Text from a field as validation calculation

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

2. Text Parsing (IP Address)

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

3. Is this a bug?

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

4. Calc step for "includes this text"?

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

5. Struggling with simple calc

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

6. Letter from field

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

7. Case statements

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

8. Creating a Data Dictionary in FMP9

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

9. Creating Percentages

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

10. Substitute % + number

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

11. Another "Sum of related fields" question

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

12. UniqueValue_Sum - Inconsistent inaccurate counts

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

13. Limit New Records on a Layout

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

14. Change Excel Formula to Filemaker Calculation

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

15. User text used AS the Calculation

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

16. Dates to chart box number

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

17. Replace calculation in text block

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

18. Global Field Work-Around

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

19. SumIF

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

20. Automatically Update Summary and Calculation Fields

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

21. midpoint of date and time

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

22. Sum from related TO

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

23. Calculation to auto-fill date based on checkbox

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

24. Simple True/False Checkbox

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

25. Locating most current date in Found Set

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

26. Calculations & Summarizing Data

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

27. time interval calculation

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

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

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

29. Text spacing

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

30. Auto input based on several fields

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

31. nth day of the month

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

32. Substitute text (or replace)

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

33. 'Extract' comma delimited list

    By ron G, March 16, 2011
    • 1 reply
    • 747 views
    • 
    • bcooney
    • March 17, 2011

34. if or case statement

    By tbcomputerguy, March 16, 2011
    • 15 replies
    • 3.1k views
    • 
    • tbcomputerguy
    • March 16, 2011

35. Select Child Record

    By AnthonyDixon, March 16, 2011
    • 5 replies
    • 1.4k views
    • 
    • Lee Smith
    • March 16, 2011