Calculation Engine (Define Fields)

12,874 topics in this forum

1. Find latest occurrence

   By Randy Bricker, May 5, 2020
   • 4 replies
   • 2.4k views
   • 
   • comment
   • May 22, 2020

2. How to sum records in child table that meet criteria?

   By RavingLuhn, May 15, 2020
   • 6 replies
   • 2.5k views
   • 
   • RavingLuhn
   • May 18, 2020

3. Case Confusion

   By Paul Hunt, May 16, 2020
   • 3 replies
   • 2.4k views
   • 
   • Paul Hunt
   • May 16, 2020

4. Mapping Repetitions to New Field

   By Paul Hunt, May 13, 2020
   • 4 replies
   • 2.3k views
   • 
   • Paul Hunt
   • May 13, 2020

5. Execute SQL looking for Empty and not Empty

   By archrid404, May 12, 2020
   • 1 reply
   • 2.3k views
   • 
   • comment
   • May 12, 2020

6. Case with Date Calculations

   By Dancie, May 7, 2020
   • 4 replies
   • 2.5k views
   • 
   • Dancie
   • May 8, 2020

7. Simple Median Calculation

   By CatLady001, May 6, 2020
   • 7 replies
   • 3.3k views
   • 
   • comment
   • May 8, 2020

8. Calculated repetition can't see related records

   By sal88, May 4, 2020
   • 2 replies
   • 2.1k views
   • 
   • sal88
   • May 4, 2020

9. Aggregating fields across multiple related records.

   By CKonash, May 3, 2020
   • 3 replies
   • 2.3k views
   • 
   • comment
   • May 3, 2020

10. Changed Number field to Calculation and lost all data

    By Guy_Smith, April 28, 2020   

    • calculation field
    • data loss
    • 2 replies
    • 2.2k views
    • 
    • Guy_Smith
    • April 29, 2020

11. Date Projection

    By Modius, April 27, 2020
    • 2 replies
    • 2.3k views
    • 
    • comment
    • April 27, 2020

12. Auto Field Calculation Help Please

    By extreme, April 26, 2020
    • 8 replies
    • 2k views
    • 
    • comment
    • April 26, 2020

13. Help Find in progress sometimes popping up

    By archrid404, April 16, 2020
    • 3 replies
    • 2.3k views
    • 
    • Fitch
    • April 17, 2020

14. Auto Enter Calculation with a IF statement

    By maxbehr, April 13, 2020
    • 1 reply
    • 1.9k views
    • 
    • comment
    • April 14, 2020

15. How to generate different Portal line numbers for different parent record

    By Guy_Smith, April 4, 2020   

    • portal
    • calculation
    • (and 1 more)

       Tagged with:

      • portal
      • calculation
      • relationshis
    • 4 replies
    • 2.4k views
    • 
    • Guy_Smith
    • April 5, 2020

16. How big can a Filemaker system be (tables, relationships, fields)?

    By DDDan, March 18, 2020
    • 3 replies
    • 1.9k views
    • 
    • DDDan
    • March 18, 2020

17. Summary Report - Determine Percentage

    By Rich S, March 17, 2020
    • 4 replies
    • 1.8k views
    • 
    • Rich S
    • March 17, 2020

18. Text transformed with TextStyleAdd issue

    By Matt Klein, March 9, 2020
    • 2 replies
    • 1.6k views
    • 
    • Matt Klein
    • March 9, 2020

19. Combinations of numbers vs a total - how to calculate?

    By Angus McKinnon, March 6, 2020
    • 2 replies
    • 1.4k views
    • 
    • Angus McKinnon
    • March 6, 2020

20. Global storage fields not keeping their data and driving me crazy...

    By fmow, April 24, 2014
    • 11 replies
    • 4.5k views
    • 
    • L-Arnold
    • March 5, 2020

21. A running total, but not with a summary field?

    By TysonB, February 17, 2020
    • 10 replies
    • 1.6k views
    • 
    • comment
    • February 17, 2020

22. Extract text from phrase with varying lengths

    By Rich S, February 11, 2020
    • 3 replies
    • 1.4k views
    • 
    • comment
    • February 11, 2020

23. help IsValid function

    By archrid404, February 10, 2020
    • 1 reply
    • 1.4k views
    • 
    • Wim Decorte
    • February 10, 2020

24. Best way to handle Universal (static) data for opening URL - admin panel?

    By Tony Martin, January 30, 2020
    • 5 replies
    • 1.1k views
    • 
    • Tony Martin
    • February 7, 2020

25. How to find out year of transition

    By JulesB, February 6, 2020
    • 2 replies
    • 642 views
    • 
    • JulesB
    • February 6, 2020

26. Table relationship confirmation

    By emtau, February 4, 2020
    • 7 replies
    • 840 views
    • 
    • comment
    • February 6, 2020

27. Match multiple word to a translated table

    By ibobo, February 2, 2020
    • 0 replies
    • 636 views
    • 
    • ibobo
    • February 2, 2020

28. Let If to combine multiple PubMed fields

    By Quito, January 27, 2020
    • 4 replies
    • 774 views
    • 
    • Quito
    • January 30, 2020

29. FilterValues by partial match

    By mikeytt, January 28, 2020   

    • Solved
    • 2 replies
    • 601 views
    • 
    • mikeytt
    • January 28, 2020

30. Get last character on a field

    By archrid404, January 27, 2020
    • 1 reply
    • 853 views
    • 
    • comment
    • January 27, 2020

31. Conditional Count?

    By millmaine, January 21, 2020
    • 5 replies
    • 1.1k views
    • 
    • comment
    • January 23, 2020

32. Manipulating values inside a List?

    By R2D2, January 1, 2020
    • 6 replies
    • 771 views
    • 
    • comment
    • January 3, 2020

33. Find to the nearest sum

    By archrid404, November 25, 2019
    • 17 replies
    • 2.5k views
    • 
    • comment
    • January 3, 2020

34. Container Field non-Indexing Workaround

    By JH Howland, December 28, 2019   

    • containers
    • 7 replies
    • 1.6k views
    • 
    • JH Howland
    • December 29, 2019

35. Highest of related records from 3 tables

    By Stickybeak, December 22, 2019   

    • related
    • child tables
    • (and 1 more)

       Tagged with:

      • related
      • child tables
      • parent-child
    • 4 replies
    • 1.5k views
    • 
    • comment
    • December 24, 2019