Calculations and Define Fields

1,796 topics in this forum

1. Change date format

   By steve5504, Friday at 10:02 PM
   • 3 replies
   • 138 views
   • 
   • Techphan
   • 19 hours ago

3. Future Date

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

4. Millisecond Unix timestamp human conversion craziness

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

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

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

6. Average Age over several records

   By ClinicArt, March 7   

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

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

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

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

   By Tapper, February 20
   • 4 replies
   • 206 views
   • 
   • Tapper
   • February 21

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

   By hopey8574, February 6   

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

10. Financial calculation based on date of transaction

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

11. Repeating Alphanumeric Strings

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

12. Time calculation

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

13. 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
    • 244 views
    • 
    • Steve Martino
    • June 10, 2018

14. Lock a Radio Button

    By Kishan, April 30, 2018   

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

15. age with competition

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

16. Need help with calculating implementation date

    By Carlos F. Martinez, March 12, 2018   

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

17. Need help with count calculations

    By Carlos F. Martinez, March 6, 2018   

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

18. External storage for Container Fields

    By torch_55, February 5, 2018   

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

19. 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
    • 685 views
    • 
    • iking42
    • December 22, 2017

20. 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,213 views
    • 
    • Parken26
    • October 21, 2017

21. 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,141 views
    • 
    • AHunter3
    • July 5, 2017

22. 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
    • 794 views
    • 
    • David Head
    • May 23, 2017

23. 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
    • 957 views
    • 
    • JohnGG
    • February 20, 2017

24. Normalizing table with too many fields

    By nextgen, February 13, 2017   

    • create record
    • database
    • (and 14 more)

      Tagged with:

      • create record
      • database
      • field
      • fields
      • filemaker
      • filemaker server
      • internet
      • layout
      • multiple
      • multiple tables
      • record
      • related
      • relationship
      • server
      • table
      • tables
    • 5 replies
    • 1,220 views
    • 
    • nextgen
    • February 17, 2017

25. Serial Number based on Customer

    By jjfm90, January 12, 2017   

    • auto enter
    • contacts
    • (and 7 more)

      Tagged with:

      • auto enter
      • contacts
      • field
      • find
      • line
      • relationships
      • serial
      • serial numbers
      • tables
    • 2 replies
    • 1,224 views
    • 
    • AHunter3
    • January 13, 2017

26. Find which 'values' are still missing.

    By Dannygast, December 17, 2016   

    • calculations
    • clear
    • (and 10 more)

      Tagged with:

      • calculations
      • clear
      • color
      • content
      • count
      • field
      • find
      • missing
      • records
      • relation
      • relationships
      • tables
    • 4 replies
    • 1,102 views
    • 
    • Maarten Witberg
    • December 18, 2016

27. Percentage of various results

    By mrkstpls@gmail.com, September 4, 2016   

    • calculation
    • field
    • (and 4 more)

      Tagged with:

      • calculation
      • field
      • fields
      • record
      • records
      • summary
    • 2 replies
    • 1,219 views
    • 
    • mrkstpls@gmail.com
    • September 7, 2016

28. Way to sort (or rearrange) numbers in a field

    By TPAairman, August 4, 2016   

    • calculation
    • field
    • (and 1 more)

      Tagged with:

      • calculation
      • field
      • sort
    • 1 reply
    • 855 views
    • 
    • AHunter3
    • August 5, 2016

29. Sorting related records when using GetNthRecord

    By aengineer, June 4, 2016   

    • alphabetical
    • display
    • (and 12 more)

      Tagged with:

      • alphabetical
      • display
      • field
      • portal
      • records
      • related
      • related data
      • related records
      • report
      • sort
      • sorting
      • source table
      • structure
      • table
    • 2 replies
    • 1,639 views
    • 
    • aengineer
    • June 5, 2016

30. Calculations for conditional formatting

    By dgmorin, May 29, 2016   

    • calculation
    • calculations
    • (and 7 more)

      Tagged with:

      • calculation
      • calculations
      • color
      • conditional
      • conditional formatting
      • field
      • format
      • formatting
      • popover
    • 1 reply
    • 1,345 views
    • 
    • doughemi
    • May 29, 2016

31. New database design

    By gobet, May 13, 2016   

    • calculate
    • design
    • (and 4 more)

      Tagged with:

      • calculate
      • design
      • engine
      • formula
      • important
      • tables
    • 0 replies
    • 717 views
    • 
    • gobet
    • May 13, 2016