Calculation Engine (Define Fields)

12,871 topics in this forum

1. Calculation help with serial in pk.

   By fmow, November 7, 2013
   • 11 replies
   • 1.9k views
   • 
   • fmow
   • November 27, 2013

2. Constrain/Filter a Sub-summary Value?

   By Rich S, October 8, 2013
   • 4 replies
   • 1.2k views
   • 
   • Rich S
   • November 26, 2013

3. Complicated excel sheet

   By James Patrick, November 25, 2013
   • 6 replies
   • 592 views
   • 
   • James Patrick
   • November 25, 2013

4. Calculation of text string

   By rkass068, November 18, 2013
   • 14 replies
   • 1.1k views
   • 
   • rkass068
   • November 21, 2013

5. Calc for having a tooltip appear while hovering over a button?

   By Rich S, November 20, 2013
   • 3 replies
   • 699 views
   • 
   • comment
   • November 20, 2013

6. Did a relookup change anything?

   By brian rich, November 14, 2013
   • 19 replies
   • 2.6k views
   • 
   • brian rich
   • November 19, 2013

7. Need full state name from abbreviation

   By Rennie, November 19, 2013
   • 3 replies
   • 1.3k views
   • 
   • Rennie
   • November 19, 2013

8. Calculation to find the last entered related record matching a certain criteria..

   By Steven Cappiello, November 12, 2013
   • 3 replies
   • 952 views
   • 
   • Steven Cappiello
   • November 18, 2013

9. Getting phone number from calculation

   By RT, November 12, 2013
   • 12 replies
   • 1.6k views
   • 
   • RT
   • November 14, 2013

10. Field which displays another record's field contents (same table)

    By cruijff, November 13, 2013
    • 11 replies
    • 910 views
    • 
    • LaRetta
    • November 14, 2013

11. Monthly Serial

    By FileMaker_Entry Level, November 12, 2013
    • 5 replies
    • 851 views
    • 
    • FileMaker_Entry Level
    • November 13, 2013

12. Substitution issue

    By Dagel, November 12, 2013
    • 2 replies
    • 721 views
    • 
    • Dagel
    • November 13, 2013

13. timestamp question

    By woodman35, November 10, 2013   

    • fm12
    • 2 replies
    • 1k views
    • 
    • Lee Smith
    • November 10, 2013

14. How to reset a serial number in a field?

    By Dr.Hamed, November 9, 2013   

    • date function
    • serial number
    • 3 replies
    • 3.7k views
    • 
    • comment
    • November 10, 2013

15. Toggle between elapsed days and elapsed weeks and days

    By madman411, November 8, 2013
    • 10 replies
    • 839 views
    • 
    • comment
    • November 9, 2013

16. Matching first character to an Alphabetic list

    By jarbro, November 8, 2013
    • 4 replies
    • 674 views
    • 
    • comment
    • November 8, 2013

17. How to prevent auto enter calculation from executing while creating a new record

    By rsin, November 7, 2013   

    • performance
    • auto enter calculations
    • 5 replies
    • 953 views
    • 
    • comment
    • November 8, 2013

18. Date Title Header List Layout

    By buckbuck, November 6, 2013   

    • dating a report
    • title date
    • (and 3 more)

       Tagged with:

      • dating a report
      • title date
      • list layout current date
      • printing a date
      • date issue
    • 5 replies
    • 1k views
    • 
    • LaRetta
    • November 7, 2013

19. Summarize If

    By Matthew R White, November 6, 2013
    • 3 replies
    • 808 views
    • 
    • comment
    • November 6, 2013

20. Left on all list items?

    By pctechtv, November 6, 2013
    • 2 replies
    • 573 views
    • 
    • bruceR
    • November 6, 2013

21. Remove the Before and After in a Text String

    By charisse, November 1, 2013
    • 5 replies
    • 792 views
    • 
    • charisse
    • November 5, 2013

22. Compare Lists Boolean?

    By pctechtv, November 4, 2013
    • 1 reply
    • 590 views
    • 
    • Raybaudi
    • November 4, 2013

23. text calc to parse information on the last line of page (Always the same place)

    By mistery, November 4, 2013
    • 1 reply
    • 686 views
    • 
    • Fitch
    • November 4, 2013

24. Variable in ExecuteSQL?

    By pctechtv, November 3, 2013
    • 1 reply
    • 572 views
    • 
    • comment
    • November 3, 2013

25. Can we have two "currency exchange" fields : Entering a value in one gives the result in the other and vice versa

    By Dr.Hamed, November 3, 2013   

    • calculation
    • exchange fields
    • 1 reply
    • 1.1k views
    • 
    • comment
    • November 3, 2013

26. Separating letters of the word with spaces

    By Dr.Hamed, November 1, 2013   

    • words
    • characters
    • (and 2 more)

       Tagged with:

      • words
      • characters
      • spaces
      • text function
    • 15 replies
    • 1.3k views
    • 
    • Lee Smith
    • November 2, 2013

27. Sorting records to make a random sort?

    By mistery, November 1, 2013
    • 3 replies
    • 782 views
    • 
    • comment
    • November 1, 2013

28. Calculation equivalent for Filtered Portal?

    By bac mac, October 28, 2013
    • 7 replies
    • 1.2k views
    • 
    • bac mac
    • October 31, 2013

29. Can a record be locked

    By hartmut, October 29, 2013
    • 9 replies
    • 1.3k views
    • 
    • hartmut
    • October 31, 2013

30. Building a "dynamic" Priority Field

    By Hoib, October 30, 2013
    • 3 replies
    • 1.1k views
    • 
    • Fitch
    • October 31, 2013

31. Why does commented-out calculation wrap itself in quote?

    By Charity, October 23, 2013
    • 3 replies
    • 697 views
    • 
    • truelifeajf
    • October 30, 2013

32. remove text from text field that matches another text field

    By hartmut, October 28, 2013
    • 5 replies
    • 700 views
    • 
    • doughemi
    • October 29, 2013

33. Text Parse, just need first line?

    By JTSmith, October 28, 2013
    • 1 reply
    • 588 views
    • 
    • eos
    • October 28, 2013

34. Invoice with different billing address/payer

    By FysiOlsen, October 26, 2013   

    • billing
    • lookup
    • 0 replies
    • 2.9k views
    • 
    • FysiOlsen
    • October 26, 2013

35. picking the 3 best grades from a course linkup table

    By jax, October 22, 2013   

    • calculation
    • 5 replies
    • 1.4k views
    • 
    • jax
    • October 25, 2013