• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

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?
0
damoncwk
Asked:
damoncwk
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
What did you try?
0
 
Bozzie4Commented:
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:
Tom, I suppose this question is strongly related to the next one (CloseWindow fails).
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now