Add 3 different field and display in a read only field

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
coresoul
Posts: 23
Joined: Tue Feb 24, 2015

10 Mar 2015

i want to Add 3 different number field and display in a read only field. How can i achieve that?

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

11 Mar 2015

Hi,

You can create a calculated column and concatinate these numbers:

https://msdn.microsoft.com/en-us/librar ... e.14).aspx

coresoul
Posts: 23
Joined: Tue Feb 24, 2015

11 Mar 2015

is this going to calculate while you are on the form or calculate only after the form is saved? i need a solution where these numbers are added as user input the numbers. please help

coresoul
Posts: 23
Joined: Tue Feb 24, 2015

11 Mar 2015

function updateSum() {

var a = parseFloat(fd.field('Capital').control().value());

var b = parseFloat(fd.field('Expense').control().value());

fd.field('Total_x0020_Investment_x0020_to_').control()._el().html(a + b);

}


// updates calculated field value when value of field A is changed.

fd.field('Capital').control().change(function() {

updateSum();

});


// updates calculated field value when value of field B is changed.

fd.field('Expense').control().change(function() {

updateSum();

});




This worked for me. but how do i put initial value 0 to the Total_x0020_Investment_x0020_to_ field.

I want to add '$' sign infront of sum.

if capital and expense is empty i want to show $0 in Total_x0020_Investment_x0020_to_

if user input number like 100,000, i would like to ignore comma (,)

coresoul
Posts: 23
Joined: Tue Feb 24, 2015

12 Mar 2015

never mind i did this myself. thanks

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests