Calculation Engine (Define Fields)

12,872 topics in this forum

1. Syntax to swap repetition values (A[1] = B[2])

   By Hoytopher, April 28, 2018
   • 1 reply
   • 663 views
   • 
   • Lee Smith
   • April 28, 2018

2. Days Since Last Race (record)

   By Poruchan, April 24, 2018   

   • date
   • last record
   • 1 reply
   • 1.7k views
   • 
   • Poruchan
   • April 25, 2018

3. Add Margin % or Selling Price in Stock Management

   By Kishan_Canoo, April 23, 2018   

   • fm12
   • 3 replies
   • 982 views
   • 
   • Lee Smith
   • April 25, 2018

4. Create Folder & Export Container Field In New Folde

   By Anuj Kumar, April 19, 2018   

   • fmp 16
   • export
   • (and 1 more)

      Tagged with:

     • fmp 16
     • export
     • create folder
   • 1 reply
   • 1.5k views
   • 
   • bcooney
   • April 22, 2018

5. Should I script this or can it be calculated

   By Rich, April 9, 2018
   • 10 replies
   • 1.4k views
   • 
   • siroos12
   • April 10, 2018

6. Newly created fields below current selection

   By Ninja, April 4, 2018
   • 4 replies
   • 748 views
   • 
   • Ninja
   • April 4, 2018

7. Field Calculation Recursion Help

   By CCBtx, March 24, 2018
   • 1 reply
   • 707 views
   • 
   • Fitch
   • March 26, 2018

8. Volume Calculations

   By Steve Martino, March 24, 2018
   • 0 replies
   • 661 views
   • 
   • Steve Martino
   • March 24, 2018

9. Calc to remove letter after space

   By Scott Hoffman, March 23, 2018
   • 2 replies
   • 734 views
   • 
   • Lee Smith
   • March 23, 2018

10. Date calculation in portal (remove ?)

    By ash1474, March 21, 2018   

    • getnthrecord
    • date
    • (and 2 more)

       Tagged with:

      • getnthrecord
      • date
      • calculation
      • portal
    • 9 replies
    • 1.9k views
    • 
    • ash1474
    • March 23, 2018

11. Sending Text Messages

    By Bikeman17, March 8, 2018
    • 2 replies
    • 1.9k views
    • 
    • Bikeman17
    • March 8, 2018

12. ValueCount with 2 criteria

    By Nick Drouet, May 12, 2010
    • 3 replies
    • 2.6k views
    • 
    • Lee Smith
    • March 7, 2018

13. Optimizing Slow Unstored Calculated Field Search and Export

    By brokenmouse, March 1, 2018   

    • unstored
    • calculated
    • (and 4 more)

       Tagged with:

      • unstored
      • calculated
      • search
      • export
      • optimization
      • help
    • 3 replies
    • 1.9k views
    • 
    • Fitch
    • March 2, 2018

14. Rounding up

    By shredded, February 27, 2018
    • 5 replies
    • 860 views
    • 
    • Fitch
    • March 2, 2018

15. Compare and Ranking calc

    By Ronnie Higgins, March 1, 2018   

    • ranking
    • compare
    • 0 replies
    • 727 views
    • 
    • Ronnie Higgins
    • March 1, 2018

16. It's been 4 days

    By randsome, February 13, 2018   

    • need help
    • 3 replies
    • 968 views
    • 
    • Fitch
    • February 14, 2018

17. DateTime Stamp

    By "... you mean these fans?", February 9, 2018
    • 4 replies
    • 897 views
    • 
    • "... you mean these fans?"
    • February 9, 2018

18. Calculate values on the layout

    By spand, February 5, 2018
    • 7 replies
    • 850 views
    • 
    • Fitch
    • February 6, 2018

19. Multiple related fields in a record from the same table

    By Hproth, February 4, 2018   

    • relationship
    • related records
    • (and 2 more)

       Tagged with:

      • relationship
      • related records
      • related fields
      • relationships
    • 3 replies
    • 1.1k views
    • 
    • Steve Martino
    • February 5, 2018

20. Enter pay period based on work dates

    By Lea Alexander, January 31, 2018
    • 2 replies
    • 854 views
    • 
    • Fitch
    • February 5, 2018

21. Help Parse Text Calculation

    By beckham, January 30, 2018   

    • calculation
    • 9 replies
    • 1.8k views
    • 
    • Lee Smith
    • January 31, 2018

22. Calculating percentages using summary fields

    By -dp-, January 30, 2018   

    • percent
    • summary
    • (and 1 more)

       Tagged with:

      • percent
      • summary
      • count
    • 6 replies
    • 2.1k views
    • 
    • -dp-
    • January 30, 2018

23. When is 5 not 5?

    By Chuck, January 24, 2018
    • 7 replies
    • 1.3k views
    • 
    • Chuck
    • January 25, 2018

24. ValueList Importing from one field to another

    By Ponderosa, January 23, 2018   

    • value list
    • set field
    • (and 4 more)

       Tagged with:

      • value list
      • set field
      • sorting
      • copy
      • paste
      • filter
    • 4 replies
    • 1.6k views
    • 
    • Lee Smith
    • January 24, 2018

25. Change Time Stamp to Date

    By kcep, January 16, 2018
    • 6 replies
    • 1.8k views
    • 
    • Lee Smith
    • January 17, 2018

26. difference between no index and recalculate

    By jimlongo, January 14, 2018
    • 3 replies
    • 1.3k views
    • 
    • Agnes Riley
    • January 15, 2018

27. Automating Date Lookups

    By Ponderosa, January 8, 2018   

    • calendar
    • date
    • (and 1 more)

       Tagged with:

      • calendar
      • date
      • lookup
    • 5 replies
    • 1.8k views
    • 
    • Ponderosa
    • January 9, 2018

28. Need to create a place to store a "source" for every field of data

    By bcooper, January 8, 2018
    • 11 replies
    • 1.1k views
    • 
    • Lee Smith
    • January 8, 2018

29. How to calculate a day in advance

    By Gilbert13, January 8, 2018
    • 4 replies
    • 1.1k views
    • 
    • Gilbert13
    • January 8, 2018

30. Move characters

    By OneStop, January 5, 2018
    • 2 replies
    • 1.1k views
    • 
    • LaRetta
    • January 6, 2018

31. Removing Characters Past X

    By OneStop, January 5, 2018
    • 2 replies
    • 853 views
    • 
    • OneStop
    • January 5, 2018

32. Years of Service Calculation

    By CKonash, September 26, 2017
    • 5 replies
    • 1.2k views
    • 
    • doughemi
    • December 31, 2017

33. MiddleWords ( (Substitute ( Sym ; "." ; ¶ )) ; 2 ; 1 )

    By suzieyoga, December 22, 2017
    • 6 replies
    • 995 views
    • 
    • Fitch
    • December 28, 2017

34. script elements to delay record creation.

    By CKonash, December 23, 2017
    • 2 replies
    • 1.1k views
    • 
    • CKonash
    • December 26, 2017

35. Getting a calculation to re-evaluate

    By CKonash, December 22, 2017
    • 4 replies
    • 2.7k views
    • 
    • CKonash
    • December 23, 2017