These instructions changes item to auto number. You could make a new field, but since you used the item field, I will too.
Click File, Manage, Database, change to table Invoice data, double click the item field, under auto-enter click calculated value, then use this calculation
get(RecordNumber) , click ok, ok, ok.
You don't want to allow the user to enter into this field. Click the Item field in edit mode, then from the inspector under the data tab, then under behavior and under field entry uncheck browse mode.
A record is created as you enter data into one of the fields which will display the record number under item.
S Chamblee's way is a good way to do this, but if you have a large number of items on your portal you always have to scroll to the bottom to see the highest amount.
Here's another way to do this so you have one field on your invoice that shows you the amount of line items on your invoice.
Go to "File" - "Manage" - "Database"
Choose the second tab "Fields" and go to the "Invoice Data" table by using the dropdown.
Add a new field at the bottom:
Field Name: s_Count
In the dialogue choose "Count Of" and then choose the "Invoice IS Match Field"
Click Ok and OK.
On your Invoice Details layout go into Layout mode. (View - Layout Mode)
Then from the toolbar at the top choose the Field tool (third from the right) and drag it to your layout. It will allow you to add a field on your layout.
Put it somewhere where you have some place, like right under the Date field (you might have to move some fields around)
And choose the newly created s_Count field from the Invoice Data field as the field you want to add. (Check "create label" at the bottom)
Change the s_count label into something more appropriate.
Now when you add a line item and you are still editing the line item the count field won't update, but when you click outside ogf the portal it will show you the correct amount of items.
Don't forget that you can also just add the symbol for the record number via the Insert menu and the text tool to the portal row and also to the print layout for printing the layouts. This auto-numbers each line and you don't have to add any fields to your database.
I forget about those symbols alltime.
I tried the option by S Chamblee and by PhilModJunk. I liked the option by Phil because it involved not allowing the user to have access to any fields, something I'm a fan of. By when I did, I couldn't get the RecordNumber to show up on the print invoice. The option by S Chamblee also worked fine, and that is the one I'm going with. Thanks guys for your help!
I couldn't get the RecordNumber to show up on the print invoice
Did you modify the layout the starter solution uses to print the invoice? This change would need to be made on both data entry and print layouts.
Yes I made the alterations on the 'Print/Send Invoice' page as well as the 'Invoice Data' page. The Invoice Data worked great, but whenever I would go use the link to 'Print Invoice',the window that would pop up would have the 'RecordNumber' spot blank.
Don't see why that would be the case. I would double check how you modified the layout.