Calculation Engine (Define Fields)

12,879 topics in this forum

1. Calculate duration between 2 date/time events - weird result

   By skingjack2, January 21, 2015
   • 7 replies
   • 1.5k views
   • 
   • skingjack2
   • February 4, 2015

2. reverse calc for date

   By Matthew R White, February 2, 2015
   • 4 replies
   • 736 views
   • 
   • Lee Smith
   • February 3, 2015

3. Need to collect info between two string in a screen copy of a webpage

   By hownow, February 2, 2015
   • 3 replies
   • 1.4k views
   • 
   • hownow
   • February 3, 2015

4. Field populating determined by current month field value. How to?

   By AbsoluteVoice4u, January 28, 2015
   • 17 replies
   • 1.7k views
   • 
   • AbsoluteVoice4u
   • February 2, 2015

5. Is it possible to use a Let variable to verify the value of a global variable?

   By HALBURN, February 1, 2015
   • 2 replies
   • 631 views
   • 
   • HALBURN
   • February 2, 2015

6. If statement problem- for me- on how to detect several items

   By hownow, January 29, 2015
   • 7 replies
   • 901 views
   • 
   • hownow
   • January 31, 2015

7. Calculation difference in same field but previous record

   By bmnation, July 30, 2010
   • 12 replies
   • 8.5k views
   • 
   • eos
   • January 30, 2015

8. Data Validation By Calculation

   By rkass068, January 29, 2015
   • 15 replies
   • 1.4k views
   • 
   • comment
   • January 29, 2015

9. Don't quite get List function...

   By MikeKD, January 26, 2015
   • 9 replies
   • 1k views
   • 
   • MikeKD
   • January 27, 2015

10. Calculate number of times specific field says "Quote"

    By Mike513jr, January 25, 2015
    • 12 replies
    • 1k views
    • 
    • OlgerDiekstra
    • January 26, 2015

11. First four of every record

    By Charity, January 14, 2015
    • 7 replies
    • 995 views
    • 
    • mikedr
    • January 23, 2015

12. How can I grab the first 100 lines of a text string?

    By HALBURN, January 23, 2015
    • 2 replies
    • 641 views
    • 
    • HALBURN
    • January 23, 2015

13. Parsing out a substring... multiple instances...?

    By SB-Books, January 22, 2015
    • 4 replies
    • 1.6k views
    • 
    • SB-Books
    • January 22, 2015

14. Evaluate.. Let... Variables... Lost!

    By Lutmers, January 22, 2015
    • 1 reply
    • 2.7k views
    • 
    • Lutmers
    • January 22, 2015

15. Calculating active field

    By madman411, January 22, 2015
    • 4 replies
    • 773 views
    • 
    • bruceR
    • January 22, 2015

16. Calculating Percentage increase on records of different years.

    By Miss A!, January 20, 2015
    • 11 replies
    • 2k views
    • 
    • LaRetta
    • January 21, 2015

17. Can a find be calculated without pasting in the find field?

    By hownow, January 20, 2015
    • 2 replies
    • 649 views
    • 
    • hownow
    • January 21, 2015

18. Having problems getting prefix and suffix for this web URL

    By hownow, January 18, 2015
    • 2 replies
    • 951 views
    • 
    • hownow
    • January 19, 2015

19. Help needed with Birthday date search but client needs to be able to enter date range

    By slakkie, January 18, 2015
    • 2 replies
    • 920 views
    • 
    • comment
    • January 18, 2015

20. Count days between dates.

    By tobbesfilemaker, September 27, 2012
    • 15 replies
    • 3.3k views
    • 
    • mikedr
    • January 18, 2015

21. best address

    By Charity, January 3, 2015
    • 21 replies
    • 2.9k views
    • 
    • The Shadow
    • January 17, 2015

22. Lookup fields

    By James Gill, January 14, 2015
    • 10 replies
    • 1.7k views
    • 
    • James Gill
    • January 16, 2015

23. Generate "ranking" field

    By MikeKD, January 14, 2015
    • 14 replies
    • 4.2k views
    • 
    • comment
    • January 16, 2015

24. csv output and formatting a combination field so it has spaces

    By enquirerfm, January 14, 2015
    • 2 replies
    • 1.4k views
    • 
    • comment
    • January 16, 2015

25. Look Up Values

    By BadgerBlu, January 12, 2015
    • 6 replies
    • 819 views
    • 
    • comment
    • January 16, 2015

26. Is there a "wildcard" function in filemaker if finding text?

    By hownow, January 12, 2015
    • 17 replies
    • 7.1k views
    • 
    • hownow
    • January 14, 2015

27. Filter List Table By Time Frame

    By samarthmkt, January 14, 2015
    • 0 replies
    • 951 views
    • 
    • samarthmkt
    • January 14, 2015

28. Cross Tab Reporting

    By Rosalie, January 5, 2015
    • 2 replies
    • 1.1k views
    • 
    • Kris M
    • January 13, 2015

29. Calculating "X" months from a given date

    By mikedr, January 4, 2015
    • 17 replies
    • 1.9k views
    • 
    • mikedr
    • January 7, 2015

30. how can I count occurrence number of each item in value lists

    By megalomania, January 7, 2015
    • 3 replies
    • 1.2k views
    • 
    • megalomania
    • January 7, 2015

31. How can a boolean test return true and still fail?

    By James Gill, December 12, 2014
    • 5 replies
    • 846 views
    • 
    • comment
    • January 6, 2015

32. Add time to timestamp, ignoring out of office hours

    By sal88, January 2, 2015
    • 4 replies
    • 749 views
    • 
    • sal88
    • January 3, 2015

33. Case (1 =

    By MacFileman, January 2, 2015
    • 2 replies
    • 789 views
    • 
    • MacFileman
    • January 2, 2015

34. In text parsing Removing a specific word or character like a replace function

    By hownow, November 18, 2014
    • 17 replies
    • 1.5k views
    • 
    • MikeKD
    • December 30, 2014

35. text parsing question exchanging spaces for - and removing a ,

    By hownow, December 29, 2014
    • 4 replies
    • 781 views
    • 
    • Lee Smith
    • December 29, 2014