Calculation Engine (Define Fields)

12,881 topics in this forum

1. Empty record

   By Greg Hains, June 30, 2021
   • 6 replies
   • 1.6k views
   • 
   • Greg Hains
   • July 19, 2021

2. Calculate percent change between values in sequential portal rows

   By Bill_misc_IT, July 9, 2021
   • 2 replies
   • 721 views
   • 
   • Bill_misc_IT
   • July 9, 2021

3. Calculated text

   By Amanco, June 19, 2021
   • 4 replies
   • 1.5k views
   • 
   • Amanco
   • June 19, 2021

4. Help with calculating field

   By Nowhere Man, June 18, 2021
   • 5 replies
   • 1.1k views
   • 
   • Nowhere Man
   • June 18, 2021

5. Calculating completed jobs by shift.

   By Plucky, June 10, 2021
   • 3 replies
   • 931 views
   • 
   • comment
   • June 10, 2021

6. Calculate date time frame

   By madman411, May 31, 2021
   • 3 replies
   • 1.7k views
   • 
   • Fitch
   • June 3, 2021

7. Determining rising customer order value

   By Angus McKinnon, May 26, 2021
   • 8 replies
   • 1.3k views
   • 
   • Angus McKinnon
   • May 30, 2021

8. UniqueValues()

   By madman411, May 20, 2021
   • 3 replies
   • 931 views
   • 
   • comment
   • May 20, 2021

9. Validate non zero or null value in ExecuteSQL before division

   By El_Pablo, May 7, 2021
   • 0 replies
   • 570 views
   • 
   • El_Pablo
   • May 7, 2021

10. Find in Progress dialog appears randomly

    By archrid404, March 31, 2021
    • 5 replies
    • 1.5k views
    • 
    • archrid404
    • May 5, 2021

11. Help with calculations for barcode data

    By JOSUAN, May 1, 2021
    • 14 replies
    • 2.2k views
    • 
    • comment
    • May 4, 2021

12. First Occurrence of Unique Values In A List

    By Ron Cates, April 27, 2021
    • 10 replies
    • 2k views
    • 
    • Ron Cates
    • April 28, 2021

13. Calculate the date for the last day of the previous month

    By Bill_misc_IT, April 21, 2021
    • 2 replies
    • 642 views
    • 
    • Bill_misc_IT
    • April 21, 2021

14. Sort timestamps (from child table) in parent table's portal

    By Rich S, April 15, 2021
    • 9 replies
    • 1k views
    • 
    • Rich S
    • April 20, 2021

15. How to get a count summary of past month

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

16. "Get" text style

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

17. Checkbox Set summation

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

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

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

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

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

20. Show/Hide Button Conditionally.

    By syedzaidi, March 26, 2021
    • 2 replies
    • 1k views
    • 
    • comment
    • March 26, 2021

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

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

22. Weird result with Calculated Value

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

23. Basic math with Multiple values in same field

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

24. Help with a calculation

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

25. fiscal quarter display problem

    By dysong3, January 31, 2021
    • 1 reply
    • 1.2k views
    • 
    • comment
    • January 31, 2021

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

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

27. Removing leading spaces in a Calculation field

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

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

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

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

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

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

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

31. Calculation based on related table expiry date

    By Chrism, January 9, 2021
    • 6 replies
    • 1.1k views
    • 
    • Chrism
    • January 9, 2021

32. Generating two part ID/SKU numbers

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

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

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

34. Displaying a total from a related Field

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

35. Problem converting Excel file to FileMaker.

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