Calculation Engine (Define Fields)

12,875 topics in this forum

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

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

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

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

3. Calculation difference in same field but previous record

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

4. Data Validation By Calculation

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

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

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

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

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

7. First four of every record

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

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

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

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

10. Evaluate.. Let... Variables... Lost!

    By Lutmers, January 22, 2015   

    • evaluate
    • let
    • (and 1 more)

       Tagged with:

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

11. Calculating active field

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

12. Calculating Percentage increase on records of different years.

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

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

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

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

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

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

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

16. Count days between dates.

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

17. best address

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

18. Lookup fields

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

19. Generate "ranking" field

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

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

21. Look Up Values

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

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

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

23. Filter List Table By Time Frame

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

24. Cross Tab Reporting

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

25. Calculating "X" months from a given date

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

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

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

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

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

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

29. Case (1 =

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

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

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

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

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

32. removing blank space before the start of text

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

33. Grabbing an entire line of text from a paragraph

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

34. Calculation based on whether a file exists

    By Stickybeak, December 27, 2014   

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

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