How to Use a Function in a Form


#1

This is probably really basic, but I can’t figure the Topic (above) out. I want to use “lookup” to retrieve information from another data base (“Friends”) in a form in database “Assets”. Both databases are open, and in the Formula Workshop the expression
lookup(“Friends”,“ID”,“3”,“First”) works just fine, and retrieves the expected result…
But in a form in the Assets database, the same function in a Text Display just shows the expression, not the results.

Once I (actually, you) solve that, I would like to replace the value “3” in the example above with a value in the fields “GoesTo” in the Friends database.
Help, please!


#2

I think you have to check the mode of the Text Display object.
When you are using “Literal Text”, you have to include the formula in curly brackets.

{lookup("Friends","ID","3","First")}

When you use “Formula” it should work without the brackets.


#3

Beautiful! Thank you!