Calculation Engine (Define Fields)

12,879 topics in this forum

1. How to get calculation field to calculate ALL portal rows, not just first portal row

   By Agian510, November 10, 2020
   • 3 replies
   • 710 views
   • 
   • comment
   • November 10, 2020

2. Car owner's list, seems simple but I can't do it...

   By David Maffucci, November 3, 2020
   • 4 replies
   • 758 views
   • 
   • Agian510
   • November 10, 2020

3. List Function: How to Remove Specific Related Records from the Results

   By vanderark1, October 30, 2020
   • 1 reply
   • 804 views
   • 
   • comment
   • October 30, 2020

4. Calculation of number certain type of contact per Company

   By Chrism, October 3, 2020
   • 20 replies
   • 1.2k views
   • 
   • Bertie
   • October 27, 2020

5. Xero integration using OAuth 2.0

   By Bertie, October 27, 2020
   • 0 replies
   • 609 views
   • 
   • Bertie
   • October 27, 2020

6. How to auto checkmark "Check Boxes"?

   By Rangoon, April 6, 2013
   • 2 replies
   • 884 views
   • 
   • 1FilemakerMan
   • October 26, 2020

7. Need help averaging repeating fields

   By djeans, October 22, 2020
   • 2 replies
   • 649 views
   • 
   • djeans
   • October 23, 2020

8. Determining Date Format when Parsing JSON data?

   By Tony Diaz, October 12, 2020
   • 1 reply
   • 1k views
   • 
   • comment
   • October 12, 2020

9. Best way to calculate related field total

   By naio, August 29, 2020
   • 3 replies
   • 687 views
   • 
   • James Gill
   • September 28, 2020

10. Old script defining date navigation has broken in 19.

    By RD_wnc, September 20, 2020
    • 1 reply
    • 575 views
    • 
    • Steve Martino
    • September 20, 2020

11. Combining field data under certain conditions

    By Rebecca, September 14, 2020
    • 9 replies
    • 749 views
    • 
    • comment
    • September 17, 2020

12. Why are TextColor and TextFont not working for me?

    By philipcaplan, September 15, 2020
    • 3 replies
    • 706 views
    • 
    • comment
    • September 15, 2020

13. Accidentally deleted all records - What to do?

    By any66499, September 15, 2020
    • 3 replies
    • 743 views
    • 
    • Mike Duncan
    • September 15, 2020

14. Create an Automated Script to Increment a number by 1

    By dancer5678, September 11, 2020
    • 13 replies
    • 1.4k views
    • 
    • dancer5678
    • September 11, 2020

15. how to show another field content on a different record based on some condition?

    By emtau, August 24, 2020
    • 6 replies
    • 1.3k views
    • 
    • emtau
    • August 25, 2020

16. Need calculation to move "The" or "A" at the front of a field to the end after a comma

    By jhmiii, August 23, 2020
    • 3 replies
    • 717 views
    • 
    • jhmiii
    • August 24, 2020

17. Filemaker 12 Pro

    By Twizzle, August 22, 2020
    • 2 replies
    • 1.2k views
    • 
    • Steve Martino
    • August 23, 2020

18. Sorting; how to allow only few selected fields to be included in the sort window.

    By emtau, August 19, 2020
    • 2 replies
    • 576 views
    • 
    • emtau
    • August 19, 2020

19. Extracting first name from Last, First MI

    By -dp-, August 18, 2020
    • 11 replies
    • 1.1k views
    • 
    • -dp-
    • August 18, 2020

20. How to get the value of a field in a portal based on another field on the same row on the same portal?

    By emtau, August 18, 2020
    • 4 replies
    • 1.1k views
    • 
    • emtau
    • August 18, 2020

21. PatternCount not working

    By jeffamm, August 16, 2020
    • 2 replies
    • 587 views
    • 
    • jeffamm
    • August 16, 2020

22. Script to specify find request - based on calcluated criteria

    By emtau, August 12, 2020
    • 2 replies
    • 602 views
    • 
    • emtau
    • August 12, 2020

23. Set field as next or previous value from value list

    By b.hunt, August 11, 2020
    • 2 replies
    • 635 views
    • 
    • b.hunt
    • August 11, 2020

24. Need help with table relationship

    By emtau, August 9, 2020
    • 1 reply
    • 698 views
    • 
    • Fitch
    • August 10, 2020

25. Extracting data from one field into another

    By philipcaplan, August 7, 2020
    • 6 replies
    • 670 views
    • 
    • philipcaplan
    • August 7, 2020

26. Filter or Search Subsummary

    By sirsancho09, August 1, 2020
    • 0 replies
    • 540 views
    • 
    • sirsancho09
    • August 1, 2020

27. Auto translate language stored the stored data base on the language of the user

    By archrid404, July 29, 2020
    • 1 reply
    • 546 views
    • 
    • comment
    • July 29, 2020

28. Container Field display PDF Interactively on MacOs

    By A_K, July 17, 2020
    • 2 replies
    • 661 views
    • 
    • Ocean West
    • July 18, 2020

29. Window-specific global field

    By sal88, October 31, 2019
    • 28 replies
    • 4k views
    • 
    • sal88
    • July 15, 2020

30. Look up values based on two fields

    By Adam Masters, July 9, 2020
    • 10 replies
    • 1.1k views
    • 
    • Adam Masters
    • July 11, 2020

31. LABELS WITH AN INCREASING COUNTER

    By Ixel, July 6, 2020
    • 4 replies
    • 1.4k views
    • 
    • Ixel
    • July 7, 2020

32. help knapsack problem solution solver

    By aperocket, June 30, 2020
    • 3 replies
    • 1.9k views
    • 
    • aperocket
    • July 2, 2020

33. using find (?) in a Calculation?

    By Rancher, June 18, 2020
    • 6 replies
    • 2k views
    • 
    • Fitch
    • June 20, 2020

34. Concatenate text of multiple records with same Year_OrderNumber

    By anteas1998, June 17, 2020
    • 1 reply
    • 553 views
    • 
    • comment
    • June 17, 2020

35. Hide Object based on Status of Button Bar

    By tshramek, June 9, 2020
    • 11 replies
    • 2.1k views
    • 
    • tshramek
    • June 12, 2020