Hello,
I need to create something like below on the servicenow form. when the UI action button is clicked it should show this form and with user needs to enter quantity and it should calculate the total sum and update the field on the parent record with the total sum. Is there any way to achieve it?
| Description | quantity | fees |
| Books | | if(b2>=10, cost is 500 , if (b2 >=15 cost is 800) |
| School uniform/other | | if(b3>1,then cost is b3*900) |
| Sports | | if(b4>=1 then 0 |
| extra activities | | sum(b51000) |
| special events | | sum(b6*500) |
| Total Due | | sum(C2:C6) |
