Automation to update a long text field with the va...

[Kai_Muscher]

I am looking for a formular/function which lets me automatically copy/retrieve a value/text from the referece Field.

Regards,
Kai

[acdye]

Hi Kai!

I think what you may be looking for is “Look Up.” If you set your field to “Look Up” it will pull the information from the requested table/field. I use this as a way to display values such as shipping cost from my shipping table on my invoice table. If this isn’t clear, I can create a sample base for you to view.

Edit: After setting up the look up, you could reference look in the formula field to combine it with text using something like:

"The shipping total is: " & {Shipping Cost Pulled From Lookup}