Calculation Engine (Define Fields)

12,872 topics in this forum

1. Digital Music Inventory System Question

   By mmcconnell, June 30, 2015   

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

2. Converting Excel Calculation to Filemaker - Stuck

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

3. 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.1k views
   • 
   • comment
   • June 21, 2015

4. Tally unique records

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

5. Creating Numerous Calculations Between Child Records

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

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

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

7. Calculation to flag first record from a unique set

   By Stu412, June 15, 2015   

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

8. Comparison Operator Issue

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

9. mac Charting new record count by month

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

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

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

12. Determine Page Number of Previous Record using GetNthRecord

    By jayivan, June 10, 2015   

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

13. Formatting of zero result summary

    By Stu412, June 10, 2015   

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

14. Force Dropped File to Show Icon

    By Chuck, June 8, 2015   

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

15. What tab is active?

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

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

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

17. Double booking based on date and time

    By sirmatter, April 20, 2015   

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

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

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

19. counting the unique records

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

20. Create fields using related records from another table?

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

21. 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.5k views
    • 
    • Ralph Schwegler
    • June 1, 2015

22. making one group out of similar values

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

23. Get ( ActiveModifierKey ) is intermittent

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

24. Calculate Day count given different duration dates

    By Miss A!, May 27, 2015   

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

25. Filtering a Schedule List by Period Number

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

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

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

27. GetNthRecord

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

28. Portal Row sequencing?

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

29. Display Data from Second Related Record

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

30. Help Me Understand this...

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

31. Simple calculation field does not work

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

32. Frequency and clusters of true or false

    By Phylum, May 16, 2015   

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

33. Copy contents from 1 field to another

    By gfr92y, May 13, 2015
    • 5 replies
    • 857 views
    • 
    • gfr92y
    • May 17, 2015

34. Does anyone know how you store data in a Calculation field's "Repetitions"?

    By RoundtableSam, May 16, 2015
    • 16 replies
    • 1.2k views
    • 
    • RoundtableSam
    • May 17, 2015

35. Help... Repeating field calculation only pulling first related record

    By mrmacmusic, May 15, 2015
    • 2 replies
    • 793 views
    • 
    • mrmacmusic
    • May 16, 2015