Skip to main content

Copy value/text from other field

  • April 21, 2019
  • 1 reply
  • 20 views

Kai_Muscher
Forum|alt.badge.img+13

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

Regards,
Kai

1 reply

Forum|alt.badge.img+5
  • Participating Frequently
  • April 21, 2019

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}