[SOLVED] How to display result of date range on new page?

[darren.james7518]

Hi Bubblers,

I have a page for users to search for paid invoices within a date range. This works and the text below returns the correct result.

My goal is for the ‘Show’ button to open a new page with the same information displayed (Both pages have the same datatype) but I can’t figure out how to send the data to the new page?

When the text result information is on the same page as the date/time picker it is easy, I am searching for results > DatePickerA and < DatePickerB but when I send the info to the new page I am no longer able to search as there are no date pickers.

I don’t want to save the data to DB so how can I send the results to the new page?

Another thing is that the page datatype is ‘invoice’ but the Show button is in the group with data:Date which may be an issue?

[juicebox]

Just pass the date picker values as additional URL parameters when using the ‘Go to page’ action?

Then on the next page, you can use the ‘Get data from URL’ expression to extract them.

[darren.james7518]

@juicebox

Just pass the date picker values as additional URL parameters when using the ‘Go to page’ action?

Then on the next page, you can use the ‘Get data from URL’ expression to extract them

Thanks, here’s what I see when I try and choose data to send. I can’t set the data because the button’s parent is type is Date but the page info is type Invoice? Also, how do I pass the date picker values as additional URL parameters because the issue here is;

t1. he original date pickers are on a single page app (so are in a group)
2. I don’t want to show data pickers on page 2, only the info from page 1’s data pickers

[juicebox]

@darren.james7518

I can’t set the data because the button’s parent is type is Date but the page info is type Invoice?

Not entirely sure why you’re setting the next page as a type of invoice given that it could return a report with multiple invoices based on the date range?

@darren.james7518

Also, how do I pass the date picker values as additional URL parameters?

Look at the last checkbox, send more parameters.

[darren.james7518]

@juicebox

Not entirely sure why you’re setting the next page as a type of invoice given that it could return a report with multiple invoices based on the date range?

I search for ‘invoice’s’ created by Current User

[darren.james7518]

@juicebox

Look at the last checkbox, send more parameters.

Thanks. I am not sure what a ‘key’ is. In fact, I can tell I am completely out of my depth here so I don’t want to waste your time. I will try and find some help files because I may end up asking you 100 questions otherwise!

[juicebox]

@darren.james7518

I search for ‘invoice’s’ created by Current User

Sure, but if you set a page’s data type, it’s expecting one, not multiple.

Doing a search for invoices created by the current user could easily return multiple, right?

I’m just not sure it entirely makes sense in this use case.

@darren.james7518

I am not sure what a ‘key’ is

You’ll need to create two. The first key is ‘from’, the second key is ‘to’. You’ll then select the values as Date Picker A’s value and Date Picker B’s value respectively.

[darren.james7518]

@juicebox

Doing a search for invoices created by the current user could easily return multiple, right?

Yes it will do, but I :sum the total amount and simply display the total figure, ie: you have been paid a total of £100 within the dates chosen.

That said, something tells me I should be using ‘User’ as the data source, I’m not sure.

[darren.james7518]

@juicebox

You’ll need to create two. The first key is ‘from’, the second key is ‘to’. You’ll then select the values as Date Picker A’s value and Date Picker B’s value respectively.

Ok thank you, I will give that a try

[adamhholmes]

@darren.james7518

That said, something tells me I should be using ‘User’ as the data source, I’m not sure.

I can’t see any reason why you need a defined content type at all on your destination page for this, and certainly not User (unless you want Users to be able to share their own, or other Users invoice data with other people).

If you’re only showing the current user their own invoice data then just use ‘current user’ as the constraint on your invoice search on your page, and use the URL parameters for start and end date to show results from the required date range results.

[darren.james7518]

@adamhholmes

I can’t see any reason why you need a defined content type at all on your destination page for this, and certainly not User (unless you want Users to be able to share their own, or other Users invoice data with other people).

If you’re only showing the current user their own invoice data then just use ‘current user’ as the constraint on your invoice search on your page, and use the URL parameters for start and end date to show results from the required date range results.

Ok thank you, that makes sense, I will do that. Try, I don’t need to define content type at all on the destination page.

[adamhholmes]

Something like this should be all you need:

[darren.james7518]

Thanks @adamhholmes that really helped, I was just wondering where to put the Get from page URL and your reply pinged up! I am making good progress, have to pop out but will nail this when back and update you!

[darren.james7518]

The destination page is displaying no data, can you see what I am missing?

The ‘Show’ button:

This is on the destination page:

And if you were to inspect Search for Invoices I am referring to each of the two parameters (just showing one here).

[juicebox]

You’ve used ‘date_from’ and ‘date_to’ when setting the additional parameters but on the destination page you’re looking for ‘paid_from’ and ‘paid_to’. They need to be the same.

[darren.james7518]

Thank you for pointing that out, that fixed it!!