Passing Values Of A Calculated Field To An Actual Field

[Elena]

Hello all,

 

Please help. I will appreciate any advice.

 

I've been trying to pass the values of a calculated field to an actual field in my table. I did scour the entire forum for knowledge and tried everything I could find as methods. So far, none worked for me.

 

I tried these:

 

1) Passing values by hiding the actual field and choosing "Data Source Fields" to receive values. This doesn't work.

 

2) I tried putting a virtual field, hiding it and choosing "on load receive value parameter", choosing the calculated field, then  "on exit pass field value parameter".  Then I used the virtual parameter to load my actual field. This not only did not work, it caused my details to load so very slowly.

 

3) Then I also tried the javascript below.

 

4) I also tried a combination of all of these, with the javascript in the footer.

 

So far, none has worked.

 

 

<SCRIPT LANGUAGE="JavaScript">

function concatenate()
{
var x = document.getElementsByName("[@calcfield:44#]")[0].value;

document.getElementById("InsertRecordNew_Job_Grade").value = x;

}

document.getElementById("caspioform").onload=concatenate;
</SCRIPT>

[svitlanataran]

Hi Elena,

 

I've edited your script. Try it.

 

<SCRIPT LANGUAGE="JavaScript">

function concatenate()
{
var x = '[@calcfield:44]';
document.getElementById("EditRecordNew_Job_Grade").value = x;
}

document.getElementById("caspioform").onload=concatenate;
</SCRIPT>

[Elena]

Hi Matilda,

 

Sorry for the lateness of this response. I will try your edited code today, and post a progress report accordingly.

 

Elena

[jnordstrand]

Hi Guys,

 

I am new to this kind of code.  Will this work to calculate and then pass on hours to a time sheet?  I have a time sheet table and a time sheet report but how would i then get those values of hours back to my "Totals" field in my time sheet table.  

 

Any help would be greatly appreciated.  

 

Thank you,

 

Jeff

[ShelleyK]

I am interested in if this worked. I have a calculated field that I am trying to pass with no luck.

[Aurora]

Hello ShelleyK, 

 

Where do you have Calculated Fields? 

 

This script works on the Details Page.

 

Aurora

[Olfa]

Hi Elena,

if think that you just have to change the on load by onsubmit like this:

<SCRIPT LANGUAGE="JavaScript">
function concatenate()
{
var x = '[@calcfield:44]';
document.getElementById("EditRecordNew_Job_Grade").value = x;
}
document.getElementById("caspioform").onsubmit=concatenate;
</SCRIPT>

Olfa