how to access value by formula

I tried to set and access the value stored in text field and combobox in formula
however it somehow fail.
What is the correct syntax in formula?
Thanks?
damoncwkAsked:
Who is Participating?
 
Bozzie4Connect With a Mentor Commented:
The value in a field named MyField, can be accessed by it's name : eg. to show the field value in a dialogbox :

@prompt([ok];"Title";MyField)

That's valid for all fields, also comboboxes etc....

To access the value in the current field, you can (in R6) also use @thisvalue (or to access the field name : @thisname)

So if you for instance would want to change the field's value to all uppercase, you'd put in the Input Translation for the field MyField :

@uppercase(@thisvalue)

cheers,

Tom

0
 
Sjef BosmanGroupware ConsultantCommented:
What did you try?
0
 
Sjef BosmanGroupware ConsultantCommented:
Tom, I suppose this question is strongly related to the next one (CloseWindow fails).
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
damoncwkAuthor Commented:
thanks tom
it did work for text field, however when i try for rich text field as the field
contains lots of data then i tried the same method however cannot get
the rich text field value
any clues?
Thanks.
0
 
madheeswarCommented:
RTF field won't work.
0
 
Bozzie4Commented:
That is to say : not everything works for Rich Text.

For instance, you can't show Rich Text content in a view , and you can't edit rich text values in a combobox/prompt/whatever.

What exactly are you trying to do ?

cheers,

Tom
0
 
HemanthaKumarCommented:
To read RT Field content use @Abstract... Look into help for parameters.

This has to be in a computed field and use this field in view

~Hemanth
0
 
Bozzie4Commented:
Or, if you use R6, @text.
In R5 you are stuck with @Abstract, though

cheers,

Tom
0
 
qwaleteeCommented:
@Abstract only picks up changes after they are saved.

Don't use rich text fields where you don't absolutely have to.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.