Related Items Sum

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
jennifer_little
Posts: 10
Joined: Fri Mar 03, 2017

22 Mar 2017

Hi Dmitry,

I still cant get the total to work even by looking at your solution above. See below the example:

Costs

£838
£1257
£754.20
£754.20
£754.20
£2095.00
£493.56

The total is being displayed as 2,349. The total is incorrect.

Many thanks for your help!

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

22 Mar 2017

Hi,
Could you open the browser console (F12) and enter the following line:
fd.relatedItems(0).data('ctx').ListData.Row[0]

Expand the object and provide its content.

jennifer_little
Posts: 10
Joined: Fri Mar 03, 2017

22 Mar 2017

Where would I enter the line? I am in the Developer Tool (F12)?

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

22 Mar 2017

In the Console tab, see my screenshot.
Attachments
Console.png
Console.png (30.56 KiB) Viewed 2436 times

jennifer_little
Posts: 10
Joined: Fri Mar 03, 2017

22 Mar 2017

Would I open the list where the field is before hitting F12?

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

22 Mar 2017

Yes, open the form containing the Related Items control, click F12, switch to Console tab, and insert the code.

jennifer_little
Posts: 10
Joined: Fri Mar 03, 2017

22 Mar 2017

Its coming back as 'fd' is undefined

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

22 Mar 2017

I assume that you open the form in a dialog. Try to open it in the main window and try again.

jennifer_little
Posts: 10
Joined: Fri Mar 03, 2017

22 Mar 2017

Please see screenshot attached.

Thanks
Attachments
screenshot.png
screenshot.png (17.32 KiB) Viewed 2435 times

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

22 Mar 2017

Could you scroll down a bit? There should be a field with Total_x0020_cost. name containing a number without symbol of currency.

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 18 guests