Skip to main content
Solved

Creating a field formula If a user is selected a field from another table is looked up

  • November 20, 2024
  • 2 replies
  • 44 views
C
Forum|alt.badge.img+3

Hello,

I am currently running into the base exceeding automation limit and am trying to come up with a way to solve for multiple automations we have created by using a formula field or look up field.

Currently, we assign users to certain tasks and we have another field that displays their phone numbers (long text field).  I am trying to set up a formula where IF a user is selected, it would then lookup/display from another table that user's phone numbers that are list on table 2.

Is this process possible with Airtable?

Best answer by Ron_Daniel

Rather than assigning using a users field, I'd set up a table of users (probably the one you've got their phone numbers in) and link it. That way, you could just have a lookup field for the phone numbers. If a user is assigned, then their phone number will show. If not, then it won't.

2 replies

Ron_Daniel
Forum|alt.badge.img+21
  • Ron_Daniel
  • Inspiring
  • Answer
  • November 20, 2024

Rather than assigning using a users field, I'd set up a table of users (probably the one you've got their phone numbers in) and link it. That way, you could just have a lookup field for the phone numbers. If a user is assigned, then their phone number will show. If not, then it won't.

C
Forum|alt.badge.img+3
  • C-Goad
  • Author
  • New Participant
  • November 20, 2024

@Ron_Daniel Thanks so much!

Ron_Daniel
Terms & ConditionsAccessibility statement