Hello. I made a layout listing all records from a table. It has a calculated field which collects the record date from the history table.

I need to open a new window from the dashboard I made with this layout. I know how that can be done. I have two fields in the temp table (don't know if thats correct) which isn't linked. The fields are global date named start_dt and end_dt.

With the script to open the report you can enter the two dates (may change but the flow remains the same). The result must only be the records where the date is between start and end.

I can't get this done. Any ideas how to solve it? So the script must collect the start and end in put and return the layout.

Upload the file so we can get a better understanding of what you want to do...

I am going to assume that the history table and the main records table is related. If so, you do not need to use your collection field.

Go to layout ["History"]

Enter Find Mode []

Set Field [ YourDate; start_dt & ".." & end_dt ]

Perform Find []

Go to Related Record [ Show Related Only; Match Found Set; "YourMainTable" ]

Now you have your found set to run the report from.

Thanks. That's doing it. My script was nearly the same, but the get records wasn't right