How to add link to list page

1. List page - how to add a link to my own page to enter qty and display item?
   
2. Send email with results.
   Thanks in advance.
   

Hello Frank;
You can define a one vista, where one field is the item and the other field the qty. In the Add page, the user put de qty. And in the events, after load or other, you can send the mail with the information.
It is one way but I do not if it is ok for your needs.
Aleix

I am not sure I understand you.
I do not want to save any data, just have user select the item, enter qty and email results.
Thanks

Frank,
you can create custom view on the Datasource tables tab, use add page of this view to select product and enter quantity.

Then check selected values in the Before record added event, send email and redirect to the main table. In this case new record won't be added to the database.

Hi Jane,
I do not want to save the orders record if necessary.

I want a link on the inventory list that pulls the values from the selected record and presents a form for them to enter the qty.
Else
If I create an orders table, I want the selected record to populate the orders record to save.
I am having trouble getting the pkey from the inventory when I add a link on each record.
I also do not know how to create a form without using a database, so I am thinking it would be eaiser to link to the orders table from inventory.
My main problem is not knowing what fields to use to pull the pkey.
If I use the orders table, I need to have them comit the order and not allow editing.
Orders table to items table.

Thanks

I just found out that on the inventory list page, they want to enter the qty next to each item and then press a button and have those records saved.
What is the best way to add a field to the list row that is not in the database?

Can anyone help me on this?
I want to add a qty field to the list that is not in the database and when a user presses a button, I process all entries on that page that have a qty in them.
Thanks

Frank,
you can add dummy field in the SQL query on the Edit SQL query tab:

Then set up dummy_field as custom on the "View as" settings dialog on the Visual Editor tab.
To add new button to process selected records on the list page use custom event:

http://www.xlinesoft.com/phprunner/docs/update_multiple_records.htm

Jane,
My custom is echo "<input type='text' maxLength='2' name='qty'>";
The select is:
select ProductCode, ProductCode as Qty
I see the productCode values in qty.

The list shows the qty field, but I cannot enter any data.
Thanks

Frank,
I recommend you to publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

Well...Great link helped me a lot.Thanks for sharing with us.

Thanks for posting this link. It is very useful for me.