Add More Tables To Search
SearchResults.AddMoreTablesToSearch History
Hide minor edits - Show changes to output
Changed lines 3-4 from:
to:
!!Adding Tables 3 and 4.
Changed lines 7-8 from:
to:
!!Adding More than 4 Tables.
Changed lines 3-4 from:
to:
!!!Adding Tables 3 and 4.
SearchResults ships with support to search 4 different tables, so all you need to do for the next two is create layouts for them like you did for Table01 and Table02. Then edit the script "Search", finding the comment "Perform search in each context" and editing the Go To Layout steps that follow to point to your Table03 and Table04 layouts.
!!!Adding More than 4 Tables.
SearchResults ships with support to search 4 different tables, so all you need to do for the next two is create layouts for them like you did for Table01 and Table02. Then edit the script "Search", finding the comment "Perform search in each context" and editing the Go To Layout steps that follow to point to your Table03 and Table04 layouts.
!!!Adding More than 4 Tables.
Changed lines 1-4 from:
!! How can I search on more than the four tables mentioned in the Integration instructions?
SearchResults ships with support to search 4 different tables,but you can easily extend it to search more than that. Here's how...
SearchResults ships with support to search 4 different tables,
to:
!! How can I search on more than the two tables mentioned in the Integration instructions?
SearchResults ships with support to search 4 different tables, so all you need to do for the next two is create layouts for them like you did for Table01 and Table02.
If you need to search more than the 4 tables SearchResults is prepped for, you can easily extend it to search additional tables. Here's how...
SearchResults ships with support to search 4 different tables, so all you need to do for the next two is create layouts for them like you did for Table01 and Table02.
If you need to search more than the 4 tables SearchResults is prepped for, you can easily extend it to search additional tables. Here's how...
Changed lines 1-2 from:
!! How can I search on more than the two tables mentioned in the Integration instructions?
to:
!! How can I search on more than the four tables mentioned in the Integration instructions?
Changed lines 15-16 from:
'''6.''' We're almost done. Edit the script "Search" and find the section following the comment "Perform Search in each context." And a new set of "CONTEXT" lines:
to:
'''6.''' We're almost done, just a couple scripts to edit. Edit the script "Search" and find the section following the comment "Perform Search in each context." And a new set of "CONTEXT" lines:
Added lines 20-27:
'''7.''' Edit the script "Integration Setttings".
-> Find the comment "Name your contexts" and create a new set variable line for your new context. In our example this would set the variable "$$sr Context 05" (without the quotes) to "Payments".
-> Find the comment "Select which layouts to use when clicking on results: Form Views" and add an Else If() for your new context, going to which ever layout in your file represents a form view of a record from your new context (a payment form view in this example).
-> Do the same thing a few lines below after the comment "Select which layouts to use when clicking on results: List Views".
-> Find the comment "Name your contexts" and create a new set variable line for your new context. In our example this would set the variable "$$sr Context 05" (without the quotes) to "Payments".
-> Find the comment "Select which layouts to use when clicking on results: Form Views" and add an Else If() for your new context, going to which ever layout in your file represents a form view of a record from your new context (a payment form view in this example).
-> Do the same thing a few lines below after the comment "Select which layouts to use when clicking on results: List Views".
Changed lines 13-20 from:
'''5.''' Point the fields on this layout at the relevant fields from your table, just as you did when originally integrating the file. If you don't remember doing this, you were following step 7 in the [[Integration]] instructions.
to:
'''5.''' Point the fields on this layout at the relevant fields from your table, just as you did when originally integrating the file. If you don't remember doing this, you were following step 7 in the [[Integration]] instructions.
'''6.''' We're almost done. Edit the script "Search" and find the section following the comment "Perform Search in each context." And a new set of "CONTEXT" lines:
-> A Go to Layout step that goes to "Table05", and
-> A new Perform Script step that calls the "Search - Iterate" script with the parameter "05".
'''That's it!'''
'''6.''' We're almost done. Edit the script "Search" and find the section following the comment "Perform Search in each context." And a new set of "CONTEXT" lines:
-> A Go to Layout step that goes to "Table05", and
-> A new Perform Script step that calls the "Search - Iterate" script with the parameter "05".
'''That's it!'''
Changed lines 11-13 from:
'''4.''' Now go to your original copy of SearchResults (email us if you need a fresh copy), enter layout mode, and select all the contents of the Table00 Template layout. Copy this and paste it into the new layout from step 3. Click "OK" if FileMaker wants to expand the size of the layout.
to:
'''4.''' Now go to your original copy of SearchResults (email us if you need a fresh copy), enter layout mode, and select all the contents of the Table00 Template layout. Copy this and paste it into the new layout from step 3. Click "OK" if FileMaker wants to expand the size of the layout.
'''5.''' Point the fields on this layout at the relevant fields from your table, just as you did when originally integrating the file. If you don't remember doing this, you were following step 7 in the [[Integration]] instructions.
'''5.''' Point the fields on this layout at the relevant fields from your table, just as you did when originally integrating the file. If you don't remember doing this, you were following step 7 in the [[Integration]] instructions.
Changed lines 5-11 from:
1. If you haven't already integrated SearchResults into your file, do that [[Integration | first]].
2. Open your relationship graph and click the "+" tables button in the lower left to add a new table occurrence to the graph. Select the data table you'd like to search (something like "payments" for instance) and change the table occurrence name to "Search Table 05" (without the quotes) or whatever the next highest SearchResults layout number would be. Click OK to leave the relationship graph.
3. Create a new blank layout in your file and name it "Table05" (without the quotes) and change "Show Records from" to be the new layout you created in step 2 above.
4. Now go to your original copy of SearchResults (email us if you need a fresh copy)and
2. Open your relationship graph and click the "+" tables button in the lower left to add a new table occurrence to the graph. Select the data table you'd like to search (something like "payments" for instance) and change the table occurrence name to "Search Table 05" (without the quotes) or whatever the next highest SearchResults layout number would be. Click OK to leave the relationship graph.
3. Create a new blank layout in your file and name it "Table05" (without the quotes) and change "Show Records from" to be the new layout you created in step 2 above.
4. Now go to your original copy of SearchResults (email us if you need a fresh copy)
to:
'''1.''' If you haven't already integrated SearchResults into your file, do that [[Integration | first]].
'''2.''' Open your relationship graph and click the "+" tables button in the lower left to add a new table occurrence to the graph. Select the data table you'd like to search (something like "payments" for instance) and change the table occurrence name to "Search Table 05" (without the quotes) or whatever the next highest SearchResults layout number would be. Click OK to leave the relationship graph.
'''3.''' Create a new blank layout in your file and name it "Table05" (without the quotes) and change "Show Records from" to be the new layout you created in step 2 above.
'''4.''' Now go to your original copy of SearchResults (email us if you need a fresh copy), enter layout mode, and select all the contents of the Table00 Template layout. Copy this and paste it into the new layout from step 3. Click "OK" if FileMaker wants to expand the size of the layout.
'''2.''' Open your relationship graph and click the "+" tables button in the lower left to add a new table occurrence to the graph. Select the data table you'd like to search (something like "payments" for instance) and change the table occurrence name to "Search Table 05" (without the quotes) or whatever the next highest SearchResults layout number would be. Click OK to leave the relationship graph.
'''3.''' Create a new blank layout in your file and name it "Table05" (without the quotes) and change "Show Records from" to be the new layout you created in step 2 above.
'''4.''' Now go to your original copy of SearchResults (email us if you need a fresh copy), enter layout mode, and select all the contents of the Table00 Template layout. Copy this and paste it into the new layout from step 3. Click "OK" if FileMaker wants to expand the size of the layout.
Changed lines 3-11 from:
to:
SearchResults ships with support to search 4 different tables, but you can easily extend it to search more than that. Here's how...
1. If you haven't already integrated SearchResults into your file, do that [[Integration | first]].
2. Open your relationship graph and click the "+" tables button in the lower left to add a new table occurrence to the graph. Select the data table you'd like to search (something like "payments" for instance) and change the table occurrence name to "Search Table 05" (without the quotes) or whatever the next highest SearchResults layout number would be. Click OK to leave the relationship graph.
3. Create a new blank layout in your file and name it "Table05" (without the quotes) and change "Show Records from" to be the new layout you created in step 2 above.
4. Now go to your original copy of SearchResults (email us if you need a fresh copy) and
1. If you haven't already integrated SearchResults into your file, do that [[Integration | first]].
2. Open your relationship graph and click the "+" tables button in the lower left to add a new table occurrence to the graph. Select the data table you'd like to search (something like "payments" for instance) and change the table occurrence name to "Search Table 05" (without the quotes) or whatever the next highest SearchResults layout number would be. Click OK to leave the relationship graph.
3. Create a new blank layout in your file and name it "Table05" (without the quotes) and change "Show Records from" to be the new layout you created in step 2 above.
4. Now go to your original copy of SearchResults (email us if you need a fresh copy) and
Added lines 1-3:
!! How can I search on more than the two tables mentioned in the Integration instructions?
Adding new tables to search is easy. Here's how...
Adding new tables to search is easy. Here's how...