Calculation Engine (Define Fields)

12,867 topics in this forum

1. How to get a count summary of past month

   By JohnDing, April 13, 2021
   • 2 replies
   • 460 views
   • 
   • JohnDing
   • April 14, 2021

2. "Get" text style

   By Asu, April 4, 2021
   • 1 reply
   • 589 views
   • 
   • comment
   • April 4, 2021

3. Checkbox Set summation

   By Tracy, April 1, 2021
   • 2 replies
   • 772 views
   • 
   • Tracy
   • April 1, 2021

4. Combining text and container fields in a calculation (or merge field)

   By DragonSyn, March 31, 2021
   • 4 replies
   • 538 views
   • 
   • DragonSyn
   • April 1, 2021

5. Is there an option to fit all when printing or exporting PDF?

   By syedzaidi, March 26, 2021
   • 1 reply
   • 949 views
   • 
   • Ocean West
   • March 26, 2021

6. Show/Hide Button Conditionally.

   By syedzaidi, March 26, 2021
   • 2 replies
   • 749 views
   • 
   • comment
   • March 26, 2021

7. How to get all characters before x from a text with multiple occurrences

   By JohnDing, February 26, 2021
   • 6 replies
   • 597 views
   • 
   • JohnDing
   • March 2, 2021

8. Weird result with Calculated Value

   By millmaine, February 26, 2021
   • 2 replies
   • 462 views
   • 
   • millmaine
   • February 26, 2021

9. Basic math with Multiple values in same field

   By JohnDing, February 11, 2021
   • 2 replies
   • 428 views
   • 
   • JohnDing
   • February 11, 2021

10. Help with a calculation

    By Malcolm99, February 9, 2021
    • 4 replies
    • 674 views
    • 
    • Ocean West
    • February 10, 2021

11. fiscal quarter display problem

    By dysong3, January 31, 2021
    • 1 reply
    • 791 views
    • 
    • comment
    • January 31, 2021

12. Chronologically numbering child records based on date field, auto update upon modification or added/deleted record

    By ehwalker, January 29, 2021
    • 8 replies
    • 613 views
    • 
    • ehwalker
    • January 31, 2021

13. Removing leading spaces in a Calculation field

    By philipcaplan, January 27, 2021
    • 2 replies
    • 492 views
    • 
    • philipcaplan
    • January 27, 2021

14. Getting a total of a certain value in a field in same table?

    By Chrism, January 15, 2021
    • 2 replies
    • 478 views
    • 
    • Chrism
    • January 18, 2021

15. Extract all values with 4 words or more from List of Values

    By innodat, January 11, 2021
    • 2 replies
    • 490 views
    • 
    • innodat
    • January 12, 2021

16. replace the last "," with "and"

    By archrid404, January 11, 2021
    • 1 reply
    • 448 views
    • 
    • comment
    • January 11, 2021

17. Calculation based on related table expiry date

    By Chrism, January 9, 2021
    • 6 replies
    • 744 views
    • 
    • Chrism
    • January 9, 2021

18. Generating two part ID/SKU numbers

    By NtSmedia, January 8, 2021
    • 3 replies
    • 571 views
    • 
    • comment
    • January 9, 2021

19. Calculation Field where the results equals one '$' character for every 100 dollars of value

    By DataCruncher, January 3, 2021
    • 1 reply
    • 477 views
    • 
    • comment
    • January 3, 2021

20. Displaying a total from a related Field

    By Chrism, December 17, 2020
    • 8 replies
    • 620 views
    • 
    • Chrism
    • December 17, 2020

21. Problem converting Excel file to FileMaker.

    By Gilbert13, December 2, 2020
    • 5 replies
    • 621 views
    • 
    • Gilbert13
    • December 2, 2020

22. Help with EXPENSE REPORT Example

    By Bill_misc_IT, November 23, 2020
    • 3 replies
    • 631 views
    • 
    • comment
    • December 1, 2020

23. How can I get a total

    By extreme, November 22, 2020
    • 0 replies
    • 529 views
    • 
    • extreme
    • November 22, 2020

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

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

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

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

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

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

27. Calculation of number certain type of contact per Company

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

28. Xero integration using OAuth 2.0

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

29. How to auto checkmark "Check Boxes"?

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

30. Need help averaging repeating fields

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

31. Determining Date Format when Parsing JSON data?

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

32. Best way to calculate related field total

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

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

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

34. Combining field data under certain conditions

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

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

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