Hi everyone,
I have created a form where, I am using a multi-page wizard so in my first page (let's call it, page1) I have a data-grid component (lets call it DG1) and in another page (page2) I have another data-grid component (DG2) , page2 is more like an overview page, so I want to display the data from DG1 on the DG2 component automatically (basically, whatever fields i have selected (in the share-point component values) and typed in the text-field or number component, I want them to be displayed). Is it possible to achieve it, If yes, how should i go for it.
Moreover, I have another form where I have a data-grid component inside it I have a number and text field component , I want both of them to behave like if the user has written anything in those fields in the first row of the data-grid component I want the second row of data-grid component to have the same values written in that number and text-field component.
Any suggestions would be helpful :)
Many thanks!
Hi everyone,
I have a form where I have a data-grid (DG) component inside and in that DG component I have a number and text field component , I want both of them to behave like if the user has written anything in those fields in the first row of the data-grid component I want the second row or any rows added of that same data-grid component to have the same values written in that number and text-field component.
Any suggestions would be helpful!
Thanks
Hi everyone,
I am trying to filter out the options from one SharePoint data component which is inside the data grid component. In my SharePoint data component i have used an excel file where i am displaying numbers lets say from 1 to 30. Moreover, the user can have multiple values in it. For example, the user selected 2, 4 and 6 numbers from first row of data grid component from the SharePoint data component now what i want to achieve is that in the second row of data grid component in the SharePoint data component those three numbers (2, 4, 6) should not be displayed. How do i achieve this any suggestions would be useful.
Many thanks!
Hi there,
I am facing an issue where i want to update the outstanding quantities dynamically by using two methods, I am not sure on how to go about it, any suggestions would be helpful.
I have a form where a user has to select the purchase number from the list (data from sheet1) where the user can see:
- RequestNo, (like orderID)
- PO number (list where he can select the po number),
- Received date (automatically input when logged in),
- Items (from sheet1)
- Ordered quantity (from sheet1),
- Received quantity (manually type),
- Outstanding quantity (dynamically change)
So, when the form is submitted it will save in sheet2 like this (shown in image):
I want to achieve the result like above in excel sheet which is like that whenever there's new order to be added from form submission it should dynamically look in sheet2 if there's any existing entry of that same po number then it should calculate the outstanding quantities dynamically (previous outstanding quantity - current received quantity).
For now I am at that stage where i can display the latest outstanding quantities from sheet2 but i am facing an issue if the entry doesn't exist then it is showing on the form and excel like:
(Which is displaying wrong as it should calculate outstanding quantity normally with the subtraction of ordered qty - received qty.)
And, if i use calculate value under data tab in outstanding qty as:
value = row.orderedQty - row.receivedQty
then it will display correctly on form for first entry as:
But, let's say i received the same items of same po number after two weeks, then on form its displaying as:
As you can see that, the fourth row should display: 1, instead of displaying: 3
How can i achieve the result of first table so that whenever there's no entry it should look in excel sheet2 then automatically subtract normally for the first entry from form submission but if a user receives the delivery for the second time of the same po number then it should look in sheet2 and display the latest previous outstanding qty in sheet2 on the form and accordingly calculate the value of it when items were received for the second time.
I have created three forms which are linked to one another, in which first form takes the input of supplier name and based on selected supplier, the user can select the items sold by that particular supplier For eg, Dell (supplier) sells Mouse, keyboard, Monitor, Laptop (Items sold by dell supplier which will be shown in items list) and when the user submits it'll add entry to excel as:
OrderID | Supplier | Items ordered | Quantity
01 | Dell | ["Mouse","Keyboard","Monitor","Laptop"] | [2,3,1,5]
Now in second form there is orderID drop down list and when the user selects the ID - 1, he can input the purchase order number, which will shown in same excel sheet and adds the purchase number as:
OrderID | Supplier | Items ordered | Quantity | Purchase Number
01 | Dell | ["Mouse","Keyboard","Monitor","Laptop"] | [2,3,1,5] | PN-0001
My query is that====>Now, In my last form i want to show these items in separate rows for eg, the user ordered 2-mouse, 3-keyboard, 1-monitor, 5-laptop SO, i want to display these as:
OrderID | Supplier | Items ordered | Quantity | Purchase Number
01 | Dell | "Mouse" | 2 | PN-0001
01 | Dell | "Keyboard" | 3 | PN-0001
01 | Dell | "Monitor" | 1 | PN-0001
01 | Dell | "Laptop" | 5 | PN-0001
Because, based on the above table in excel in third form i have third input field where i have to write the received quantity like how much quantity of items the user received and corresponding to the items it should display the input field.