Calculation Engine (Define Fields)

12,870 topics in this forum

1. Execute SQL looking for Empty and not Empty

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

2. Case with Date Calculations

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

3. Simple Median Calculation

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

4. Calculated repetition can't see related records

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

5. Aggregating fields across multiple related records.

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

6. Changed Number field to Calculation and lost all data

   By Guy_Smith, April 28, 2020   

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

7. Date Projection

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

8. Auto Field Calculation Help Please

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

9. Help Find in progress sometimes popping up

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

10. Auto Enter Calculation with a IF statement

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

11. 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.3k views
    • 
    • Guy_Smith
    • April 5, 2020

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

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

13. Summary Report - Determine Percentage

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

14. Text transformed with TextStyleAdd issue

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

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

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

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

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

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

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

18. Extract text from phrase with varying lengths

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

19. help IsValid function

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

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

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

21. How to find out year of transition

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

22. Table relationship confirmation

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

23. Match multiple word to a translated table

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

24. Let If to combine multiple PubMed fields

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

25. FilterValues by partial match

    By mikeytt, January 28, 2020   

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

26. Get last character on a field

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

27. Conditional Count?

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

28. Manipulating values inside a List?

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

29. Find to the nearest sum

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

30. Container Field non-Indexing Workaround

    By JH Howland, December 28, 2019   

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

31. 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.3k views
    • 
    • comment
    • December 24, 2019

32. summary field count the same record as one

    By archrid404, December 10, 2019
    • 3 replies
    • 589 views
    • 
    • archrid404
    • December 16, 2019

33. hide object based on date

    By Giannis, December 11, 2019
    • 1 reply
    • 520 views
    • 
    • Fitch
    • December 12, 2019

34. Calculate Interest Rate - Loan Calculator

    By Darren S, November 29, 2019
    • 9 replies
    • 1.1k views
    • 
    • Darren S
    • December 7, 2019

35. Case with Dates

    By Dominic Joannou, November 28, 2019
    • 5 replies
    • 1k views
    • 
    • comment
    • December 4, 2019