nuBuilder Forum

Hello,

I have an invoice form in which I have a list of invoice as following :
- date, product Name, quantity, Unit Price, Total price.

I would like to have a dashboard presenting the turnover per day, per month, per year.
I don't know how to perform that.
If anyone has got an example of that kind of stats ...
Many thanks and regards,

Yves

Hi,

You can use embedded Browse forms (object Type "Run", Method "iFrame")

This topic could be helpful:
viewtopic.php?t=12023

To calculate the turnover:

https://sharegpt.com/c/sCOxaiZ

Hello Kev1n,

If I use a run object as proposed, it will work with the request defined in the browse form. In fact we have only one sql request (the one behind the browse form). with the related request on the form I would like to have several requests for one related form. How can we do that ? One for the day, one for the month, one for the year.
Will it be possible to do that ? Do you have an example ?
Many thanks anyway for your help,

Yves

Hello,

I have attached a simple database for this exercice in which I would like to have stats per week, month and year.
database --> Please could you help me to create this dashboard.
Many thanks,

Yves

Should they be created on a separate form? And is your struggle related to creating the objects or creating the SQL?

The requests are applicable on only one specific form. My understanding is that you cannot have multiple requests on only 1 form.
From the same form 'invoice', I would like to retrieve the turnover per day, per week, per month and per year and representing that on a dashboard in the application.
The sql requests aren't my main problem here - maybe it will be, I am not there - : it is more the fact that we cannot have on a same form 3 different SQL requests. It is more a design pb : what is the best way to make some stats (several sql requests on the same table) based on one form and represents the result in nuBuilder.
Many thanks for your help.

Yves

Use a launch form and place on it as many run (iframe) objects as you want?

Is it possible to have several SQL requests on the same form via run(iframe) ? My understanding is that we have only 1 request per form (browse tab). Am I wrong ?

You can have as many as you want

Do you mean with run(iframe) based on report and not based on form ?