Pulling From Two Table Columns In A Datpage

[JustinShilot]

I've set up a basic scores table where column #1 is away team and column #2 is home team.

 

Example:

 

Away Team           Home Team

Ohio                      Pennsylvania
West Virginia         Ohio

 

How can I create a tabular report where I can create a dropdown with all three teams listed as a search option - and my report will show results if that team name was found in either the away or home team column?

 

I'm guessing this is probably really simple, but I'm having a heck of a time figuring it out.  Thanks!

[MayMusic]

You need to separate your search and report and then receive the same parameter for both away and home team in Configure Filtering Fields screen and select if empty ignore criteria

[JustinShilot]

Hmmm... I don't know what you mean by separate my search and report?  Do you mean that I need two separate datapages?

[Jan]

Hello jshilot,

 

If I understand correctly, this article describes separate Search and Results pages.

Yes, two DataPages are required.

 

I hope, it helps.

[JustinShilot]

Thanks Jan and May - I figured it out!

[MayMusic]

You are very welcome!!

[NailDyanC]

Hi, just to update this post. This is the working and updated link for creating a separate search and result: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/