Custom Field to combine two fields without calculating

I am trying to create a new Field "ReferenceID" that will combine, but not compute the two fields: Candidate and JobRequisition. I've tried several things but can't get both fields to be "one". Most of the time I get errors on creating a derived field, but I have never done one before so I am not sure what the error means. I was able to get one field with the Candidate just a text as "Candidate" and the job requisition as it's value, but that's about it.

I have looked at the user guides but don't really understand how to build the derived field.

Example: If Candidate is 56788 and JobRequisition is 2735, I want the field to display: 567882735.

Can anyone assist? It would be greatly appreciated.

Thank you!

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Comments

don-peterson

Does this work for you?

(This is for a Financial form as I don't have access to GHR, but the same theory should apply.)

For this one, the BankAccountNumber is 4876540098

And the FinancialInstitution is 122105524

Add a new user field

Define it as a Derived field

Give it a Type of Alpha and size it to allow for max possible.

Enter the definition as

return (BankAccountNumber + FinancialInstitution)

Then add the derived user field to the form.

The derived field returned: 4876540098122105524

Don

Dr. Awesome

Without a delimiter how will anyone know when one ends and the other begins? Over time this seems problematic.

monthly_proactive_com201101.pdf

infor

It keeps putting spaces in my lpl and doing calculations

The LPL:

JobApplication is a BusinessClass

owned by Recruiting

Derived Fields

RefID is a DerivedField

type is Alpha size 15

return (Candidate + JobRequisition)

My results keep coming back adding the Candidate number and JobRequistion number and displaying as follows:

For Candidate 49442, Job Req 2751 the created field displays as: 52193.000000000

infor

I'm not sure it will matter here. We are using this for Assessments. We will be sending both the candidate and the jobrequisition number in separate fields, but we also need a unique field for the candidate and the job they are applying for, referred to as the ReferenceID. Therefore, the Candidate number will always be the same for the candidate but the job requisition will change. Knowing this, do you think it will still seem problematic?

don-peterson

If you do a Ctrl-Shift-Click on the Candidate and Job Req fields, what does it show for the field types?

VID016_ICSP and ARSC Lookups_How to narrow results.zip

infor

Yikes. When I go to the JobApplication table the Candidate is Decimal 10,0 and JobRequisition is Int

0911060553270289.pdf

Copyright © 2025 Infor. All rights reserved.