Calculation Engine (Define Fields)

12,767 topics in this forum

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

   By Bill_misc_IT, Wednesday at 04:34 PM
   • 2 replies
   • 21 views
   • 
   • Bill_misc_IT
   • Wednesday at 05:09 PM

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

   By WF7A, April 15
   • 9 replies
   • 65 views
   • 
   • WF7A
   • Tuesday at 12:14 PM

3. How to get a count summary of past month

   By JohnDing, April 13
   • 2 replies
   • 46 views
   • 
   • JohnDing
   • April 14

4. "Get" text style

   By Asu, April 4
   • 1 reply
   • 37 views
   • 
   • comment
   • April 4

5. Checkbox Set summation

   By Tracy, April 1
   • 2 replies
   • 38 views
   • 
   • Tracy
   • April 1

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

   By DragonSyn, March 31
   • 4 replies
   • 59 views
   • 
   • DragonSyn
   • April 1

7. Find in Progress dialog appears randomly

   By archrid404, March 31
   • 1 reply
   • 52 views
   • 
   • comment
   • March 31

8. Count list of values from Summary list field

   By Sinky, March 24   

   • list
   • summary
   • (and 1 more)

      Tagged with:

     • list
     • summary
     • count
   • 9 replies
   • 112 views
   • 
   • Sinky
   • March 26

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

   By syedzaidi, March 26
   • 1 reply
   • 31 views
   • 
   • Ocean West
   • March 26

10. Show/Hide Button Conditionally.

    By syedzaidi, March 26
    • 2 replies
    • 46 views
    • 
    • comment
    • March 26

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

    By JohnDing, February 26
    • 6 replies
    • 104 views
    • 
    • JohnDing
    • March 2

12. Weird result with Calculated Value

    By millmaine, February 26
    • 2 replies
    • 47 views
    • 
    • millmaine
    • February 26

13. Basic math with Multiple values in same field

    By JohnDing, February 11
    • 2 replies
    • 68 views
    • 
    • JohnDing
    • February 11

14. Help with a calculation

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

15. fiscal quarter display problem

    By dysong3, January 31
    • 1 reply
    • 72 views
    • 
    • comment
    • January 31

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

    By ehwalker, January 29
    • 8 replies
    • 137 views
    • 
    • ehwalker
    • January 31

17. Removing leading spaces in a Calculation field

    By philipcaplan, January 27
    • 2 replies
    • 60 views
    • 
    • philipcaplan
    • January 27

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

    By Chrism, January 15
    • 2 replies
    • 69 views
    • 
    • Chrism
    • January 18

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

    By innodat, January 11
    • 2 replies
    • 90 views
    • 
    • innodat
    • January 12

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

    By archrid404, January 11
    • 1 reply
    • 74 views
    • 
    • comment
    • January 11

21. Calculation based on related table expiry date

    By Chrism, January 9
    • 6 replies
    • 122 views
    • 
    • Chrism
    • January 9

22. Generating two part ID/SKU numbers

    By NtSmedia, January 8
    • 3 replies
    • 99 views
    • 
    • comment
    • January 9

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

    By DataCruncher, January 3
    • 1 reply
    • 71 views
    • 
    • comment
    • January 3

24. Displaying a total from a related Field

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

25. Problem converting Excel file to FileMaker.

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

26. Help with EXPENSE REPORT Example

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

27. How can I get a total

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

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

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

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

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

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

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

31. Calculation of number certain type of contact per Company

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

32. Xero integration using OAuth 2.0

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

33. How to auto checkmark "Check Boxes"?

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

34. Need help averaging repeating fields

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

35. Determining Date Format when Parsing JSON data?

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