Calculation Engine (Define Fields)

12,869 topics in this forum

1. Changing date format

   By mushroom, November 19, 2015   

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

2. Premium Summary Total of Field - not always displaying

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

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

4. portal calculation time entry

   By RT, November 10, 2015
   • 4 replies
   • 976 views
   • 
   • RT
   • November 16, 2015

5. Date round up or down?

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

6. Calculating Next Serial Number

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

7. Let Function

   By Peter Barfield, November 5, 2015   

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

8. Determinne Whether ANY Field Contains a Specific Value

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

9. Summary has two values?

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

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

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

12. Get (CurrentDate) function not working properly.

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

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

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

14. hourly rates

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

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

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

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

17. 'Aggregating' text data from Portal

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

18. Very simple subtotals

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

19. Correct relationship for calc field (Lookup function)

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

20. Avoid Duplicate Records

    By Agentshevy, October 22, 2015   

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

21. Using Aggregate Functions with Related Data

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

22. multiple substitutions from scripted variable

    By tom robinson, October 17, 2015   

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

23. Quantity on Hand Calculation

    By Lola, October 12, 2015   

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

24. Case / If Perhaps

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

25. Getting Case result from one record into preceding record

    By Poruchan, October 8, 2015   

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

26. counting partial result

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

27. Finding Field Values in a one to many relationship

    By andersonk06, October 9, 2015   

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

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

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

29. Round Function - Results seem incorrect

    By djlane, October 12, 2015   

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

30. Dynamic Clock possible?

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

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

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

32. exporting data from a relational databases

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

33. Extract account name in front of the "@" sign in an e-mail addy

    By Rich S, October 6, 2015
    • 5 replies
    • 752 views
    • 
    • comment
    • October 7, 2015

34. seconds to minutes

    By Poruchan, October 5, 2015   

    • calculation
    • time
    • 9 replies
    • 2.5k views
    • 
    • Poruchan
    • October 5, 2015

35. Space in a field is not a null return?

    By John Chamberlain, October 3, 2015
    • 1 reply
    • 758 views
    • 
    • comment
    • October 3, 2015