Calculation Engine (Define Fields)

12,872 topics in this forum

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

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

2. Calculation search for values starting with...

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

3. How to make data entries on a form

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

4. Changing date format

   By mushroom, November 19, 2015   

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

5. Premium Summary Total of Field - not always displaying

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

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

   By steveald, November 16, 2015   

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

7. portal calculation time entry

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

8. Date round up or down?

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

9. Calculating Next Serial Number

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

10. Let Function

    By Peter Barfield, November 5, 2015   

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

11. Determinne Whether ANY Field Contains a Specific Value

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

12. Summary has two values?

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

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

    By ACAM, November 3, 2015   

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

14. 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
    • 922 views
    • 
    • Henry Situ
    • November 4, 2015

15. Get (CurrentDate) function not working properly.

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

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

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

17. hourly rates

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

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

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

19. RemoveDuplicate extended

    By mikeytt, October 28, 2015   

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

       Tagged with:

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

20. 'Aggregating' text data from Portal

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

21. Very simple subtotals

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

22. Correct relationship for calc field (Lookup function)

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

23. Avoid Duplicate Records

    By Agentshevy, October 22, 2015   

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

24. Using Aggregate Functions with Related Data

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

25. multiple substitutions from scripted variable

    By tom robinson, October 17, 2015   

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

26. Quantity on Hand Calculation

    By Lola, October 12, 2015   

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

27. Case / If Perhaps

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

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

29. counting partial result

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

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

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

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

32. Round Function - Results seem incorrect

    By djlane, October 12, 2015   

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

33. Dynamic Clock possible?

    By Mikhail, October 3, 2015
    • 7 replies
    • 1.1k views
    • 
    • ggt667
    • October 8, 2015

34. Mixing manual entry fields and calculation fields in List view

    By laguna92651, October 7, 2015
    • 4 replies
    • 782 views
    • 
    • laguna92651
    • October 8, 2015

35. exporting data from a relational databases

    By msoussi, October 7, 2015
    • 8 replies
    • 772 views
    • 
    • Lee Smith
    • October 7, 2015