Tip

Inheriting Field Value Into Editable Field

Notes documentation says that you can inherit a field value into another field
"IF" the field type is computed. What if you want it to be an initial value,
but editable?

I encountered this while designing a form that captured overtime values for an
employee. They entered their starting and ending shift times in an initial pair
of fields, then entered starting and ending overtime values into two other
pairs of fields. (One pair for "Before Shift" overtime, and the other for
"After Shift overtime)

I wanted two of the fields to be pre-populated with values from the starting
and ending shift fields. For "Before Shift" overtime, I wanted the stop time to
equal the shift start time, while "After Shift" overtime should have the start
time equal to the shift end time. However, the fields needed to be editable
afterwards.

Fortunately a workaround exists! You can inherit a field value from ANY field
that has a value!

Here is how to build it:
1. Insert a hidden editable text field on your form for each field you want
populated, and give it a default value. For this example, I will use "A".

2. Insert the following code into the INPUT TRANSLATION area of the field you
want to inherit the value.

Here is how it works:
When you fill out the field that contains the desired value you want to
inherit, the input translation for the desired field checks the value of the
hidden field, sees that it is set to "A". Pops the information in, then sets
the value to "D". This allows you to edit the field later if necessary.
@If(Hidden_Field_On_Form =
"A";Field_To_Inherit_Value_From;Field_That_Inherits_Value);
FIELD Hidden_Field_On_Form := "D";

This was first published in November 2000

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.