Calculation Engine (Define Fields)

12,877 topics in this forum

1. Text parsing, length unknown.

   By Steve Martino, December 5, 2015
   • 7 replies
   • 1.1k views
   • 
   • jbante
   • December 6, 2015

2. Counting unique occurrences for set of records

   By laguna92651, December 5, 2015
   • 0 replies
   • 713 views
   • 
   • laguna92651
   • December 5, 2015

3. Doing a Count on a subset of records

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

4. Get ( WindowMode )

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

5. Rank/position number of sorted records

   By enquirerfm, November 26, 2015
   • 5 replies
   • 2.3k views
   • 
   • enquirerfm
   • November 27, 2015

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

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

7. Calculation search for values starting with...

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

8. How to make data entries on a form

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

9. Changing date format

   By mushroom, November 19, 2015
   • 5 replies
   • 7.4k views
   • 
   • mushroom
   • November 20, 2015

10. Premium Summary Total of Field - not always displaying

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

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

    By steveald, November 16, 2015
    • 2 replies
    • 2.1k views
    • 
    • comment
    • November 17, 2015

12. portal calculation time entry

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

13. Date round up or down?

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

14. Calculating Next Serial Number

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

15. Let Function

    By Peter Barfield, November 5, 2015
    • 8 replies
    • 1k views
    • 
    • Rick Whitelaw
    • November 7, 2015

16. Determinne Whether ANY Field Contains a Specific Value

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

17. Summary has two values?

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

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

    By ACAM, November 3, 2015
    • 6 replies
    • 1.2k views
    • 
    • bcooney
    • November 4, 2015

19. FileMaker Pro on a mobile web app?

    By Henry Situ, November 4, 2015
    • 0 replies
    • 963 views
    • 
    • Henry Situ
    • November 4, 2015

20. Get (CurrentDate) function not working properly.

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

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

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

22. hourly rates

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

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

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

24. RemoveDuplicate extended

    By mikeytt, October 28, 2015
    • 17 replies
    • 1.5k views
    • 
    • comment
    • October 29, 2015

25. 'Aggregating' text data from Portal

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

26. Very simple subtotals

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

27. Correct relationship for calc field (Lookup function)

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

28. Avoid Duplicate Records

    By Agentshevy, October 22, 2015
    • 7 replies
    • 1.6k views
    • 
    • LaRetta
    • October 23, 2015

29. Using Aggregate Functions with Related Data

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

30. multiple substitutions from scripted variable

    By tom robinson, October 17, 2015
    • 2 replies
    • 1.9k views
    • 
    • Lee Smith
    • October 17, 2015

31. Quantity on Hand Calculation

    By Lola, October 12, 2015
    • 7 replies
    • 1.7k views
    • 
    • Lola
    • October 16, 2015

32. Case / If Perhaps

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

33. Getting Case result from one record into preceding record

    By Poruchan, October 8, 2015
    • 4 replies
    • 1.5k views
    • 
    • Poruchan
    • October 15, 2015

34. counting partial result

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

35. Finding Field Values in a one to many relationship

    By andersonk06, October 9, 2015
    • 7 replies
    • 1.3k views
    • 
    • andersonk06
    • October 12, 2015