Skip navigation
cc701
cc701
Currently Being Moderated

Making 1 field equal the value of 2 fields.

Jul 27, 2012 12:34 PM

Categories: Windows

How do I make 1 field equal the value of 2 text fields.

 

I've got text field 1 and I need it to equal the value of address field 1 and address field 2.  Essentially, I need what is in address field 1 and 2 to combine to be in one single field, text field 1.

 

Any suggestions?

 

Thanks

524 Views   7 Replies   Latest reply: George Johnson, Jul 30, 2012 10:08 AM
 
Replies
  • GKaiseril
    Currently Being Moderated
    1. GKaiseril,
    Jul 27, 2012 1:10 PM   in reply to cc701
    Report

    Are you summing data or concatenating text strings?

     

    If it is numbers you can use the Calculation Tab'x options of "Field is the _____ of fields:" and select the operation and fields or use the Simplified Field notation if the field names comply the with the requirements for the Simplified Field Notation option.

     

    You can also use the custom JavaScript calculation and use the field names with the "getField" method and the "+" operator to add or concatenate the data. I you do not set the type of value, then JavaScript will make a guess at the type of data, string or numeric, and either concatenate the strings or add the number depending upon how JavaScript has guessed the type of data.

     

    Need help Adding

     
    |
    Mark as:
  • cc701
    Currently Being Moderated
    2. cc701,
    Jul 30, 2012 6:03 AM   in reply to GKaiseril
    Report

    I'm contcatenating text strings.  I used the below getField script but it's not working.  Am I missing something?

     

    this.getFeild("Text1").value = this.getField("FL052").value + this.getField("FL053").value;

     

    FL052 & FL053 are address fields that I'm trying to combine into one field in Text1

     
    |
    Mark as:
  • GKaiseril
    Currently Being Moderated
    3. GKaiseril,
    Jul 30, 2012 8:11 AM   in reply to cc701
    Report

    When in a field and trying to reference it one should use the "event.value' to access the field's value property. The value of the object field is not updated until on leaves the field. I would use:

     

    event..value = this.getField("FL052").value + this.getField("FL053").value;

     

    For the custom calculation script.

     
    |
    Mark as:
  • Test Screen Name
    Currently Being Moderated
    4. Test Screen Name,
    Jul 30, 2012 8:12 AM   in reply to cc701
    Report

    Did you copy and paste this or type it again? I ask because there's a typo.

     
    |
    Mark as:
  • GKaiseril
    Currently Being Moderated
    5. GKaiseril,
    Jul 30, 2012 8:16 AM   in reply to Test Screen Name
    Report

    Becareful when copying and pasting as MS Word Smart Quotes will caus a big problem.

     
    |
    Mark as:
  • cc701
    Currently Being Moderated
    6. cc701,
    Jul 30, 2012 8:31 AM   in reply to GKaiseril
    Report

    No, I did not copy and paste.  I retyped.  It worked.  Thanks for the help!

     
    |
    Mark as:
  • George Johnson
    9,224 posts
    Aug 11, 2002
    Currently Being Moderated
    7. George Johnson,
    Jul 30, 2012 10:08 AM   in reply to cc701
    Report

    If you want to concatenate strings, you should use the valueAsString property when getting the values of fields:

     

    event.value = getField("FL052").valueAsString + getField("FL053").valueAsString;

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points