I have a form that has a field (B) that needs to be filled dynamically from another field’s dialog list (A).
If field B is a computed field then it works – BUT, I need to be able to have the user append text to the end of the pre-filled filed.
Example:
User chooses option 1 from the list on field A. Field B now contains the text “option 1 data-”. Now the user can enter their own data into field B, appended to the end of the text-data that was just inserted dynamically.
Is there a way to accomplish this without using a seperate dialog box?
Thank you for any help.
Subject: Field: Computed vs. Editable
how about a translation formula for field B:
@if(FieldB = “”; FieldA; FieldB)
Subject: RE: Field: Computed vs. Editable
but thats going to stop fieldb changing if the user makes a new selection so you need to extend it using a hidden field oldFieldA
tt:=oldFieldA;
oldFieldA:=fieldA;
@if(tt!=fieldA|FieldB=“”;FieldA;FieldB)
Subject: Field: Computed vs. Editable
Yes, this is very easy.
You can create 3 fields.
First field A is visible, editable, dialog list. User picks one of the predefined value.
Select the “refresh documetns on choice” option.
Second field B is editable and user can enter things into it. You can use the input translation formula to automatically whipe or modify the value if, for instance, field A has not been selected or has changed. You may want to hide field B when field A is empty or has invalid data.
Finally, create a hidden field C, computed, which assocites field A and field B, such as:
@trim (A + B)
and use this hidden value in the various views and other lookup or data reference as required.
You may need to add a little script in the exiting event of field B if you want C to refersh automatically rather than once the documetn is saved.
HTH
Nicolas Abesdris
Quintessence e-solutions Inc.