Calculation Engine (Define Fields)

12,869 topics in this forum

1. Complicated excel sheet

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

2. Calculation of text string

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

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

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

4. Did a relookup change anything?

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

5. Need full state name from abbreviation

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

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

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

7. Getting phone number from calculation

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

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

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

9. Monthly Serial

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

10. Substitution issue

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

11. timestamp question

    By woodman35, November 10, 2013   

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

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

13. Toggle between elapsed days and elapsed weeks and days

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

14. Matching first character to an Alphabetic list

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

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

    By rsin, November 7, 2013   

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

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

17. Summarize If

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

18. Left on all list items?

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

19. Remove the Before and After in a Text String

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

20. Compare Lists Boolean?

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

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

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

22. Variable in ExecuteSQL?

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

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

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

25. Sorting records to make a random sort?

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

26. Calculation equivalent for Filtered Portal?

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

27. Can a record be locked

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

28. Building a "dynamic" Priority Field

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

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

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

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

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

31. Text Parse, just need first line?

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

32. Invoice with different billing address/payer

    By FysiOlsen, October 26, 2013   

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

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

34. How to stop users from entering certain characters

    By DLM, October 7, 2013
    • 7 replies
    • 1.2k views
    • 
    • Aussie John
    • October 25, 2013

35. Counting the number of flagged Records

    By OzzieOzzum, October 23, 2013
    • 6 replies
    • 876 views
    • 
    • OzzieOzzum
    • October 23, 2013