Calculation Engine (Define Fields)

12,867 topics in this forum

1. Calculated repetition can't see related records

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

2. Aggregating fields across multiple related records.

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

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

4. Date Projection

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

5. Auto Field Calculation Help Please

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

6. Help Find in progress sometimes popping up

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

7. Auto Enter Calculation with a IF statement

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

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

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

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

10. Summary Report - Determine Percentage

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

11. Text transformed with TextStyleAdd issue

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

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

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

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

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

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

15. Extract text from phrase with varying lengths

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

16. help IsValid function

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

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

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

18. How to find out year of transition

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

19. Table relationship confirmation

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

20. Match multiple word to a translated table

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

21. Let If to combine multiple PubMed fields

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

22. FilterValues by partial match

    By mikeytt, January 28, 2020   

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

23. Get last character on a field

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

24. Conditional Count?

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

25. Manipulating values inside a List?

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

26. Find to the nearest sum

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

27. Container Field non-Indexing Workaround

    By JH Howland, December 28, 2019   

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

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

29. summary field count the same record as one

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

30. hide object based on date

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

31. Calculate Interest Rate - Loan Calculator

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

32. Case with Dates

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

33. Please help with multiple condition calculation that i want to put into single field.

    By Mark Pastoril, November 28, 2019
    • 3 replies
    • 551 views
    • 
    • Mark Pastoril
    • December 2, 2019

34. Two-dimensional logic test in a calculation?

    By DataCruncher, November 29, 2019
    • 5 replies
    • 655 views
    • 
    • comment
    • November 30, 2019

35. Using the name of a field in that field's calculation

    By metamict, November 27, 2019
    • 2 replies
    • 610 views
    • 
    • bcooney
    • November 27, 2019