Use Text Field As a Calculation

[jrr316]

Now this is interesting one.

I am trying to com up with a way to enter data into a text field that CONCATENATE's values from 2 data bases. I want to be able to type what I want into a text field and have that text field be used by a calculation. Here's what I got

Script Syntax: (Text Field user types into)= "CHANGEALIAS " & """ & FC_Users::Name_FirstLAst & """ & " " & """ & FC_Users::User ID & """

FC_Users is a related database.

So I type that in to my Syntax field, I now want a field that will CONCATENATE, via a calculation and spit out:

Script Calculation:CHANGEALIAS "Buildings & Grounds" "Buildings & Gro"

Any thoughts?

[Raybaudi]

Hi

something like this ?

Case(

Get(ActiveFieldName) = "yourField" ; yourField & """ & FC_Users::Name_FirstLAst & """ & " " & """ & FC_Users::User ID & """ ;

""

)

note: yourField is a text field with the option of AutoEnter/Replace a calculated value

[jrr316]

Almost, I figured out it was the evaluate function.

Evaluate(Syntax).

Very Cool

Thanks!

[Raybaudi]

Hi

you can use the Evaluate()function too...

Case(

not IsEmpty (yourField);

Evaluate(Quote ( yourField & " "" & FC_Users::Name_FirstLAst & """ & " " & """ & FC_Users::User ID & """ );yourField);

""

)