Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Copy value/text from other field

Topic Labels: Formulas
896 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Regards,
Kai

1 Reply 1

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}