You’re offline. This is a read only version of the page.
Announcements
27
Hi all!
Just wanting to know and try if I can create a data list type where I can input items and quantities through blank tables and make it appear on share point. To explain further, let me show you what I had in mind.
Idea: It is a Ordering Form. I want to input this under my table list.
In the table:
Item No (Which counts the item being inputted)
Description (Describes what is being purchase, i.e., Apple MacBook Pro)
Quantity (To know the number of items being purchase, i.e 100)
Unit Price (To know the price per unit not the total, i.e $1000)
Total Amount (To sum up all the items being purchase, $100,000) *If ever, what formula can I use?*
It should be look like this:
<Dropdown: Currency>
Item No | Description | Quantity | Unit Price | Total Amount
1. | Apple Macbook Pro | 100 | $1,000.00 | $100, 000.00
2. | iPhone 13 | 1000 | $800 | $400,000.00
Total Amount: $ 500,000.00
If ever, i'll be inputting another item (i.e., iPhone 13, 500, $800, $400,000) *How to create another line to input this item* and slider to make it look neat.
After inputting the items, I intended to order, I want to it be sent to my SharePoint which automatically designated them under their own columns (i.e., MacBook pro and iPhone 13 will be under Description Column). *What formula can I use" and if ever i want it to be changed the currencies since i have two different currency, USD and CAD. Also, if it is multi lines, how can I make sure it fits all through the table box.
Thank you in advance as I've been planning and trying to work this out for 2 months now and still can't be able to find it. I can only use data table, yet it is already filtered and undatable.
I also tried using Excel, but data won't read the file so now I'm trying to use SharePoint as my data base.
Share
Report
All responses (
Answers (
