Calculations and Define Fields

1,804 topics in this forum

1. Simple "If" calculation

   By smb avi, June 8   

   • fmp 12
   • 0 replies
   • 38 views
   • 
   • smb avi
   • June 8

2. Search for latest occurrence

   By Randy Bricker, May 2   

   • calculations
   • 5 replies
   • 56 views
   • 
   • Randy Bricker
   • May 23

3. Long text calc for JSON randomly drops text elements

   By naplesweb, May 6
   • 1 reply
   • 43 views
   • 
   • naplesweb
   • May 20

4. Calculation for a conditional based on groups in a portal

   By JammerHammer, May 14
   • 0 replies
   • 29 views
   • 
   • JammerHammer
   • May 14

5. Calculation Based on Multiple Portal Line Entries

   By agian510, May 4
   • 0 replies
   • 26 views
   • 
   • agian510
   • May 4

6. Can I copy a field within layouts/individual records display different values

   By agian510, April 22
   • 2 replies
   • 164 views
   • 
   • agian510
   • May 2

7. Average of

   By Rui Gonçalves, April 26
   • 1 reply
   • 36 views
   • 
   • Techphan
   • April 29

8. Using Field from NextRecord in CurrentRecord Calculation

   By DeLuca, April 24   

   • set field
   • get field
   • 2 replies
   • 133 views
   • 
   • DeLuca
   • April 25

9. How to add parentheses to part of a Calc field

   By Tapper, February 20
   • 5 replies
   • 284 views
   • 
   • AHunter3
   • April 16

10. Change date format

    By steve5504, March 27
    • 3 replies
    • 268 views
    • 
    • Techphan
    • March 31

11. Future Date

    By page19, March 25
    • 6 replies
    • 257 views
    • 
    • page19
    • March 26

12. Millisecond Unix timestamp human conversion craziness

    By naplesweb, March 2
    • 7 replies
    • 433 views
    • 
    • naplesweb
    • March 17

13. How to make calculation for file on my attachment?

    By W4hyu213, March 9
    • 1 reply
    • 152 views
    • 
    • Josh Ormond
    • March 14

14. Average Age over several records

    By ClinicArt, March 7   

    • average
    • 4 replies
    • 249 views
    • 
    • AHunter3
    • March 13

15. Make total with summary or calculation, file in attachment

    By W4hyu213, March 9
    • 2 replies
    • 191 views
    • 
    • W4hyu213
    • March 10

16. Auto population of a field based on 2 other dynamic value lists

    By hopey8574, February 6   

    • dynamic
    • value lists
    • 0 replies
    • 105 views
    • 
    • hopey8574
    • February 6

17. Financial calculation based on date of transaction

    By derlandson, January 12, 2019
    • 1 reply
    • 583 views
    • 
    • Techphan
    • January 13, 2019

18. Repeating Alphanumeric Strings

    By dztrucktion, October 27, 2018
    • 5 replies
    • 175 views
    • 
    • dztrucktion
    • October 30, 2018

19. Time calculation

    By TanyaI, July 11, 2018
    • 3 replies
    • 241 views
    • 
    • TanyaI
    • July 13, 2018

20. Summary (total) of number field for all records (not just found records)?

    By David Gadd, June 4, 2018   

    • filemaker
    • summary field
    • (and 1 more)

      Tagged with:

      • filemaker
      • summary field
      • all records
    • 3 replies
    • 259 views
    • 
    • Steve Martino
    • June 10, 2018

21. Lock a Radio Button

    By Kishan, April 30, 2018   

    • filemaker radio button
    • lock radio button
    • 2 replies
    • 326 views
    • 
    • Kishan
    • May 5, 2018

22. age with competition

    By mbk28, April 20, 2018
    • 6 replies
    • 293 views
    • 
    • Techphan
    • April 23, 2018

23. Need help with calculating implementation date

    By Carlos F. Martinez, March 12, 2018   

    • date
    • 7 replies
    • 323 views
    • 
    • Carlos F. Martinez
    • March 21, 2018

24. Need help with count calculations

    By Carlos F. Martinez, March 6, 2018   

    • counts
    • 3 replies
    • 346 views
    • 
    • Carlos F. Martinez
    • March 8, 2018

25. External storage for Container Fields

    By torch_55, February 5, 2018   

    • container field
    • external storage
    • 14 replies
    • 1,450 views
    • 
    • Josh Ormond
    • February 16, 2018

26. Finding number of ID's in a large group of records

    By Jabert, December 11, 2017   

    • count
    • data
    • (and 7 more)

      Tagged with:

      • count
      • data
      • date
      • fields
      • layout
      • line
      • multiple
      • record
      • records
    • 1 reply
    • 690 views
    • 
    • iking42
    • December 22, 2017

27. Case - calculate date based on date, age and type criteria

    By Parken26, October 18, 2017   

    • calculate
    • criteria
    • (and 9 more)

      Tagged with:

      • calculate
      • criteria
      • currentdate
      • date
      • display
      • field
      • function
      • future
      • let function
      • multiple
      • portal
    • 11 replies
    • 1,227 views
    • 
    • Parken26
    • October 21, 2017

28. Filled-In Fields From Related Records

    By CBarnes, July 4, 2017   

    • arial
    • calculation
    • (and 13 more)

      Tagged with:

      • arial
      • calculation
      • data
      • fields
      • fill
      • list
      • record
      • records
      • related
      • related record
      • related records
      • system
      • table
      • tables
      • text
    • 1 reply
    • 1,153 views
    • 
    • AHunter3
    • July 5, 2017

29. Summary field not working as it should

    By JamieChriso, May 17, 2017   

    • calculate
    • calculation
    • (and 8 more)

      Tagged with:

      • calculate
      • calculation
      • copy
      • field
      • layout
      • newbie
      • pos
      • records
      • report
      • summary
    • 3 replies
    • 807 views
    • 
    • David Head
    • May 23, 2017

30. Do a sequential lookup/calc from a csv list

    By JohnGG, February 19, 2017   

    • list
    • lookup
    • (and 1 more)

      Tagged with:

      • list
      • lookup
      • zip codes
    • 3 replies
    • 971 views
    • 
    • JohnGG
    • February 20, 2017