Help

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

Topic Labels: Formulas
Solved
Jump to Solution
163 2
cancel
Showing results for 
Search instead for 
Did you mean: 
C-Goad
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

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.Screenshot 2024-11-20 at 4.08.51 PM.png

See Solution in Thread

2 Replies 2
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

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.Screenshot 2024-11-20 at 4.08.51 PM.png

C-Goad
4 - Data Explorer
4 - Data Explorer

@Ron_Daniel Thanks so much!