Two methods suggest themselves, based on what you describe. For both methods, you would create three global fields: StartDate, EndDate and EventType.
Enter the desired data into the three global fields, then use this data as your search criteria in your script. For the Date search, you would enter into the date field you are searching on the dates as a range (StartDate … EndDate). This will deliver a found set of records to display as you choose.
Build a relationship using the three global fields, and use a portal based on this relationship to display all matching records.
Hi - thanks for your reply and suggestions.
I hear a lot about global variables, but I don't see how I can change the setting on a major table to GLOBAL on 3 columns that contain lots of different values (e.g. dates)
e.g. EVENTDATE EVENT_TYPE
If I changed these to Global, they would all contain the same data
On my portal header I have inserted two EVENTDATE date drop downs and one event_type drop down, and want to put the selected values from these (startdate, enddate and event_type) into variables that can be used as criteria in Perform Find
And I still don't see how to build a relationship between fields in a table and a layout. :/
Hi - thanks a lot for the demo solution.
I have posted my solution, and there is still nothing showing in the portal when you do the search. I didn't know how to attach a solution to a reply here, so it's a separate post. Any help would be much appreciated.