Calculation Engine (Define Fields)

12,871 topics in this forum

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

   By MikeKD, January 26, 2015
   • 9 replies
   • 966 views
   • 
   • MikeKD
   • January 27, 2015

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

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

3. First four of every record

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

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

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

5. mac Parsing out a substring... multiple instances...?

   By SB-Books, January 22, 2015   

   • text
   • parse
   • (and 2 more)

      Tagged with:

     • text
     • parse
     • parsing
     • string
   • 4 replies
   • 1.5k views
   • 
   • SB-Books
   • January 22, 2015

6. Evaluate.. Let... Variables... Lost!

   By Lutmers, January 22, 2015   

   • evaluate
   • let
   • (and 1 more)

      Tagged with:

     • evaluate
     • let
     • variable
   • 1 reply
   • 2.5k views
   • 
   • Lutmers
   • January 22, 2015

7. Calculating active field

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

8. Calculating Percentage increase on records of different years.

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

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

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

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

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

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

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

12. Count days between dates.

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

13. best address

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

14. Lookup fields

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

15. Generate "ranking" field

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

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

    By enquirerfm, January 14, 2015   

    • csv
    • output
    • 2 replies
    • 1.3k views
    • 
    • comment
    • January 16, 2015

17. Look Up Values

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

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

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

19. Filter List Table By Time Frame

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

20. Cross Tab Reporting

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

21. Calculating "X" months from a given date

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

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

    By megalomania, January 7, 2015   

    • valuelists
    • 3 replies
    • 1.1k views
    • 
    • megalomania
    • January 7, 2015

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

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

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

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

25. Case (1 =

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

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

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

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

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

28. removing blank space before the start of text

    By hownow, December 28, 2014
    • 2 replies
    • 868 views
    • 
    • Wim Decorte
    • December 28, 2014

29. Grabbing an entire line of text from a paragraph

    By hownow, December 28, 2014
    • 4 replies
    • 765 views
    • 
    • hownow
    • December 28, 2014

30. Calculation based on whether a file exists

    By Stickybeak, December 27, 2014   

    • fielexists
    • documentspath
    • 4 replies
    • 1.1k views
    • 
    • Stickybeak
    • December 27, 2014

31. mac | pc Count records in related table and display in portal

    By AGilek, December 26, 2014   

    • counting records
    • portal
    • 4 replies
    • 3.4k views
    • 
    • AGilek
    • December 26, 2014

32. mac Basic "If" statement with dialog

    By MattO, December 23, 2014   

    • if endif
    • 3 replies
    • 1.3k views
    • 
    • MattO
    • December 24, 2014

33. Trapping field entry validation error (in script?) and acting on it

    By mikedr, December 22, 2014   

    • script
    • validation
    • 13 replies
    • 1.7k views
    • 
    • mikedr
    • December 23, 2014

34. Evaluate function and repeated field: Puzzling miscalculation

    By sfpx, December 22, 2014
    • 4 replies
    • 1.1k views
    • 
    • sfpx
    • December 22, 2014

35. How can I get the url from a Web Browser into a filemaker field?

    By hownow, December 19, 2014
    • 5 replies
    • 1.3k views
    • 
    • hownow
    • December 21, 2014