Calculation Engine (Define Fields)

12,875 topics in this forum

1. Calc for performance status, 4 levels with 3 criteria

   By b.hunt, May 22, 2020
   • 0 replies
   • 2.2k views
   • 
   • b.hunt
   • May 22, 2020

2. Find latest occurrence

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

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

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

4. Case Confusion

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

5. Mapping Repetitions to New Field

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

6. Execute SQL looking for Empty and not Empty

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

7. Case with Date Calculations

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

8. Simple Median Calculation

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

9. Calculated repetition can't see related records

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

10. Aggregating fields across multiple related records.

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

11. Changed Number field to Calculation and lost all data

    By Guy_Smith, April 28, 2020   

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

12. Date Projection

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

13. Auto Field Calculation Help Please

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

14. Help Find in progress sometimes popping up

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

15. Auto Enter Calculation with a IF statement

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

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

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

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

18. Summary Report - Determine Percentage

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

19. Text transformed with TextStyleAdd issue

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

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

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

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

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

23. Extract text from phrase with varying lengths

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

24. help IsValid function

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

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

26. How to find out year of transition

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

27. Table relationship confirmation

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

28. Match multiple word to a translated table

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

29. Let If to combine multiple PubMed fields

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

30. FilterValues by partial match

    By mikeytt, January 28, 2020   

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

31. Get last character on a field

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

32. Conditional Count?

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

33. Manipulating values inside a List?

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

34. Find to the nearest sum

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

35. Container Field non-Indexing Workaround

    By JH Howland, December 28, 2019   

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