Calculation Engine (Define Fields)

12,871 topics in this forum

1. GetAsNumber()

   By adyf, July 5, 2012
   • 5 replies
   • 1.2k views
   • 
   • comment
   • July 6, 2012

2. Case Statement - only last statement not working

   By dschaal, June 25, 2012
   • 11 replies
   • 1.7k views
   • 
   • dschaal
   • July 5, 2012

3. Calculating sums for a found set in a related table

   By AnotherNewGuy, July 5, 2012
   • 0 replies
   • 589 views
   • 
   • AnotherNewGuy
   • July 5, 2012

4. Grabbing first ever related record if within a date range..

   By DanMarks, July 4, 2012
   • 2 replies
   • 1k views
   • 
   • doughemi
   • July 4, 2012

5. Question on adding default value in a calulation unless field says different

   By stevebull, June 28, 2012
   • 4 replies
   • 886 views
   • 
   • comment
   • July 3, 2012

6. Calculation Bug?

   By Don_Macaroni, July 1, 2012
   • 2 replies
   • 771 views
   • 
   • Agnes Riley
   • July 2, 2012

7. Carriage Return Issues

   By tchemiy, June 28, 2012
   • 4 replies
   • 999 views
   • 
   • tchemiy
   • July 2, 2012

8. connecting tables?

   By marys26, July 2, 2012
   • 2 replies
   • 621 views
   • 
   • marys26
   • July 2, 2012

9. Year(Get(CurrentDate) ?

   By Michelle Logan, July 2, 2012
   • 4 replies
   • 855 views
   • 
   • comment
   • July 2, 2012

10. Portal row - sum specific records only

    By 4Justme2, June 21, 2012
    • 6 replies
    • 1.7k views
    • 
    • No_access
    • June 30, 2012

11. lookup parent, grandparent, or great-grandparent?

    By LaRetta, June 29, 2012
    • 1 reply
    • 800 views
    • 
    • LaRetta
    • June 29, 2012

12. All process welded dates

    By The Big Bear, June 26, 2012
    • 4 replies
    • 1k views
    • 
    • The Big Bear
    • June 29, 2012

13. Number limit of Else If statements

    By Michelle Logan, June 28, 2012
    • 5 replies
    • 1.5k views
    • 
    • Fitch
    • June 29, 2012

14. SImple arithmetical error

    By jdjd, June 26, 2012
    • 5 replies
    • 1.1k views
    • 
    • comment
    • June 28, 2012

15. Need GetNthRecord-style function for RecordIDs

    By K1200, June 24, 2012
    • 4 replies
    • 1k views
    • 
    • comment
    • June 28, 2012

16. Calculating Week Number of Month

    By Joe_Schmo, June 27, 2012
    • 2 replies
    • 801 views
    • 
    • Joe_Schmo
    • June 27, 2012

17. Can someone explain how images are handled in FMP 12?

    By nleon307, June 26, 2012
    • 1 reply
    • 1.1k views
    • 
    • Lee Smith
    • June 26, 2012

18. Parsing data from a single field into multiple fields?

    By HALBURN, June 23, 2012
    • 5 replies
    • 691 views
    • 
    • Vaughan
    • June 26, 2012

19. Store files in containers? Or Reference?

    By JTSmith, June 26, 2012
    • 1 reply
    • 614 views
    • 
    • Aussie John
    • June 26, 2012

20. Struggling with easy text parsing...

    By JTSmith, June 22, 2012
    • 4 replies
    • 751 views
    • 
    • JTSmith
    • June 22, 2012

21. Validate the field based on the another field

    By Muralidharan, June 22, 2012
    • 2 replies
    • 872 views
    • 
    • comment
    • June 22, 2012

22. Calendar Validation

    By 4Justme2, June 20, 2012
    • 7 replies
    • 882 views
    • 
    • 4Justme2
    • June 20, 2012

23. Calculation to show oldest and newest creation date?

    By Fredrik, June 12, 2012
    • 9 replies
    • 1k views
    • 
    • LaRetta
    • June 19, 2012

24. recurring calendar event

    By Chemadian, June 1, 2012
    • 6 replies
    • 3k views
    • 
    • eos
    • June 16, 2012

25. Goto Script help

    By cterrell16, June 15, 2012
    • 2 replies
    • 671 views
    • 
    • Fitch
    • June 15, 2012

26. Text Parsing Question

    By JTSmith, June 15, 2012
    • 2 replies
    • 816 views
    • 
    • JTSmith
    • June 15, 2012

27. Fieldnames function

    By Digital Life, June 14, 2012
    • 1 reply
    • 655 views
    • 
    • Digital Life
    • June 14, 2012

28. Running sum total of commission earned

    By topaznz, June 14, 2012
    • 2 replies
    • 1k views
    • 
    • topaznz
    • June 14, 2012

29. Running count problem in a portal

    By Rich S, June 13, 2012
    • 2 replies
    • 658 views
    • 
    • Rich S
    • June 13, 2012

30. Open URL Question

    By tedg, June 12, 2012
    • 2 replies
    • 840 views
    • 
    • tedg
    • June 13, 2012

31. Calculation Issues

    By developdba, June 12, 2012
    • 3 replies
    • 790 views
    • 
    • mr_vodka
    • June 12, 2012

32. GetAsDate() fixes issue, but why?

    By jkluchnik, June 12, 2012
    • 1 reply
    • 1.1k views
    • 
    • LaRetta
    • June 12, 2012

33. Calculation to parse text between semi-colons from one field into multiple fields

    By Joe_Schmo, June 12, 2012
    • 7 replies
    • 1.1k views
    • 
    • Joe_Schmo
    • June 12, 2012

34. Converting text with GMT offset to timestamp

    By TBaker, June 11, 2012
    • 3 replies
    • 1.4k views
    • 
    • TBaker
    • June 12, 2012

35. Trim text beginning and end

    By Jimbojames30, June 11, 2012
    • 3 replies
    • 921 views
    • 
    • comment
    • June 11, 2012