Calculation Engine (Define Fields)

12,875 topics in this forum

1. Doing a Count on a subset of records

   By MCT, November 30, 2015
   • 7 replies
   • 1.4k views
   • 
   • MCT
   • December 1, 2015

2. Get ( WindowMode )

   By madman411, November 30, 2015
   • 1 reply
   • 1.1k views
   • 
   • bruceR
   • November 30, 2015

3. Rank/position number of sorted records

   By enquirerfm, November 26, 2015   

   • rank
   • sort
   • 5 replies
   • 2.3k views
   • 
   • enquirerfm
   • November 27, 2015

4. "Hide Object When..." not working with simple calc

   By Rich S, November 22, 2015
   • 2 replies
   • 984 views
   • 
   • Rich S
   • November 23, 2015

5. Calculation search for values starting with...

   By McScripta, November 20, 2015
   • 2 replies
   • 837 views
   • 
   • McScripta
   • November 20, 2015

6. How to make data entries on a form

   By Arbs001, November 17, 2015
   • 5 replies
   • 1.2k views
   • 
   • Kunal Oogorah
   • November 20, 2015

7. Changing date format

   By mushroom, November 19, 2015   

   • date
   • script
   • 5 replies
   • 7.4k views
   • 
   • mushroom
   • November 20, 2015

8. Premium Summary Total of Field - not always displaying

   By Matthew R White, November 17, 2015
   • 2 replies
   • 755 views
   • 
   • Fitch
   • November 17, 2015

9. How to display running total for one field for specific set of records

   By steveald, November 16, 2015   

   • fmp14
   • running totals
   • 2 replies
   • 2.1k views
   • 
   • comment
   • November 17, 2015

10. portal calculation time entry

    By RT, November 10, 2015
    • 4 replies
    • 1.1k views
    • 
    • RT
    • November 16, 2015

11. Date round up or down?

    By LaRetta, November 10, 2015
    • 8 replies
    • 1.2k views
    • 
    • LaRetta
    • November 15, 2015

12. Calculating Next Serial Number

    By CKonash, November 8, 2015
    • 4 replies
    • 801 views
    • 
    • comment
    • November 8, 2015

13. Let Function

    By Peter Barfield, November 5, 2015   

    • let function
    • 8 replies
    • 1k views
    • 
    • Rick Whitelaw
    • November 7, 2015

14. Determinne Whether ANY Field Contains a Specific Value

    By JeffreyCampos, November 2, 2015
    • 2 replies
    • 662 views
    • 
    • JeffreyCampos
    • November 6, 2015

15. Summary has two values?

    By MaxB., November 4, 2015
    • 0 replies
    • 709 views
    • 
    • MaxB.
    • November 4, 2015

16. Help! Calculation Field to show required courses have been completed

    By ACAM, November 3, 2015   

    • calculaiton
    • script
    • 6 replies
    • 1.2k views
    • 
    • bcooney
    • November 4, 2015

17. FileMaker Pro on a mobile web app?

    By Henry Situ, November 4, 2015   

    • workflow
    • automation
    • (and 1 more)

       Tagged with:

      • workflow
      • automation
      • spreadsheet
    • 0 replies
    • 956 views
    • 
    • Henry Situ
    • November 4, 2015

18. Get (CurrentDate) function not working properly.

    By HX_Guy, November 4, 2015
    • 3 replies
    • 986 views
    • 
    • comment
    • November 4, 2015

19. Field not validating by calculation correctly when entering through show dialogue Script step

    By AnthonyDixon, November 1, 2015
    • 3 replies
    • 816 views
    • 
    • Ocean West
    • November 1, 2015

20. hourly rates

    By the_furious, October 30, 2015
    • 9 replies
    • 999 views
    • 
    • ggt667
    • October 31, 2015

21. Multi-Line key, need calc to 'extract' related values.

    By Grundly, October 30, 2015
    • 2 replies
    • 577 views
    • 
    • Grundly
    • October 30, 2015

22. RemoveDuplicate extended

    By mikeytt, October 28, 2015   

    • duplicates list
    • brian dunning
    • (and 1 more)

       Tagged with:

      • duplicates list
      • brian dunning
      • removeduplicates
    • 17 replies
    • 1.5k views
    • 
    • comment
    • October 29, 2015

23. 'Aggregating' text data from Portal

    By webko, October 26, 2015
    • 3 replies
    • 728 views
    • 
    • comment
    • October 26, 2015

24. Very simple subtotals

    By Dmytro, October 23, 2015
    • 3 replies
    • 810 views
    • 
    • LaRetta
    • October 24, 2015

25. Correct relationship for calc field (Lookup function)

    By Dmytro, October 21, 2015
    • 5 replies
    • 845 views
    • 
    • Dmytro
    • October 23, 2015

26. Avoid Duplicate Records

    By Agentshevy, October 22, 2015   

    • duplicate
    • portall
    • 7 replies
    • 1.5k views
    • 
    • LaRetta
    • October 23, 2015

27. Using Aggregate Functions with Related Data

    By davidnickerson, October 10, 2015
    • 6 replies
    • 1.1k views
    • 
    • davidnickerson
    • October 18, 2015

28. multiple substitutions from scripted variable

    By tom robinson, October 17, 2015   

    • substitute
    • 2 replies
    • 1.9k views
    • 
    • Lee Smith
    • October 17, 2015

29. Quantity on Hand Calculation

    By Lola, October 12, 2015   

    • calculation
    • 7 replies
    • 1.7k views
    • 
    • Lola
    • October 16, 2015

30. Case / If Perhaps

    By Poruchan, October 15, 2015
    • 4 replies
    • 766 views
    • 
    • ggt667
    • October 15, 2015

31. Getting Case result from one record into preceding record

    By Poruchan, October 8, 2015   

    • case
    • sort
    • 4 replies
    • 1.5k views
    • 
    • Poruchan
    • October 15, 2015

32. counting partial result

    By Marcus69, October 10, 2015
    • 10 replies
    • 1.8k views
    • 
    • Marcus69
    • October 14, 2015

33. Finding Field Values in a one to many relationship

    By andersonk06, October 9, 2015   

    • calculation
    • lookup
    • 7 replies
    • 1.3k views
    • 
    • andersonk06
    • October 12, 2015

34. How do you get previous Invoice's total/

    By justinkim943, October 12, 2015
    • 1 reply
    • 832 views
    • 
    • eos
    • October 12, 2015

35. Round Function - Results seem incorrect

    By djlane, October 12, 2015   

    • round error
    • 2 replies
    • 941 views
    • 
    • djlane
    • October 12, 2015