spreadsheet calculations into serviceNow forms

[swathi Gadde]

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)

[mugi-san]

Hi, @swathi Gadde .

If you want to create your own spreadsheet application on ServiceNow, check out the post below.

https://www.servicenow.com/community/developer-advocate-blog/unleash-the-power-of-build-agents-in-th...

regards.

[swathi Gadde]

I need something like the above which you mentioned in your screenshot.. Is it possible to do with out using any build agents/scopped app?

[mugi-san]

Hi, @swathi Gadde .

Unfortunately, the build agent currently only supports scoped applications.

The build agent is implemented using pro-code, not low-code.

If implemented manually,development using the ServiceNow IDE with React UI and TypeScript is required.(only supports scoped applications)

https://www.servicenow.com/docs/ja-JP/bundle/zurich-application-development/page/build/servicenow-id...

Regards.

If you found this post helpful, I would appreciate it if you could click the “Good” button or close the case.

[arunadevi]

Hi Swathi,

Form can be designed in UI Macro or UI Page and Macro/ Page can be call from UI Action using dialog window.

https://www.servicenow.com/community/app-engine-forum/how-to-call-an-ui-page-from-ui-action-in-servi...

https://www.servicenow.com/docs/bundle/xanadu-application-development/page/script/server-scripting/c...