Finding & Searching

3,229 topics in this forum

1. Find returns incorrect result set.

   By CCBtx, Sunday at 06:56 PM
   • 8 replies
   • 66 views
   • 
   • CCBtx
   • Sunday at 10:54 PM

2. Allow read-only users to select specific records from a found set

   By Dono K, April 27
   • 1 reply
   • 99 views
   • 
   • comment
   • April 27

3. Find by one or more ticked Checkbox'd values

   By WF7A, April 20
   • 6 replies
   • 93 views
   • 
   • WF7A
   • April 21

4. Searching for students by belt rank color

   By Jim65, April 16
   • 14 replies
   • 128 views
   • 
   • Jim65
   • April 17

5. [REQ] How to search for duplicate records to clear and only have unique ones in a table?

   By pixi, April 11   

   • duplicate records
   • unique records
   • 1 reply
   • 57 views
   • 
   • pixi
   • April 11

6. Find by another field containing year

   By Sinky, March 31   

   • find
   • date
   • (and 2 more)

      Tagged with:

     • find
     • date
     • year
     • set field
   • 7 replies
   • 87 views
   • 
   • Sinky
   • April 1

7. Find Record

   By milky, March 22
   • 10 replies
   • 169 views
   • 
   • comment
   • March 24

8. Searching data in multiple fields

   By Bikeman17, March 9
   • 3 replies
   • 94 views
   • 
   • bcooney
   • March 12

9. How to clear a check box, after script has ran?

   By 1FilemakerMan, October 26, 2020
   • 5 replies
   • 245 views
   • 
   • comment
   • October 26, 2020

10. Using find mode and empty found sets for faster layout navigation

    By cjl, October 19, 2020
    • 6 replies
    • 286 views
    • 
    • LaRetta
    • October 20, 2020

11. Need help with calculating preceding Monday in FMP 16

    By djeans, October 4, 2020
    • 7 replies
    • 191 views
    • 
    • djeans
    • October 5, 2020

12. Running search / filter based on drop down field

    By Chrism, September 12, 2020
    • 8 replies
    • 143 views
    • 
    • bcooney
    • September 13, 2020

13. Finding across multiple fields again

    By Chrism, September 11, 2020
    • 6 replies
    • 176 views
    • 
    • Chrism
    • September 11, 2020

14. Repeating fields

    By Chrism, September 9, 2020
    • 4 replies
    • 104 views
    • 
    • Chrism
    • September 10, 2020

15. Calculation only looking at top record of Portal

    By Chrism, September 8, 2020
    • 2 replies
    • 121 views
    • 
    • Chrism
    • September 8, 2020

16. Using date fields to make a record a compliant

    By Chrism, September 6, 2020
    • 6 replies
    • 139 views
    • 
    • Chrism
    • September 8, 2020

17. Searching multiple date fields

    By Chrism, September 4, 2020
    • 2 replies
    • 98 views
    • 
    • Chrism
    • September 5, 2020

18. Performing a find based only a portion of a field value

    By feakes, August 28, 2020
    • 4 replies
    • 207 views
    • 
    • feakes
    • August 30, 2020

19. Help creating a find script.

    By AitchB, August 21, 2020
    • 1 reply
    • 171 views
    • 
    • comment
    • August 21, 2020

20. Button for Finding using a Global Field value

    By quattleb, August 18, 2020   

    • Search
    • global fields
    • (and 1 more)

       Tagged with:

      • Search
      • global fields
      • Button
    • 2 replies
    • 117 views
    • 
    • quattleb
    • August 18, 2020

21. member template

    By Robks, July 19, 2020
    • 0 replies
    • 175 views
    • 
    • Robks
    • July 19, 2020

22. Looking for Suggestions on how to Organizing Product Options across Multiple Product Lines.

    By Tony Diaz, July 11, 2020
    • 0 replies
    • 293 views
    • 
    • Tony Diaz
    • July 11, 2020

23. Count records based on specific criteria

    By stan111, July 6, 2020
    • 4 replies
    • 401 views
    • 
    • stan111
    • July 6, 2020

24. Find and constraint find buttons

    By stan111, July 6, 2020
    • 9 replies
    • 418 views
    • 
    • stan111
    • July 6, 2020

25. Copy/display a data cell from one table to another, without deleting it.

    By 1FilemakerMan, June 11, 2020
    • 0 replies
    • 1.1k views
    • 
    • 1FilemakerMan
    • June 11, 2020

26. Selecting random records from found set

    By madman411, June 2, 2020
    • 2 replies
    • 1.3k views
    • 
    • madman411
    • June 2, 2020

27. Find two items from a value list in a report

    By The Missing Man, May 26, 2020
    • 2 replies
    • 1.3k views
    • 
    • The Missing Man
    • May 26, 2020

28. Google Style Search in Drop-down List ?

    By DannA, May 23, 2020
    • 6 replies
    • 1.4k views
    • 
    • DannA
    • May 26, 2020

29. Performing Find on Constrained Set

    By Jarvis, May 10, 2020
    • 2 replies
    • 1.5k views
    • 
    • Jarvis
    • May 10, 2020

30. Finding text within text

    By Greg Hains, April 14, 2020
    • 2 replies
    • 1.7k views
    • 
    • Greg Hains
    • April 14, 2020

31. How do i sort records inside a sub-summary sort?

    By pleiades, March 24, 2020
    • 2 replies
    • 1.5k views
    • 
    • pleiades
    • March 24, 2020

32. Anyway around field validation preventing the use of Find Operators

    By ehwalker, March 24, 2020
    • 7 replies
    • 1.6k views
    • 
    • comment
    • March 24, 2020

33. Searching via Card Window

    By Dimitrios Fkiaras, February 7, 2020
    • 1 reply
    • 1.7k views
    • 
    • mr_vodka
    • March 10, 2020

34. Script find returns error: 500 regardless of date format 1 2

    By ehwalker, December 1, 2015   

    • error
    • error 500
    • (and 2 more)

       Tagged with:

      • error
      • error 500
      • script find
      • date range
    • 35 replies
    • 4.8k views
    • 
    • bcooney
    • March 1, 2020

35. Find Request based on Check Box Set with Similar Name Values

    By CKonash, November 14, 2019
    • 5 replies
    • 1.8k views
    • 
    • comment
    • February 25, 2020