Calculation Engine (Define Fields)

12,871 topics in this forum

1. Calculation search for values starting with...

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

2. How to make data entries on a form

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

3. Changing date format

   By mushroom, November 19, 2015   

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

4. Premium Summary Total of Field - not always displaying

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

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

6. portal calculation time entry

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

7. Date round up or down?

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

8. Calculating Next Serial Number

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

9. Let Function

   By Peter Barfield, November 5, 2015   

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

10. Determinne Whether ANY Field Contains a Specific Value

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

11. Summary has two values?

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

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

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

14. Get (CurrentDate) function not working properly.

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

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

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

16. hourly rates

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

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

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

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

19. 'Aggregating' text data from Portal

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

20. Very simple subtotals

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

21. Correct relationship for calc field (Lookup function)

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

22. Avoid Duplicate Records

    By Agentshevy, October 22, 2015   

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

23. Using Aggregate Functions with Related Data

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

24. multiple substitutions from scripted variable

    By tom robinson, October 17, 2015   

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

25. Quantity on Hand Calculation

    By Lola, October 12, 2015   

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

26. Case / If Perhaps

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

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

28. counting partial result

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

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

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

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

31. Round Function - Results seem incorrect

    By djlane, October 12, 2015   

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

32. Dynamic Clock possible?

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

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

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

34. exporting data from a relational databases

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

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

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