Calculation Engine (Define Fields)

12,875 topics in this forum

1. How a repeating fields get a value from nonrepeating field

   By Omer Faruk EMRE, June 28, 2015
   • 8 replies
   • 839 views
   • 
   • Omer Faruk EMRE
   • July 3, 2015

2. Summing totals with GetNthRecord

   By laguna92651, July 1, 2015
   • 16 replies
   • 1.4k views
   • 
   • laguna92651
   • July 2, 2015

3. Counting Records of a Certain Type?

   By emballantine, June 30, 2015
   • 14 replies
   • 1.2k views
   • 
   • emballantine
   • July 2, 2015

4. Digital Music Inventory System Question

   By mmcconnell, June 30, 2015   

   • inventory
   • 0 replies
   • 1.1k views
   • 
   • mmcconnell
   • June 30, 2015

5. Converting Excel Calculation to Filemaker - Stuck

   By vuego100, June 5, 2015
   • 2 replies
   • 688 views
   • 
   • vuego100
   • June 30, 2015

6. Calculate Number of Days in a Season from a Date Rage

   By Bobby Bradley, June 20, 2015   

   • date range
   • calculate
   • (and 1 more)

      Tagged with:

     • date range
     • calculate
     • days
   • 6 replies
   • 1.2k views
   • 
   • comment
   • June 21, 2015

7. Tally unique records

   By Greg Hains, June 18, 2015
   • 8 replies
   • 901 views
   • 
   • LaRetta
   • June 19, 2015

8. Creating Numerous Calculations Between Child Records

   By GisMo, June 16, 2015
   • 3 replies
   • 605 views
   • 
   • comment
   • June 16, 2015

9. Filemaker won't Calculate Fields unless drop down used

   By yilbber, June 10, 2015
   • 7 replies
   • 2.1k views
   • 
   • yilbber
   • June 15, 2015

10. Calculation to flag first record from a unique set

    By Stu412, June 15, 2015   

    • group
    • flag
    • 4 replies
    • 847 views
    • 
    • hbrendel
    • June 15, 2015

11. Comparison Operator Issue

    By Brad Knewstubb, June 15, 2015
    • 2 replies
    • 905 views
    • 
    • Brad Knewstubb
    • June 15, 2015

12. mac Charting new record count by month

    By obiejuankenobi, May 30, 2014
    • 6 replies
    • 170.9k views
    • 
    • nesor
    • June 13, 2015

13. Field does not show zero despite option unchecked in inspector

    By MSPJ, June 11, 2015   

    • fields
    • formatting
    • 2 replies
    • 1.2k views
    • 
    • MSPJ
    • June 11, 2015

14. Calculation field based on omitted record

    By Stu412, June 11, 2015   

    • found set
    • calculation
    • (and 1 more)

       Tagged with:

      • found set
      • calculation
      • omit
    • 2 replies
    • 1.1k views
    • 
    • Stu412
    • June 11, 2015

15. Determine Page Number of Previous Record using GetNthRecord

    By jayivan, June 10, 2015   

    • getnthrecord
    • layout logic
    • 6 replies
    • 1.6k views
    • 
    • jayivan
    • June 10, 2015

16. Formatting of zero result summary

    By Stu412, June 10, 2015   

    • summary
    • format
    • 3 replies
    • 820 views
    • 
    • eos
    • June 10, 2015

17. Force Dropped File to Show Icon

    By Chuck, June 8, 2015   

    • container-fields
    • 0 replies
    • 614 views
    • 
    • Chuck
    • June 8, 2015

18. What tab is active?

    By philfeldman, November 11, 2006
    • 6 replies
    • 3.3k views
    • 
    • fyanesv
    • June 7, 2015

19. What returns the inverse of the 'Log' function?

    By HALBURN, June 6, 2015
    • 3 replies
    • 791 views
    • 
    • HALBURN
    • June 6, 2015

20. Double booking based on date and time

    By sirmatter, April 20, 2015   

    • room assignment
    • 15 replies
    • 1.5k views
    • 
    • sirmatter
    • June 4, 2015

21. How do I code a thousands separator in a calc?

    By Rich S, June 28, 2010
    • 5 replies
    • 5.2k views
    • 
    • Lee Smith
    • June 3, 2015

22. counting the unique records

    By Aussie John, May 22, 2015
    • 4 replies
    • 701 views
    • 
    • Aussie John
    • June 2, 2015

23. Create fields using related records from another table?

    By wedgeman, June 2, 2015
    • 1 reply
    • 689 views
    • 
    • comment
    • June 2, 2015

24. Format in a FileMaker File

    By Ralph Schwegler, June 1, 2015   

    • date format
    • month day year
    • (and 2 more)

       Tagged with:

      • date format
      • month day year
      • mac | pc
      • startingpoint
    • 2 replies
    • 1.6k views
    • 
    • Ralph Schwegler
    • June 1, 2015

25. making one group out of similar values

    By Aussie John, June 1, 2015
    • 2 replies
    • 584 views
    • 
    • comment
    • June 1, 2015

26. Get ( ActiveModifierKey ) is intermittent

    By James Gill, June 15, 2011
    • 12 replies
    • 3.6k views
    • 
    • DanShockley
    • May 28, 2015

27. Calculate Day count given different duration dates

    By Miss A!, May 27, 2015   

    • dates
    • calculation counter
    • 4 replies
    • 969 views
    • 
    • Miss A!
    • May 28, 2015

28. Filtering a Schedule List by Period Number

    By luiscovar, May 26, 2015
    • 7 replies
    • 1.2k views
    • 
    • Fitch
    • May 27, 2015

29. How can I convert this timestamp into a FMP timestamp?

    By HALBURN, May 21, 2015
    • 8 replies
    • 3k views
    • 
    • comment
    • May 22, 2015

30. GetNthRecord

    By fmpfan, May 21, 2015
    • 7 replies
    • 1.4k views
    • 
    • comment
    • May 21, 2015

31. Portal Row sequencing?

    By Matthew R White, May 19, 2015
    • 4 replies
    • 752 views
    • 
    • Jeff M
    • May 20, 2015

32. Display Data from Second Related Record

    By datalink, March 16, 2015
    • 7 replies
    • 1.6k views
    • 
    • Jeff M
    • May 20, 2015

33. Help Me Understand this...

    By James Gill, May 19, 2015
    • 2 replies
    • 506 views
    • 
    • Josh Ormond
    • May 20, 2015

34. Simple calculation field does not work

    By John Chamberlain, May 19, 2015
    • 4 replies
    • 850 views
    • 
    • comment
    • May 19, 2015

35. Frequency and clusters of true or false

    By Phylum, May 16, 2015   

    • frequency
    • clusters boolean
    • 6 replies
    • 806 views
    • 
    • Phylum
    • May 17, 2015