Calculation Engine (Define Fields)

12,869 topics in this forum

1. Validation of Field AB123456

   By Tusif Ahmad, March 17, 2016
   • 2 replies
   • 1.4k views
   • 
   • Tusif Ahmad
   • March 17, 2016

2. Refreshing Calculations

   By Silez, March 15, 2016
   • 4 replies
   • 2.3k views
   • 
   • Fitch
   • March 15, 2016

3. Field Validation against a global field

   By Courtney, March 14, 2016
   • 4 replies
   • 1.2k views
   • 
   • comment
   • March 15, 2016

4. Sub Summary showing Individual Records

   By jagstirling, March 12, 2016
   • 2 replies
   • 865 views
   • 
   • jagstirling
   • March 12, 2016

5. Just a little help with a calc's syntax

   By Rich S, March 12, 2016
   • 0 replies
   • 745 views
   • 
   • Rich S
   • March 12, 2016

6. Number format - flummox

   By bdarch, March 11, 2016
   • 0 replies
   • 575 views
   • 
   • bdarch
   • March 11, 2016

7. Inventory

   By Rosalie, March 9, 2016
   • 5 replies
   • 1.1k views
   • 
   • Rosalie
   • March 10, 2016

8. Displaying Fields from one Record in Another Record

   By FileMike, March 8, 2016
   • 6 replies
   • 1.1k views
   • 
   • Lee Smith
   • March 9, 2016

9. Field calculation for text pattern

   By Miss A!, March 9, 2016   

   • pettern
   • calculation
   • (and 1 more)

      Tagged with:

     • pettern
     • calculation
     • text
   • 2 replies
   • 901 views
   • 
   • comment
   • March 9, 2016

10. Custom Field Validation if more that x Char

    By ibobo, March 7, 2016   

    • custom field validation
    • 9 replies
    • 1k views
    • 
    • ibobo
    • March 8, 2016

11. Price Matrix

    By Devin, March 5, 2016
    • 2 replies
    • 882 views
    • 
    • Devin
    • March 5, 2016

12. get current month in button bar calculation

    By Matthew R White, February 29, 2016
    • 3 replies
    • 916 views
    • 
    • comment
    • March 1, 2016

13. Simple Calc-Script Help

    By Philip Curtis, February 25, 2016
    • 4 replies
    • 1k views
    • 
    • Philip Curtis
    • February 25, 2016

14. Field validation when field is from external FMP data source

    By GC GYM, February 24, 2016   

    • external source data validation
    • 3 replies
    • 812 views
    • 
    • GC GYM
    • February 24, 2016

15. DNA custom function/calculation

    By oilcan, May 9, 2007
    • 12 replies
    • 2.1k views
    • 
    • PKF
    • February 23, 2016

16. Reverse FilterValues Result

    By xeb, February 19, 2016
    • 2 replies
    • 1.2k views
    • 
    • comment
    • February 19, 2016

17. Sort table by initial row or most current date

    By Matthew R White, February 9, 2016
    • 4 replies
    • 796 views
    • 
    • Matthew R White
    • February 19, 2016

18. summarizing data in a portal timesheet database

    By John Kostenbader, February 17, 2016   

    • timesheet
    • summarizing hours
    • 6 replies
    • 1.7k views
    • 
    • comment
    • February 18, 2016

19. Can you we used a fusion or other variable substitution in a formula?

    By SHMUEL, February 7, 2016   

    • substitution
    • fusion
    • 4 replies
    • 1.1k views
    • 
    • SHMUEL
    • February 9, 2016

20. Calculating blocks of time

    By madman411, February 8, 2016
    • 5 replies
    • 929 views
    • 
    • comment
    • February 9, 2016

21. Add an "and" to a list

    By rick altman, February 5, 2016   

    • substitute
    • position
    • (and 2 more)

       Tagged with:

      • substitute
      • position
      • script
      • function
    • 1 reply
    • 1.2k views
    • 
    • LaRetta
    • February 5, 2016

22. Filepath based on field entry

    By chadski021, February 2, 2016
    • 3 replies
    • 900 views
    • 
    • Lee Smith
    • February 3, 2016

23. mac How to create page count

    By brobins, March 18, 2014
    • 19 replies
    • 9.3k views
    • 
    • LaRetta
    • February 2, 2016

24. Remove Quotation marks from non alpha characters

    By innodat, January 28, 2016   

    • calculation
    • text
    • (and 1 more)

       Tagged with:

      • calculation
      • text
      • quotation marks
    • 10 replies
    • 1.5k views
    • 
    • innodat
    • January 29, 2016

25. Running total of all sales in first quarter, second etc

    By FMData12, January 29, 2016   

    • sales
    • running
    • (and 2 more)

       Tagged with:

      • sales
      • running
      • total
      • quarter
    • 0 replies
    • 533 views
    • 
    • FMData12
    • January 29, 2016

26. WeekOfYear ISO 8601

    By ralph.nusser, February 26, 2005
    • 9 replies
    • 2k views
    • 
    • Patrick ONeill
    • January 27, 2016

27. Days overdue not taking the year into account

    By D4v3, January 25, 2016   

    • due date
    • 12 replies
    • 1.3k views
    • 
    • Lee Smith
    • January 26, 2016

28. Modifiable Repeating Field Entries?

    By steveald, January 21, 2016   

    • global fields
    • repeating fields
    • (and 1 more)

       Tagged with:

      • global fields
      • repeating fields
      • modify repeating field values
    • 15 replies
    • 1.5k views
    • 
    • comment
    • January 25, 2016

29. Calculation result depends on date query

    By Gogargirl, January 21, 2016   

    • calculation
    • date range
    • 4 replies
    • 1.3k views
    • 
    • Gogargirl
    • January 25, 2016

30. Separating info into seperate fields

    By Ben Ball, January 22, 2016
    • 1 reply
    • 600 views
    • 
    • comment
    • January 22, 2016

31. User Name Calc

    By Bikeman17, January 21, 2016
    • 3 replies
    • 707 views
    • 
    • bcooney
    • January 21, 2016

32. Is it possible to find and compare different records in a calculation?

    By Vliet057, January 21, 2016
    • 7 replies
    • 666 views
    • 
    • comment
    • January 21, 2016

33. Displaying a count of related records within a parent record

    By davidnickerson, September 21, 2015
    • 6 replies
    • 958 views
    • 
    • comment
    • January 21, 2016

34. Pulling Text Names from related Table Portal

    By frankb3, January 21, 2016
    • 2 replies
    • 737 views
    • 
    • frankb3
    • January 21, 2016

35. Mark Record based on relationship status?

    By Devin, January 20, 2016
    • 4 replies
    • 662 views
    • 
    • Devin
    • January 21, 2016