I am looking at using the Inline editing feature on a List or Library Control and would like to know if the following is possible, and if so would like a little assistance on implementation.
- When adding a new item or editing an item we have a lookup field, can we retrieve the ID of the item selected by the user? (We would then use a REST call to retrieve additional data for the selected item and perform a number of calculations)
- Can we then take the data generated in the above calculations and post these into a specific column for that item.
So in the table above the user selects an item in the Product Code Column (Lookup) and then using a REST call we retrieve the Product Description (Multiple Lines of Text) and Post this into the Product Description Column. The Quantity field is required so the user must enter a number, when a number is entered we then need to perform a calculation to generate a Line List Price from the Cost (retrieved in the above REST call) and then multiply this by the Quantity and then post this into the Line List Price Column.
Is this possible, and if so could I have a few pointers on where to start, at present we are using a dialog to add and edit items and I can see using Inline Editing speeding things up massively for our users.
Thanks in advance