Jump to content
  • 0

Passing Values Of A Calculated Field To An Actual Field


Question

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>

Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

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

Link to post
Share on other sites
  • 0

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
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...